public JsonResult Delete(int id)
{
try
{
if (id == 0)
{
return(Json(new { responseCode = "-10" }));
}
CivilStatus model = this._civilStatusBusiness.GetCivilStatus(id);
model.Enable = false;
this._civilStatusBusiness.Save(model);
var responseObject = new
{
responseCode = 0
};
return(Json(responseObject));
}
catch (Exception)
{
return(Json(new { responseCode = "-10" }));
}
}
public CivilStatus SelectBy(int statusId)
{
CivilStatus c = new CivilStatus();
string selectBy = "balaji.SP_SEARCHBY_CivilStatus_HR_Batch4";
try
{
cmd = new SqlCommand(selectBy, con);
cmd.Parameters.AddWithValue("@aStatusId", statusId);
cmd.CommandType = System.Data.CommandType.StoredProcedure;
con.Open();
dr = cmd.ExecuteReader();
if (dr.Read())
{
c.StatusId = statusId;
c.StatusDescription = dr[1].ToString();
}
}
catch (CivilStatusException)
{
throw;
}
catch (Exception)
{
throw;
}
finally
{
dr.Close();
con.Close();
}
return(c);
}
//Method to Add CivilStat to Database
public static int AddCivilStat(CivilStatus newCivilStat)
{
int rowsAffected = 0;
try
{
//Creating command object
SqlCommand civilStatCommand = DataConnections.GenerateCommand();
//Assigning command text
civilStatCommand.CommandText = "Group4.usp_AddCivilStatus";
//Adding parameters to command
civilStatCommand.Parameters.AddWithValue("@Status_Description", newCivilStat.StatusDescription);
//Executing command
civilStatCommand.Connection.Open();
rowsAffected = civilStatCommand.ExecuteNonQuery();
civilStatCommand.Connection.Close();
}
catch (SqlException ex)
{
throw ex;
}
catch (Exception ex)
{
throw ex;
}
return(rowsAffected);
}
public bool validateCivilStatus(CivilStatus civil)
{
bool validate = true;
StringBuilder builderObj = new StringBuilder();
try
{
if (civil.StatusDescription == string.Empty)
{
builderObj.AppendLine("Status Description Should be Provided..");
validate = false;
}
if (validate == false)
{
throw new CivilStatusException(builderObj.ToString());
}
}
catch (CivilStatusException ex)
{
throw ex;
}
catch (Exception ex)
{
throw ex;
}
return(validate);
}
protected override EmployeeInfo Parse()
{
return(new EmployeeInfo
{
ID = ToInt(ID),
EmployeeNumber = EmployeeNumber.ToString(),
FirstName = FirstName.ToString(),
LastName = LastName.ToString(),
MI = MI.ToString(),
Email = Email.ToString(),
Password = Password.ToString(),
Contact = Contact.ToString(),
Address = Address.ToString(),
Birthday = Birthday.ToString(),
Gender = Gender.ToString(),
Religion = Religion.ToString(),
Nationality = Nationality.ToString(),
Birthplace = Birthplace.ToString(),
CivilStatus = CivilStatus.ToString(),
EmployeeStatusID = ToInt(EmployeeStatusID),
DateHired = DateHired.ToString(),
DateCreated = DateCreated.ToString(),
DatedUpdated = DatedUpdated.ToString(),
DatedDeleted = DatedDeleted.ToString(),
RoleID = ToInt(RoleID),
EmployeeStatus = EmployeeStatus.ToString(),
RoleStatus = RoleStatus.ToString()
});
}
public JsonResult CivilStatusUpdate(string action)
{
var civilStatusUpdateList = new List <CivilStatus>();
var civilStatusList = this.CivilStatusService.GetCivilStatus().Select(m => m.CivilStatusId).ToList();
int recordCount = civilStatusList.Count;
int recordIndex = 0;
if (action == "create")
{
string civilStatus1 = Request.Form["data[0][CivilStatus1]"].ToString();
string civilStatusCode = Request.Form["data[0][CivilStatusCode]"].ToString();
bool hidden = bool.Parse(Request.Form["data[0][Hidden]"].ToString());
var civilStatus = new CivilStatus()
{
CivilStatus1 = civilStatus1,
CivilStatusCode = civilStatusCode,
Hidden = hidden
};
civilStatusUpdateList.Add(civilStatus);
this.CivilStatusService.InsertCivilStatus(civilStatusUpdateList[0]);
}
else
{
do
{
if (Request.Form[string.Format("data[{0}][CivilStatus1]", civilStatusList[recordIndex])] != null)
{
int CivilStatusId = civilStatusList[recordIndex];
string CivilStatus1 = Request.Form[string.Format("data[{0}][CivilStatus1]", civilStatusList[recordIndex])].ToString();
string civilStatusCode = Request.Form[string.Format("data[{0}][CivilStatusCode]", civilStatusList[recordIndex])].ToString();
bool hidden = bool.Parse(Request.Form[string.Format("data[{0}][Hidden]", civilStatusList[recordIndex])].ToString());
CivilStatus CivilStatus = new CivilStatus()
{
CivilStatusId = CivilStatusId,
CivilStatus1 = CivilStatus1,
CivilStatusCode = civilStatusCode,
Hidden = hidden
};
civilStatusUpdateList.Add(CivilStatus);
}
recordIndex++;
}while (recordIndex < recordCount);
for (int i = 0; i < civilStatusUpdateList.Count; i++)
{
switch (action)
{
case "edit":
this.CivilStatusService.UpdateCivilStatus(civilStatusUpdateList[i]);
break;
case "remove":
this.CivilStatusService.DeleteCivilStatus(civilStatusUpdateList[i].CivilStatusId);
break;
}
}
}
return(Json(new { data = civilStatusUpdateList }, JsonRequestBehavior.AllowGet));
}
//Validation of Details
public static bool ValidatCivilStatus(CivilStatus newCVS)
{
bool isValidCVS = true;
StringBuilder sbError = new StringBuilder();
try
{
if (newCVS.StatusDescription == string.Empty)
{
isValidCVS = false;
sbError.Append("Please Enter CivilStatus Description");
}
if (!isValidCVS)
{
throw new HRMSException(sbError.ToString());
}
}
catch (SqlException ex)
{
throw ex;
}
catch (HRMSException ex)
{
throw ex;
}
return(isValidCVS);
}
public Marriage(int applicationID, int ministerID, string registryNumber, string pageNumber, string recordNumber, string remarks, DateTime sacramentDate, DateTime licenseDate, CivilStatus groomStatus, CivilStatus brideStatus)
: base(applicationID, ministerID, registryNumber, pageNumber, recordNumber, remarks, sacramentDate)
{
this._licenseDate = licenseDate;
this._groomStatus = groomStatus;
this._brideStatus = brideStatus;
}
public void Insert(CivilStatus c)
{
string insert = "balaji.SP_INSERT_CivilStatus_HR_Batch4";
try
{
cmd = new SqlCommand(insert, con);
cmd.Parameters.AddWithValue("@aStatusDescription", c.StatusDescription);
cmd.CommandType = System.Data.CommandType.StoredProcedure;
con.Open();
cmd.ExecuteNonQuery();
}
catch (CivilStatusException)
{
throw;
}
catch (Exception)
{
throw;
}
finally
{
con.Close();
}
}
public void Update(CivilStatus c)
{
int qn;
string update = "balaji.SP_UPDATE_CivilStatus_HR_Batch4";
try
{
cmd = new SqlCommand(update, con);
cmd.Parameters.AddWithValue("@aStatusId", c.StatusId);
cmd.Parameters.AddWithValue("@aStatusDescription", c.StatusDescription);
cmd.CommandType = System.Data.CommandType.StoredProcedure;
con.Open();
qn = cmd.ExecuteNonQuery();
}
catch (CivilStatusException)
{
throw;
}
catch (Exception)
{
throw;
}
finally
{
con.Close();
}
}
private void Update(CivilStatus civilStatus)
{
CivilStatus model = GetCivilStatus(civilStatus.Id);
model.Name = civilStatus.Name;
this.repository.Update(model);
}
public ActionResult DeleteConfirmed(int id)
{
CivilStatus civilStatus = db.CivilStatus.Find(id);
db.CivilStatus.Remove(civilStatus);
db.SaveChanges();
return(RedirectToAction("Index"));
}
public ActionResult Edit([Bind(Include = "Id,Name")] CivilStatus civilStatus)
{
if (ModelState.IsValid)
{
db.Entry(civilStatus).State = EntityState.Modified;
db.SaveChanges();
return(RedirectToAction("Index"));
}
return(View(civilStatus));
}
public void Save(CivilStatus civilStatus)
{
if (civilStatus.Id > 0)
{
Update(civilStatus);
}
else
{
Create(civilStatus);
}
}
public ActionResult Create([Bind(Include = "Id,Name")] CivilStatus civilStatus)
{
if (ModelState.IsValid)
{
db.CivilStatus.Add(civilStatus);
db.SaveChanges();
return(RedirectToAction("Index"));
}
return(View(civilStatus));
}
//private void btnAddSponsor_Click(object sender, EventArgs e)
//{
// string fn = txtSponsor1FN.Text;
// string mi = txtSponsor1MI.Text;
// string ln = txtSponsor1LN.Text;
// string suffix = txtSponsor1Suffix.Text;
// string res = txtSponsor1Residence.Text;
// Gender g = radioSponsor1Male.Checked ? Gender.Male : Gender.Female;
// int i = dgvSponsor.Rows.Add();
// dgvSponsor.Rows[i].Cells["firstName"].Value = fn;
// dgvSponsor.Rows[i].Cells["midName"].Value = mi;
// dgvSponsor.Rows[i].Cells["lastName"].Value = ln;
// dgvSponsor.Rows[i].Cells["suffix"].Value = suffix;
// dgvSponsor.Rows[i].Cells["residence"].Value = res;
// dgvSponsor.Rows[i].Cells["gender"].Value = radioSponsor1Male.Checked ? 1 : 2;
// txtSponsor1FN.Text = "";
// txtSponsor1MI.Text = "";
// txtSponsor1LN.Text = "";
// txtSponsor1Suffix.Text = "";
// txtSponsor1Residence.Text = "";
// radioSponsor1Male.Select();
// btnAddSponsor.Enabled = !(dgvSponsor.Rows.Count == 2);
//}
private void btnSubmit_Click(object sender, EventArgs e)
{
if (!allFilled())
{
MessageDialog.Show("Please input all necessary fields!", "Missing fields", MessageDialogButtons.OK, MessageDialogIcon.Warning);
return;
}
//get applicationID
int applicationID = int.Parse(row["applicationID"].ToString());
//get groomID, brideID
int groomID = int.Parse(row["groomID"].ToString());
int brideID = int.Parse(row["brideID"].ToString());
DateTime licenseDate = dtpLicenseDate.Value;
DateTime marriageDate = dtpMarriageDate.Value;
CivilStatus groomCS = (CivilStatus)cmbGStatus.SelectedValue;
CivilStatus brideCS = (CivilStatus)cmbBStatus.SelectedValue;
int ministerID = Convert.ToInt32(((ComboboxContent)cmbMinister.SelectedItem).id);
string remarks = txtRemarks.Text;
bool success = true;
//DataGridViewRowCollection sponsors = dgvSponsor.Rows;
//update genprof for groom and bride to add residence and birthplace
success &= dh.editGeneralProfile(groomID, txtGResidence.Text, txtGBirthPlace.Text);
success &= dh.editGeneralProfile(brideID, txtBResidence.Text, txtBBirthPlace.Text);
//MessageBox.Show(string.Format("GROOM {0} BRIDE {1}", txtGBirthPlace.Text, txtBBirthPlace.Text));
//Adds or edits parents depending on whether they exist or not
success &= dh.addEditParent(groomID, txtGFFN.Text, txtGFMI.Text, txtGFLN.Text, txtGFSuffix.Text, Gender.Male);
success &= dh.addEditParent(groomID, txtGMFN.Text, txtGMMI.Text, txtGMLN.Text, txtGMSuffix.Text, Gender.Female);
success &= dh.addEditParent(brideID, txtBFFN.Text, txtBFMI.Text, txtBFLN.Text, txtBFSuffix.Text, Gender.Male);
success &= dh.addEditParent(brideID, txtBMFN.Text, txtBMMI.Text, txtBMLN.Text, txtBMSuffix.Text, Gender.Female);
success &= dh.editApplication(applicationID, ApplicationStatus.Approved);
if (operation == OperationType.Add)
{
success &= addOperation(applicationID, ministerID, licenseDate, marriageDate, groomCS, brideCS, remarks);
}
else
{
success &= editOperation(applicationID, ministerID, licenseDate, marriageDate, groomCS, brideCS, remarks);
}
//dh.addMarriage(applicationID, ministerID, licenseDate, marriageDate, groomCS, brideCS);
this.DialogResult = success ? DialogResult.OK : DialogResult.None;
}
// GET: CivilStatus/Edit/5
public ActionResult Edit(int?id)
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
CivilStatus civilStatus = db.CivilStatus.Find(id);
if (civilStatus == null)
{
return(HttpNotFound());
}
return(View(civilStatus));
}
public void Modify(CivilStatus c)
{
try
{
if (validateCivilStatus(c))
{
dal.Update(c);
}
}
catch (Exception)
{
throw;
}
}
public JsonResult Get(int id)
{
CivilStatus model = new CivilStatus();
try
{
model = this._civilStatusBusiness.GetCivilStatus(id);
return(Json(model, JsonRequestBehavior.AllowGet));
}
catch (Exception)
{
return(Json(new { responseCode = "-10" }));
}
}
private void btnSearch_Click(object sender, RoutedEventArgs e)
{
try
{
CivilStatus c = new CivilStatus();
c = (CivilStatus)lsSearch.SelectedValue;
txtStatusId.Text = c.StatusId.ToString();
txtStatusDesc.Text = c.StatusDescription;
dgRecords.ItemsSource = bll.GetAll();
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
}
private void btnUpdate_Click(object sender, RoutedEventArgs e)
{
try
{
CivilStatus c = new CivilStatus();
c.StatusId = int.Parse(txtStatusId.Text);
c.StatusDescription = txtStatusDesc.Text;
bll.Modify(c);
MessageBox.Show("Updated Sucessfully");
lsSearch.ItemsSource = bll.GetAll();
lsSearch.DisplayMemberPath = "StatusId";
dgRecords.ItemsSource = bll.GetAll();
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
}
private void btnAdd_Click(object sender, RoutedEventArgs e)
{
try
{
CivilStatus c = new CivilStatus();
c.StatusDescription = txtStatusDesc.Text;
bll.Add(c);
lsSearch.ItemsSource = bll.GetAll();
lsSearch.DisplayMemberPath = "StatusId";
txtStatusId.Text = bll.GetStatusId().ToString();
dgRecords.ItemsSource = bll.GetAll();
ClearWindow();
MessageBox.Show("Civil Status Added Sucessfully");
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
}
//Calling Update CivilStatus
public static int UpdateCivilStatus_BL(CivilStatus newCVS)
{
int rowsAffected = 0;
try
{
if (ValidatCivilStatus(newCVS))
{
rowsAffected = CivilStatus_DAL.UpdateCivilStat(newCVS);
}
}
catch (SqlException ex)
{
throw ex;
}
catch (HRMSException ex)
{
throw ex;
}
return(rowsAffected);
}
/// <summary>
/// Gets the civil status.
/// </summary>
/// <returns></returns>
/// <exception cref="Exception">ParametersDAO.GetCivilStatus</exception>
public OutCivilStatus GetCivilStatus()
{
string connectionString = DataBaseHelper.GetConnectionString("DLG");
OutCivilStatus response = new OutCivilStatus();
var ora = new OracleServer(connectionString);
CivilStatus status;
List <CivilStatus> list = new List <CivilStatus>();
string command = string.Empty;
try
{
command = "SELECT dfpecv09.codigo_civil, dfpecv09.nombre_civil FROM dfpecv09 WHERE CODIGO_CIVIL<> 0 ORDER BY dfpecv09.codigo_civil ASC ";
var rdr = ora.ExecuteCommand(command);
while (rdr.Read())
{
status = new CivilStatus();
status.statusID = DBNull.Value.Equals(rdr["codigo_civil"]) ? 0 : int.Parse(rdr["codigo_civil"].ToString());
status.statusName = DBNull.Value.Equals(rdr["nombre_civil"]) ? string.Empty : rdr["nombre_civil"].ToString();
list.Add(status);
}
rdr.Close();
response.lstCivilStatus = list;
response.msg = new Response();
response.msg.errorCode = "200";
response.msg.errorMessage = "OK";
}
catch (Exception ex)
{
throw new Exception("ParametersDAO.GetCivilStatus", ex);
}
finally
{
ora.Dispose();
}
return(response);
}
public static Person CreateNew(Gender gender, string identification, string firstname, string lastname,
DateTime bob, string passport, CivilStatus civil, string ocupation, string nationality)
{
var customer = new Person
{
Identification = identification,
FirstName = firstname,
LastName = lastname,
//Gender = gender,
//DOB = bob,
//Passport = passport,
//MaritalStatus = civil,
//Ocupation = ocupation,
//Nationality = nationality,
//Addresses = new List<Address>(),
//Contacts = new List<Contact>(),
//Inquiries = new List<Inquiry>(),
//CreditHistories = new List<CreditHistory>(),
//RelatedPersons = new List<RelatedPerson>(),
};
return(customer);
}
public JsonResult Edit(CivilStatus model)
{
try
{
if (model == null)
{
return(Json(new { responseCode = "-10" }));
}
this._civilStatusBusiness.Save(model);
var responseObject = new
{
responseCode = 0
};
return(Json(responseObject));
}
catch (Exception)
{
return(Json(new { responseCode = "-10" }));
}
}
public void Add(CivilStatus c)
{
try
{
if (validateCivilStatus(c))
{
dal.Insert(c);
}
else
{
throw new CivilStatusException("Invalid Data");
}
}
catch (CivilStatusException ex)
{
throw ex;
}
catch (SystemException ex)
{
throw ex;
}
}
public IEnumerable SelectAllCivilStatus()
{
List <CivilStatus> civilstatusList = new List <CivilStatus>();
string selectAll = "balaji.SP_SELECTALL_CivilStatus_HR_Batch4";
try
{
cmd = new SqlCommand(selectAll, con);
cmd.CommandType = System.Data.CommandType.StoredProcedure;
con.Open();
dr = cmd.ExecuteReader();
if (dr.HasRows)
{
while (dr.Read())
{
CivilStatus c = new CivilStatus();
c.StatusId = (int)dr[0];
c.StatusDescription = dr[1].ToString();
civilstatusList.Add(c);
}
}
}
catch (CivilStatusException)
{
throw;
}
catch (Exception)
{
throw;
}
finally
{
dr.Close();
con.Close();
}
return(civilstatusList);
}
public async Task <IActionResult> Edit(CivilStatus civilStatus)
{
var validationResult = _validator.Validate(civilStatus);
if (!ModelState.IsValid)
{
var errors = ModelState.Values.SelectMany(x => x.Errors).Select(x => x.ErrorMessage).ToList();
return(BadRequest(errors));
}
else if (!validationResult.IsValid)
{
var validationErrors = validationResult.Errors.Select(x => $"{x.PropertyName} failed validation: ${x.ErrorMessage}.");
return(BadRequest(string.Join(";", validationErrors)));
}
int result = await _civilStatusRepository.Update(civilStatus).ConfigureAwait(false);
if (result == 1)
{
return(Ok("Civil Status edited."));
}
return(StatusCode(500, "There was a problem trying to update civil status."));
}
public CivilStatus UpdateCivilStatus(CivilStatus civilStatus)
{
return(this.civilStatusRepository.UpdateCivilStatus(civilStatus));
}
