private void ComboBox_RemarksTab_SelectionChangeCommitted(object sender, EventArgs e)
{
if (ComboBox_RemarksTab.SelectedIndex != 0)
{
int keyy = ((KeyValuePair <int, string>)ComboBox_RemarksTab.SelectedItem).Key;
UpdateRemarksControl remarksCt = new UpdateRemarksControl();
remarksModel remarksMd = remarksCt.getRemarksDetails(keyy);
//if (remarksMd.startDate==null || remarksMd.endDate == null)
//{
// MessageBox.Show("Please fill the Remarks details for this case in 'New Case' Tab and then try to Update", "Remarks details not Found!", MessageBoxButtons.OKCancel, MessageBoxIcon.Warning);
//}
if (remarksMd.comments == "")
{
MessageBox.Show("Please fill the Remarks details for this case in 'New Case' Tab and then try to Update", "Remarks details not Found!", MessageBoxButtons.OKCancel, MessageBoxIcon.Warning);
}
else
{
try
{
Case_StartDate.Value = DateTime.Parse(remarksMd.startDate);
Case_EndDate.Value = DateTime.Parse(remarksMd.endDate);
Case_AdditionalComments.Text = remarksMd.comments;
CaseStatus_Remarks.SelectedItem = remarksMd.status;
//LabelError_Personl.Text = person.message;
}
catch (Exception ex)
{
}
}
}
}
public bool updateData(remarksModel remarksMd)
{
if (remarksMd.comments == "")
{
return(false);
}
else
{
string Query = "";
try
{
using (SqlConnection connect = new SqlConnection(connection))
{
// Query = "insert into remarks_tb values('" + remarksMd.startDate + "','" + remarksMd.endDate + "','" + remarksMd.comments + "','" + remarksMd.status + "','" + remarksMd.caseSelected + "');";
Query = Query = "UPDATE remarks_tb SET startDate='" + remarksMd.startDate + "', endDate='" + remarksMd.endDate + "', comments='" + remarksMd.comments + "',status='" + remarksMd.status + "' WHERE person_id=" + remarksMd.caseSelected;
SqlCommand com = new SqlCommand(Query, connect);
connect.Open();
com.ExecuteNonQuery();
return(true);
}
}
catch (Exception e)
{
remarksMd.errorMessage = e.Message;
// remarksMd.errorMessage = "Somthing went wrong! Please try again";
return(false);
}
}
}
public remarksModel getRemarksDetails(int id)
{
string query = "select * from remarks_tb where person_id =" + id;
remarksModel remarksMd = new remarksModel();
try
{
using (SqlConnection connect = new SqlConnection(this.connection))
{
connect.Open();
SqlCommand com = new SqlCommand(query, connect);
SqlDataReader reader = com.ExecuteReader();
while (reader.Read())
{
remarksMd.startDate = reader["startDate"].ToString();
remarksMd.endDate = reader["endDate"].ToString();
remarksMd.comments = reader["comments"].ToString();
remarksMd.status = reader["status"].ToString();
}
return(remarksMd);
}
}
catch (Exception e)
{
remarksMd.errorMessage = e.Message;
return(remarksMd);
}
}
private void Button_SaveRemarks_Click(object sender, EventArgs e)
{
if (ComboBox_RemarksTab.SelectedIndex != 0)
{
int keyy = ((KeyValuePair <int, string>)ComboBox_RemarksTab.SelectedItem).Key;
//UpdatePersonalControl person_control = new UpdatePersonalControl();
//Case_Personal_Info person = person_control.getPersonalData(keyy);
UpdateRemarksControl remarksCt = new UpdateRemarksControl();
remarksModel remarksMd = remarksCt.getRemarksDetails(keyy);
remarksMd.startDate = Case_StartDate.Text;
remarksMd.endDate = Case_EndDate.Text;
remarksMd.comments = Case_AdditionalComments.Text;
remarksMd.status = CaseStatus_Remarks.Text;
remarksMd.caseSelected = keyy;
if (remarksCt.checkCaseType(remarksMd.caseSelected)) // check if case as Monthly
{
DateTime start_date = Case_StartDate.Value;
DateTime end_date = Case_EndDate.Value;
end_date = start_date.AddDays(31);
Case_EndDate.MinDate = end_date;
if (remarksCt.updateData(remarksMd))
{
MessageBox.Show("Details Updated Successfully");
}
else
{
MessageBox.Show(remarksMd.errorMessage);
}
}
else
{
if (remarksCt.updateData(remarksMd))
{
MessageBox.Show("Details Updated Successfully!");
}
else
{
MessageBox.Show(remarksMd.errorMessage);
}
}
}
else
{
MessageBox.Show("Please Select a Case from the Dropdwn", "Case not Selected", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
}
private void Button_SaveRemarks_Click(object sender, EventArgs e)
{
Label_ErrorMessage_Remarks.Text = "";
remarksModel remarksMd = new remarksModel();
remarksController remarksCt = new remarksController();
remarksMd.caseSelected = ComboBox_RemarksTab.SelectedIndex;
if (remarksMd.caseSelected != 0)
{
remarksMd.caseSelected = ((KeyValuePair <int, string>)ComboBox_RemarksTab.SelectedItem).Key;
if (remarksCt.IsAllreadyExisting(remarksMd.caseSelected))
{
MessageBox.Show("Details allready existing for this case!");
}
else
{
if (remarksCt.checkNeedetailsFilled(remarksMd))
{
remarksMd.startDate = Case_StartDate.Text;
remarksMd.endDate = Case_EndDate.Text;
remarksMd.comments = Case_AdditionalComments.Text;
remarksMd.status = CaseStatus_Remarks.Text;
if (remarksCt.checkCaseType(remarksMd.caseSelected)) // check if case as Monthly
{
DateTime start_date = Case_StartDate.Value;
DateTime end_date = Case_EndDate.Value;
end_date = start_date.AddDays(31);
Case_EndDate.MinDate = end_date;
if (remarksCt.insertData(remarksMd))
{
MessageBox.Show("Details Saved Successfully");
loadRemarksGrid(remarksMd.caseSelected);
Case_AdditionalComments.Text = "";
}
else
{
Label_ErrorMessage_Remarks.Text = remarksMd.errorMessage;
}
}
else
{
if (remarksCt.insertData(remarksMd))
{
MessageBox.Show("Details Saved Successfully!");
loadRemarksGrid(remarksMd.caseSelected);
Case_AdditionalComments.Text = "";
}
else
{
Label_ErrorMessage_Remarks.Text = remarksMd.errorMessage;
}
}
}
else
{
MessageBox.Show("Please fill the Need Details for this case in the previous tab.");
}
}
}
else
{
MessageBox.Show("Please Select a Case from the Dropdwn", "Case not Selected", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
}
