// GET api/maritalstatus public IEnumerable<MaritalStatus> Get() { List<MaritalStatus> listMaritalStatus = new List<MaritalStatus>(); DataView dvMaritalStatus = MaritalStatusBO.GetMaritalStatusIDForSync(); foreach (DataRowView drvEducationalStatus in dvMaritalStatus) { MaritalStatus status = new MaritalStatus(); listMaritalStatus.Add(MaritalStatusBO.GetMaritalStatus(Convert.ToInt32(drvEducationalStatus["MaritalStatusID"]))); } return listMaritalStatus; }
public int InsertMaritalStatus(MaritalStatus objStatus) { objStatus.MaritalStatusID = 1; BeginTransaction(); try { objStatus.MaritalStatusID = Insert(objStatus); CommitTransaction(); } catch (Exception ex) { RollBackTransaction(); objStatus.MaritalStatusID = -1; } return objStatus.MaritalStatusID; }
// POST api/maritalstatus public MaritalStatus Post(MaritalStatus status) { if (status.GUID > 0) { status.MaritalStatusID = status.GUID; int rowResult = MaritalStatusBO.UpdateMaritalStatus(status); //Return Back to The Client return status; } else { int rowResult = MaritalStatusBO.InsertmaritalStatus(status); //Return Back to The Client return status; } }
public int UpdateMaritalStatus(MaritalStatus objStatus) { int rowsaffected = -1; BeginTransaction(); try { String[] UpdateProperties = new String[] { "MaritalStatusDesc", "UpdatedBy", "UpdatedDate", "GUID", "SyncStatus" }; rowsaffected = Update(objStatus, UpdateProperties); CommitTransaction(); } catch (Exception e) { RollBackTransaction(); rowsaffected = -1; } return rowsaffected; }
public static int UpdateMaritalStatus(MaritalStatus objStatus) { return new MaritalStatusDAO().UpdateMaritalStatus(objStatus); }
public static int InsertmaritalStatus(MaritalStatus objStatus) { return new MaritalStatusDAO().InsertMaritalStatus(objStatus); }
public static MaritalStatus GetMaritalStatus(int MaritalStatusID) { MaritalStatus obj = new MaritalStatus(); return (MaritalStatus)(new MaritalStatusDAO().FillDTO(obj, "MaritalStatusID=" + MaritalStatusID)); }