private void dgv_hstry_vol_CellDoubleClick(object sender, DataGridViewCellEventArgs e)
{
int i = dgv_hstry_vol.CurrentRow.Index;
int id = int.Parse(dgv_hstry_vol.Rows[i].Cells["Sub ID"].Value.ToString());
req_sub = DBAccess.get_request_sub(id);
if (req_sub != null)
{
try
{
frm_req_sub.reqSubID = req_sub.SubID;
frm_req_sub.reqID = req_sub.ReqID;
frm_req_sub.reportID = req_sub.ReportID;
frm_req_sub.volID = req_sub.VolID;
frm_req_sub.cmbSector.Text = req_sub.SectorID;
frm_req_sub.txtRefNo.Text = req_sub.VolRefno;
frm_req_sub.txtVolName.Text = req_sub.VolName;
frm_req_sub.txtWFP.Text = req_sub.WFP1;
frm_req_sub.txtPlacementRpt.Text = req_sub.PlacementRpt;
frm_req_sub.txtInitialRpt.Text = req_sub.InitialRpt;
frm_req_sub.txtAnnualRPt.Text = req_sub.AnnualRpt;
frm_req_sub.txtEndOfAssigment.Text = req_sub.EndOfAssignment;
frm_req_sub.txtBatchNumber.Text = req_sub.BatchNumber;
frm_req_sub.txtStartOfAssistance.Text = req_sub.StartAssistance;
frm_req_sub.txtEndOfAssistance.Text = req_sub.EndAssistance;
frm_req_sub.cmbVolStatus.Text = req_sub.VolunteerStatus;
frm_req_sub.cmbSpecialization.Text = req_sub.SpecializationID;
frm_req_sub.cmbSpecializationSub.Text = req_sub.SpecializationSubID;
frm_req_sub.txtsectr.Text = req_sub.SectorID;
frm_req_sub.txtspec.Text = req_sub.SpecializationID;
frm_req_sub.txtspec_sub.Text = req_sub.SpecializationSubID;
frm_req_sub.rtbActivitiesAndAccmplshmnt.Text = req_sub.ActivitiesAndAccmplsmnt;
frm_req_sub.rtbIssueAndConcern.Text = req_sub.IssueAndConcerns;
frm_req_sub.rtbRecommendation.Text = req_sub.Recommendations;
frm_req_sub.rtbMajorOutput.Text = req_sub.MajorOutput;
frm_req_sub.rtfOutcomes.Text = req_sub.Outcomes;
// MemoryStream ms = new MemoryStream((byte[])req_sub.VolPiture);
// frm_req_sub.pbVolunteer.Image = Image.FromFile("" + req_sub.VolPiture);
if (req_sub.VolPiture != "")
{
try
{
frm_req_sub.pbVolunteer.Image = Image.FromFile("" + req_sub.VolPiture);
}
catch (FileNotFoundException ex)
{ }
}
// volOrg = txtVolOrg.Text;
frm_req_sub.btnsearch.Visible = false;
frm_req_sub.btnSave.Visible = false;
// frm_req_sub.btnUpdate.Enabled = false;
frm_req_sub.ShowDialog();
}
catch (IndexOutOfRangeException ex)
{
MessageBox.Show(ex.Message, "Incomplete Data!", MessageBoxButtons.OK,
MessageBoxIcon.Error);
}
}
else
{
MessageBox.Show("Null");
}
}
private void btnSave_Click(object sender, EventArgs e)
{
if (txtStartOfAssistance.Text == string.Empty && txtEndOfAssistance.Text != string.Empty)
{
MessageBox.Show("Please input dates!", "", MessageBoxButtons.OK,
MessageBoxIcon.Error);
}
else if (txtStartOfAssistance.Text != string.Empty && txtEndOfAssistance.Text == string.Empty)
{
MessageBox.Show("Please input dates!", "", MessageBoxButtons.OK,
MessageBoxIcon.Error);
}
else if (txtRefNo.Text == string.Empty)
{
MessageBox.Show("Please select Volunteer!", "", MessageBoxButtons.OK,
MessageBoxIcon.Error);
lblerror2.Visible = true;
}
else
{
if (txtStartOfAssistance.Text != string.Empty && txtEndOfAssistance.Text != string.Empty)
{
DateTime start = Convert.ToDateTime(txtStartOfAssistance.Text);
DateTime end = Convert.ToDateTime(txtEndOfAssistance.Text);
if (start > end)
{
MessageBox.Show("Incorrect dates!", "", MessageBoxButtons.OK,
MessageBoxIcon.Error);
}
else
{
try
{
int sector = DBAccess.get_cmb_data(cmbSector.Text, "sp_get_cmb_sector", "sector_id");
int spec = DBAccess.get_cmb_data(cmbSpecialization.Text, "sp_get_cmb_specialization", "specialization_id");
int spec_sub;
int vol_status = DBAccess.get_cmb_data(cmbVolStatus.Text, "sp_get_cmb_vol_status", "status_id");
int vol = DBAccess.get_cmb_data(txtRefNo.Text, "sp_get_vol_id", "vol_id");
if (cmbSpecializationSub.Text == "")
{
spec_sub = 1;
}
else
{
spec_sub = DBAccess.get_cmb_data(cmbSpecializationSub.Text, "`sp_get_cmb_specializationSUB`", "specialization_sub_id");
}
req_sub = new requestSub(
req_id_for_add,
sector.ToString(),
spec.ToString(),
spec_sub.ToString(),
txtBatchNumber.Text.Trim(),
vol_status.ToString(),
vol,
txtStartOfAssistance.Text.Trim(),
txtEndOfAssistance.Text.Trim(),
txtWFP.Text.Trim(),
txtPlacementRpt.Text.Trim(),
txtInitialRpt.Text.Trim(),
txtAnnualRPt.Text.Trim(),
txtEndOfAssigment.Text.Trim(),
rtbActivitiesAndAccmplshmnt.Text,
rtbIssueAndConcern.Text,
rtbRecommendation.Text,
rtbMajorOutput.Text,
rtfOutcomes.Text
);
DBAccess.insert_request_sub(req_sub);
MessageBox.Show("Successfully Added!", "", MessageBoxButtons.OK,
MessageBoxIcon.Information);
logs = new auditTrail(frm_login.UserName, "Added Request sub of request ID " + Req_id_for_add);
DBAccess.insert_logs(logs);
v = new volunteer(txtRefNo.Text, txtvolstatus.Text);
DBAccess.update_volunteer_status(v);
this.Close();
}
catch (Exception ex)
{
MessageBox.Show(ex.Message + "\n" + ex.StackTrace);
}
}
}
else
{
try
{
int sector = DBAccess.get_cmb_data(cmbSector.Text, "sp_get_cmb_sector", "sector_id");
int spec = DBAccess.get_cmb_data(cmbSpecialization.Text, "sp_get_cmb_specialization", "specialization_id");
int spec_sub;
int vol_status = DBAccess.get_cmb_data(cmbVolStatus.Text, "sp_get_cmb_vol_status", "status_id");
int vol = DBAccess.get_cmb_data(txtRefNo.Text, "sp_get_vol_id", "vol_id");
if (cmbSpecializationSub.Text == "")
{
spec_sub = 1;
}
else
{
spec_sub = DBAccess.get_cmb_data(cmbSpecializationSub.Text, "`sp_get_cmb_specializationSUB`", "specialization_sub_id");
}
req_sub = new requestSub(
req_id_for_add,
sector.ToString(),
spec.ToString(),
spec_sub.ToString(),
txtBatchNumber.Text.Trim(),
vol_status.ToString(),
vol,
txtStartOfAssistance.Text.Trim(),
txtEndOfAssistance.Text.Trim(),
txtWFP.Text.Trim(),
txtPlacementRpt.Text.Trim(),
txtInitialRpt.Text.Trim(),
txtAnnualRPt.Text.Trim(),
txtEndOfAssigment.Text.Trim(),
rtbActivitiesAndAccmplshmnt.Text,
rtbIssueAndConcern.Text,
rtbRecommendation.Text,
rtbMajorOutput.Text,
rtfOutcomes.Text
);
DBAccess.insert_request_sub(req_sub);
MessageBox.Show("Successfully Added!", "", MessageBoxButtons.OK,
MessageBoxIcon.Information);
logs = new auditTrail(frm_login.UserName, "Added Request sub of request ID " + Req_id_for_add);
DBAccess.insert_logs(logs);
v = new volunteer(txtRefNo.Text, txtvolstatus.Text);
DBAccess.update_volunteer_status(v);
this.Close();
}
catch (Exception ex)
{
MessageBox.Show(ex.Message + "\n" + ex.StackTrace);
}
}
}
}
