Comments by Branden Coker

Branden Coker 18-Dec-16 11:04am View

Jon,
I think I can figure this out from here. Thank you for all your help. The button I'm trying to get the ID to is actually a save button on the AddNewWitness View. The view has the ID from the defendant It's a matter of converting the data from the fields to the model and persisting it is where my issue is. This is what I'm doing on that..

 private void btnSaveWitness_Click(object sender, RoutedEventArgs e)
        {
            using (DataController context = new DataController())
            {
                DefendantViewModel defendant = new DefendantViewModel();

                defendant.DefendantModel.FirstName = txtFName.Text;
                defendant.DefendantModel.MiddleName = txtMName.Text;
                defendant.DefendantModel.LastName = txtLName.Text;
                defendant.DefendantModel.NameSuffix = txtSuffix.Text;
                defendant.DefendantModel.Race = cboRace.SelectedValue.ToString();
                defendant.DefendantModel.Sex = cboSex.SelectedValue.ToString();

                context.CreateWitness(defendant);
            }

Branden Coker 17-Dec-16 10:10am View

Jon, Thanks for your response. I forgot to mention that the ID comes from another view when someone selects a Defendant from a list. That part works, if I select the first person in the list I get the correct ID same with any other person. Both my DefendantModel and WitnessModels are below. Sorry I forgot to post them. I have the data access Logic (Linq) in a separate folder.

The Defendant Model:

   public class DefendantModel
    {
        public int ID { get; set; }
        public string FirstName { get; set; }
        public string MiddleName { get; set; }
        public string LastName { get; set; }
        public string NameSuffix { get; set; }
        public string Alias { get; set; }
        public string SSN { get; set; }
        public string Race { get; set; }
        public string Sex { get; set; }
        public List<WitnessModel> WitnessModelList { get; set; }
        public WitnessModel WitnessModel { get; set; }
    }

The WitnessModel:

 public class WitnessModel
    {
        public int ID { get; set; }
        public int MasterID { get; set; }
        public string FirstName { get; set; }
        public string MiddleName { get; set; }
        public string LastName { get; set; }
        public string NameSuffix { get; set; }
        public string Sex { get; set; }
        public string Race { get; set; }
    }

Let me know if I have left anything out. Thank you.

Branden Coker 24-Sep-14 15:27pm View

Thank you for your help as well Afzaal.

Branden Coker 24-Sep-14 15:27pm View

I was just "fine-tooth combing" my code and I did find that I missed typing in the Context. Thank you for your help. I'll know in the future where the error was made and sorry to waste your time.

Branden Coker 24-Sep-14 15:14pm View

I created the Model class which houses three classes (Student, Enrollment, Course). After I constructed the class I tried the migration and that is when it failed. I did not however create a SchoolContext as it was not in the tutorial.

I believe this is the complete tutorial and I would imagine they wouldn't skip anything like that being Microsoft but maybe I should run through it again. Thank you for your suggestion. I'll check it out.

Branden Coker 25-Jun-14 12:04pm View

Ok. I will search through my code for the casting. Thanks for the help!

Branden Coker 13-Jun-14 12:28pm View

I tried your solution phil and I get the message, "the key given does not exist in the dictionary.

Branden Coker 19-May-14 10:22am View

Thank you for all of your help! My server tag 'issue' was a typo I made myself.

Branden Coker 19-May-14 10:17am View

This is exactly what I'm trying currently and receiving "The server tag is not well formed"

<asp:textbox id="Textbox1" runat="server" text="<%# Bind("NameOfAgency") %>" width="248px" CssClass ="date" />

Branden Coker 16-May-14 23:35pm View

Thanks a bunch DamithSL. I'll try that on Monday forgot to bring my work laptop home :\ As always I appreciate all of the help from you guys! Have a great weekend!

Branden Coker 16-May-14 12:11pm View

This is what I've changed the code to:
<asp:textbox id="Textbox1" runat="server" text="<%# Bind("NameOfAgency") %>" width="248px" class="date" />

For some reason, it still says, "Error creating control, the server tag is not well formed" and there is a blue line under the entire string. Any ideas? I also copied the Script into my code as instructed. There is no problem with the script at the moment.

Branden Coker 15-May-14 10:12am View

If I may ask, what is the
<pre>xmlns:asp="#unkown"</pre> for?

I'm getting the message "error creating control, server tag is not well formed."

Branden Coker 15-May-14 8:30am View

Thank you very much for your responses.

j snooze, this is the error I'm receiving:

0x800a01b6 - JavaScript runtime error: Object doesn't support property or method 'datepick'

I'll read the text you've supplied Peter.

I'll also look into your code as well DamithSL. Thanks a bunch guys as always it's a pleasure learning from the community. Cheers!

Branden Coker 14-Mar-14 12:27pm View

This is my FillMethod I just named it FillByGUID so I could keep it straight in my mind.

SELECT REQUEST_ID, AGENCY_NAME, ORI, ADDRESS, CITY, STATE, ZIPCODE, REQUEST_TITLE, REQUEST_LNAME, REQUEST_FNAME, PHONE_NUMBER,
EXTENSION, SUPERVISOR_LNAME, SUPERVISOR_FNAME, SUPERVISOR_PHONE, CELL_PHONE, FAX_NUMBER, REQUEST_REASON,
SEARCHTYPE, ADDWHEN, DELETEWHEN, DELETEBY, DELETE_IND, MODIFYWHEN, MODIFYBY, RESULT, CRITERIA, INDICATOR
FROM LOGSCAN_REQUEST
WHERE (REQUEST_ID = @REQUEST_ID)

Branden Coker 10-Mar-14 9:53am View

Thank you for your help! It appears it is working correctly. Have a great day.

Branden Coker 6-Mar-14 11:38am View

That sounds pretty simple I'll give it a shot. Thank you for your help.

Branden Coker 6-Mar-14 11:29am View

How do I display the reports I've created in the combobox and then run those reports in my report viewer on button click?

Branden Coker 6-Mar-14 10:55am View

My apologies I should have specified. I don't have anything populated in my combobox. I have one report as of now in my project "CJ01_DateRange.rdlc" that won't show up in my combobox. I'm just doing a bunch of guess work here I'm not even sure if it is possible to load a file from the combobox.

Branden Coker 27-Feb-14 13:22pm View

Just wanted to give you a heads up! We figured it out. I couldn't have done it without your assistance. Thank you so much. Here is the code I have modified since our last discussion in my Form1 (MainWindow):

private void btnEdit_Click(object sender, EventArgs e)
{
System.Data.DataRowView selectedRowView;
cj96DataSet.cj96TBRiscRow selectedRow;

selectedRowView = (System.Data.DataRowView)this.cj96TBRiscBindingSource.Current;

selectedRow = (cj96DataSet.cj96TBRiscRow)selectedRowView.Row;

EditRecord editRecordForm = new EditRecord(GUID);
editRecordForm. EditRecord_Selected(selectedRow.CJ96GUID);
editRecordForm.Show();
}

Branden Coker 27-Feb-14 12:44pm View

Can you not call an internal void method? I was thinking that maybe the method just isn't running because I put a breakpoint at:

internal void EditRecord_Selected(Guid GUID)
{
this.cj96TBRiscTableAdapter.FillByGuid (this.cj96DataSet.cj96TBRisc, GUID);
}

and nothing happens. The application doesn't break.

Branden Coker 27-Feb-14 12:28pm View

any suggestions on how to do that? I appreciate your patience Paddy84!

Branden Coker 27-Feb-14 12:24pm View

Okay, yes I do have all of the values for the selected row in my locals when I do that. So I'm guessing that means I'm close?

Branden Coker 27-Feb-14 12:13pm View

It doesn't :( I'm sure it's nothing you suggested that is the problem. I'm new and I'm sure I'm the problem! It's just frustrating trying to learn a new language on a deadline.

Branden Coker 27-Feb-14 12:07pm View

That's the key to the table I'm using it's a long string of numbers/chars completely unique to one another and generated from a sister program a coworker has written. I just stepped through the code again putting the break on my btnEdit and as of now there is no value for the GUID selected in the table. I do however have the GUID field visible="false" in the table because it takes up to much screen real estate and it is not relevant to the users of the system. Maybe that is the issue since it isn't displayed it can't pull it. The value is there in my SQL query though. I'm going to look at some examples I found from school and see if I can figure it out that way. I will post an answer if you are interested on my findings.

Branden Coker 27-Feb-14 11:51am View

I just tried it an it didn't populate anything. I can step my program from the btnEdit and the variable for the GUID is in my output it's just not getting to the control on my EditForm.

Branden Coker 27-Feb-14 10:25am View

Honestly I'm not sure I called it. So you think it should look like this?

public EditRecord(Guid GUID)
{
this.GUID = GUID;
InitializeComponent();
this.cj96TBRiscTableAdapter.FillByGuid(this.cj96DataSet.cj96TBRisc, GUID);

}

Branden Coker 27-Feb-14 9:53am View

Yes that is correct. I think I mentioned in a previous post that I set my parameter in the SQL query I've written to GUID. I'm just trying to pull the selected GUID from Form1 to populate the fields in EditRecord. It seems like it should be a simple task but I'm fairly new at the IDE as well. I do appreciate your help greatly though.

Branden Coker 27-Feb-14 9:36am View

Here is the code from my Form1 (MainWindow). I'm pretty new to C# I've been an iOS person for a while and not used to working with SQL Data Tables:

using System;
using System.Collections.Generic;
using System.ComponentModel;
using System.Data;
using System.Drawing;
using System.Linq;
using System.Text;
using System.Threading.Tasks;
using System.Windows.Forms;

namespace WFRiscIDAdmin
{
public partial class Form1 : Form
{
public Form1()
{
InitializeComponent();
}

private void cj96TBRiscBindingNavigatorSaveItem_Click(object sender, EventArgs e)
{
this.Validate();
this.cj96TBRiscBindingSource.EndEdit();
this.tableAdapterManager.UpdateAll(this.cj96DataSet);

}

private void Form1_Load(object sender, EventArgs e)
{
// TODO: This line of code loads data into the 'cj96DataSet.cj96TBRisc' table. You can move, or remove it, as needed.
this.cj96TBRiscTableAdapter.Fill(this.cj96DataSet.cj96TBRisc);

}

private void cj96TBRiscBindingSource_CurrentChanged(object sender, EventArgs e)
{
int currentRecNum = cj96TBRiscBindingSource.Position +1;
txtGUID.Text = currentRecNum.ToString();
}

private void ShowRecNum()
{
try
{
int intRecNum = Convert.ToInt32(txtGUID.Text);
if (intRecNum >= 1 && intRecNum <= cj96TBRiscBindingSource.Count)
{
cj96TBRiscBindingSource.Position = intRecNum - 1;
}
else
{
MessageBox.Show("Please enter a value between 1 and " + cj96TBRiscBindingSource.Count);
txtGUID.Text = (cj96TBRiscBindingSource.Position + 1).ToString();
txtGUID.Focus();
}
}
catch
{
MessageBox.Show("Please enter a numeric value.");
txtGUID.Text = (cj96TBRiscBindingSource.Position + 1).ToString();
txtGUID.Focus();
}
}

private void cbBookingTcn_CheckedChanged(object sender, EventArgs e)
{
if (cbBookingTcn.Checked)
{
cj96TBRiscBindingSource.Filter = "CJ96TCN = 'BKNG'";
}
else
{
cj96TBRiscBindingSource.RemoveFilter();
}
}

private void cbPendingMoreThanSevenDays_CheckedChanged(object sender, EventArgs e)
{
if (cbPendingMoreThanSevenDays.Checked)
{
this.cj96TBRiscTableAdapter.FillByPendingSevenDays(this.cj96DataSet.cj96TBRisc);
}
else
{
this.cj96TBRiscTableAdapter.Fill(this.cj96DataSet.cj96TBRisc);
}
}

private void cboFilterStatus_SelectedIndexChanged(object sender, EventArgs e)
{

}

private void btnClear_Click(object sender, EventArgs e)
{
this.cj96TBRiscTableAdapter.Fill(this.cj96DataSet.cj96TBRisc);
}

private void btnEdit_Click(object sender, EventArgs e)
{
System.Data.DataRowView selectedRowView;
cj96DataSet.cj96TBRiscRow selectedRow;

selectedRowView = (System.Data.DataRowView)this.cj96TBRiscBindingSource.Current;

selectedRow = (cj96DataSet.cj96TBRiscRow)selectedRowView.Row;
EditRecord editRecord = new EditRecord(GUID);
editRecord.Visible = true;

editRecord.Show();

}

public Guid GUID { get; set; }
}
}

Branden Coker 27-Feb-14 9:17am View

One more question. I thought I had it working and I'm not getting any errors, but when I launch the EditRecord form, now my form isn't populating. Here is the EditRecord code (if you have a chance):

using System;
using System.Collections.Generic;
using System.ComponentModel;
using System.Data;
using System.Drawing;
using System.Linq;
using System.Text;
using System.Threading.Tasks;
using System.Windows.Forms;

namespace WFRiscIDAdmin
{
public partial class EditRecord : Form
{
private Guid GUID;
public EditRecord(Guid GUID)
{
this.GUID = GUID;
InitializeComponent();
}

private void cj96TBRiscBindingNavigatorSaveItem_Click(object sender, EventArgs e)
{
this.Validate();
this.cj96TBRiscBindingSource.EndEdit();
this.tableAdapterManager.UpdateAll(this.cj96DataSet);

}

private void EditRecord_Load(object sender, EventArgs e)
{

}

internal void EditRecord_Selected(Guid GUID)
{
this.cj96TBRiscTableAdapter.FillByGuid (this.cj96DataSet.cj96TBRisc, GUID);
}

private void btnCancelChanges_Click(object sender, EventArgs e)
{
this.Close();
}
}
}

Branden Coker 26-Feb-14 10:09am View

Thank you also for the Solution OriginalGiff. I will read through the articles you've supplied me. Cheers!

Branden Coker 26-Feb-14 9:42am View

Thank you so much Paddy84! You have helped me out tremendously.

Comments by Branden Coker (Top 31 by date)