void DatagridSelect(object sender, DataGridViewCellEventArgs e)
{
try
{
oMCandidate = new Model.Candidate();
if (dgCandidates.Rows.Count > 0 && e.RowIndex >= 0)
{
oMCandidate.UNIQUE_ID = dgCandidates.Rows[e.RowIndex].Cells[0].Value.ToString();
oMCandidate.FIRST_NAME = dgCandidates.Rows[e.RowIndex].Cells[1].Value.ToString();
oMCandidate.MIDDLE_NAME = dgCandidates.Rows[e.RowIndex].Cells[2].Value.ToString();
oMCandidate.LAST_NAME = dgCandidates.Rows[e.RowIndex].Cells[3].Value.ToString();
oMCandidate.DOB = dgCandidates.Rows[e.RowIndex].Cells[4].Value.ToString();
oMCandidate.AGE = dgCandidates.Rows[e.RowIndex].Cells[5].Value.ToString();
oMCandidate.COURSE = dgCandidates.Rows[e.RowIndex].Cells[6].Value.ToString();
oMCandidate.SECTION = dgCandidates.Rows[e.RowIndex].Cells[7].Value.ToString();
oMCandidate.CONTACT_NO = dgCandidates.Rows[e.RowIndex].Cells[8].Value.ToString();
oMCandidate.ADDRESS = dgCandidates.Rows[e.RowIndex].Cells[9].Value.ToString();
oMCandidate._Position.ID = dgCandidates.Rows[e.RowIndex].Cells[10].Value.ToString();
oMCandidate._Position.POSITION = dgCandidates.Rows[e.RowIndex].Cells[11].Value.ToString();
oMCandidate._Party.ID = dgCandidates.Rows[e.RowIndex].Cells[12].Value.ToString();
oMCandidate._Party.PARTY = dgCandidates.Rows[e.RowIndex].Cells[13].Value.ToString();
oMCandidate.PROFILE_PIC = dgCandidates.Rows[e.RowIndex].Cells[14].Value.ToString();
oMCandidate.ELECTION_CODE = dgCandidates.Rows[e.RowIndex].Cells[15].Value.ToString();
}
}
catch (Exception ex)
{
}
}
public frmCandidateEntry(frmCandidateList oFrmCandidate, Model.Candidate oData)
{
InitializeComponent();
oMCandidate = oData;
oFrmCandidateList = oFrmCandidate;
eVariable.DisablePanelTextKeyPress(pnlMain);
}
private void btnSave_Click(object sender, EventArgs e)
{
oCandidate = new DataAccess.Candidate();
oImageConvert = new CommonFunction.CommonFunction();
foreach (var oText in pnlMain.Controls.OfType <TextBox>().ToList())
{
if (oText.Text.Trim() == String.Empty)
{
oFrmMsgBox = new frmMessageBox("All fields are required.");
oFrmMsgBox.MessageType = frmMessageBox.MESSAGE_TYPE.INFO;
oFrmMsgBox.ShowDialog();
return;
}
}
oMCandidate = new Model.Candidate();
oMCandidate.UNIQUE_ID = eVariable.sID;
oMCandidate._Position.ID = eVariable.sPositionID;
oMCandidate._Party.ID = eVariable.sPartyID;
oMCandidate.ELECTION_CODE = lblElectionNo.Text;
oMCandidate.DATE_ADDED = DateTime.Now.ToString("yyyy-MM-dd");
oMCandidate.ADDED_BY = eVariable.sUsername;
if (txtParty.Text != "INDEPENDENT")
{
if (oCandidate.IsSamePositionAndParty(oMCandidate))
{
oFrmMsgBox = new frmMessageBox("THERE SHOULD BE ONLY ONE POSITION PER PARTY");
oFrmMsgBox.MessageType = frmMessageBox.MESSAGE_TYPE.INFO;
oFrmMsgBox.ShowDialog();
return;
}
}
oStringUtility = new CommonFunction.CommonFunction();
if (pImage.Image != null)
{
oMCandidate.PROFILE_PIC = oStringUtility.CompressString(oImageConvert.ImageToBaseString(pImage.Image, ImageFormat.Png));
}
if (TransactionType == eVariable.TransactionType.EDIT)
{
oMCandidate.MODIFIED_DATE = DateTime.Now.ToString("yyyy-MM-dd");
oMCandidate.MODIFIED_BY = eVariable.sUsername;
oCandidate.UpdateCandidate(oMCandidate);
}
else
{
oCandidate.InsertCandidate(oMCandidate);
}
oFrmCandidateList.LoadCandidates();
oFrmMsgBox = new frmMessageBox("Record has been successfully saved.");
oFrmMsgBox.MessageType = frmMessageBox.MESSAGE_TYPE.INFO;
oFrmMsgBox.ShowDialog();
Close();
}
public async Task <bool> NewCandidate(Model.Candidate candidate)
{
try
{
var content = new StringContent(JsonConvert.SerializeObject(candidate));
var response = await _client.PostAsync("/candidates", content);
return(response.IsSuccessStatusCode);
}
catch (Exception e)
{
return(false);
}
}
public void UpdateCandidate(Model.Candidate oData)
{
try
{
osb.ConnectionString = sConnectionString;
ddq = new DatabaseQuery.DBQuery();
ddq.ConnectionString = osb.ConnectionString;
ddq.CommandText = "Update tbl_Candidates set POSITION_ID = '" + oData._Position.ID + "',PARTY_ID = '" + oData._Party.ID + "',PROFILE_PIC = '" + oData.PROFILE_PIC + "',ELECTION_CODE = '" + oData.ELECTION_CODE + "' where CANDIDATE_ID = '" + oData.UNIQUE_ID + "'";
ddq.ExecuteNonQuery(CommandType.Text);
}
catch (Exception ex)
{
throw ex;
}
}
private void btnCandidate_Click(object sender, RoutedEventArgs e)
{
if ((tbLogin.Text == "Login") || (tbLogin.Text == ""))
{
MessageBox.Show("Veuillez renseigner un nom d'utilisateur");
}
else
{
Model.Candidate candidate = new Model.Candidate(vmStart.lstjobs);
candidate.Surname = tbLogin.Text;
View.wCandidatMenu pg = new View.wCandidatMenu(candidate);
pg.WindowStartupLocation = System.Windows.WindowStartupLocation.CenterScreen;
pg.Show();
this.Close();
}
}
public void InsertCandidate(Model.Candidate oData)
{
try
{
osb.ConnectionString = sConnectionString;
ddq = new DatabaseQuery.DBQuery();
ddq.ConnectionString = osb.ConnectionString;
ddq.CommandText = "Insert Into tbl_candidates (CANDIDATE_ID,PROFILE_PIC,POSITION_ID,PARTY_ID,ELECTION_CODE,ADDED_DATE) Values ('" + oData.UNIQUE_ID + "','" + oData.PROFILE_PIC + "','" + oData._Position.ID + "','" + oData._Party.ID + "','" + oData.ELECTION_CODE + "','" + oData.DATE_ADDED + "')";
ddq.ExecuteNonQuery(CommandType.Text);
}
catch (Exception ex)
{
throw ex;
}
}
public Boolean IsCandidatIeExists(Model.Candidate oData)
{
try
{
osb.ConnectionString = sConnectionString;
ddq = new DatabaseQuery.DBQuery();
ddq.ConnectionString = osb.ConnectionString;
ddq.CommandText = "SELECT * FROM TBL_CANDIDATES WHERE CANDIDATE_ID = '" + oData.UNIQUE_ID + "'";
ds = ddq.GetDataset(CommandType.Text);
return(ds.Tables[0].Rows.Count > 0 ? true : false);
}
catch (Exception ex)
{
throw ex;
}
}
public Boolean IsSamePositionAndParty(Model.Candidate oData)
{
try
{
osb.ConnectionString = sConnectionString;
ddq = new DatabaseQuery.DBQuery();
ddq.ConnectionString = osb.ConnectionString;
ddq.CommandText = "SELECT * FROM TBL_CANDIDATES WHERE POSITION_ID = '" + oData._Position.ID + "' AND PARTY_ID = '" + oData._Party.ID + "' AND STATUS = 'ACTIVE' AND ELECTION_CODE = '" + oData.ELECTION_CODE + "'";
ds = ddq.GetDataset(CommandType.Text);
return(ds.Tables[0].Rows.Count > 0 ? true : false);
}
catch (Exception ex)
{
throw ex;
}
}
public Candidate(Model.Candidate candidate)
{
this.ID = candidate.ID;
this.Type = candidate.Type.Name;
this.Status = candidate.Status.Name;
}
