public int InsertEthnicity(Ethnicity objEthnicity) { objEthnicity.EthnicityID = 1; BeginTransaction(); try { objEthnicity.EthnicityID = Insert(objEthnicity); CommitTransaction(); } catch (Exception ex) { RollBackTransaction(); objEthnicity.EthnicityID = -1; } return objEthnicity.EthnicityID; }
public int DeleteEthnicity(Ethnicity objEthnicity) { int rowsaffected = -1; BeginTransaction(); try { String[] UpdateProperties = new String[] { "Status" }; rowsaffected = Update(objEthnicity, UpdateProperties); CommitTransaction(); } catch (Exception e) { RollBackTransaction(); rowsaffected = -1; } return rowsaffected; }
// POST api/ethnicity public Ethnicity Post(Ethnicity ethnicity) { if (ethnicity.GUID > 0) { ethnicity.EthnicityID = ethnicity.GUID; int rowResult = EthnicityBO.UpdateEthnicity(ethnicity); //Return Back to The Client return ethnicity; } else { int rowResult = EthnicityBO.InsertEthnicity(ethnicity); //Return Back to The Client return ethnicity; } }
public int UpdateEthnicity(Ethnicity objEthnicity) { int rowsaffected = -1; BeginTransaction(); try { String[] UpdateProperties = new String[] { "EthnicityName", "Category", "UpdatedBy", "UpdatedDate", "Status", "ValidRegions", "SyncStatus" }; rowsaffected = Update(objEthnicity, UpdateProperties); CommitTransaction(); } catch (Exception e) { RollBackTransaction(); rowsaffected = -1; } return rowsaffected; }
public static int DeleteEthnicity(Ethnicity objEthnicity) { return new EthnicityDAO().DeleteEthnicity(objEthnicity); }
public static int UpdateEthnicity(Ethnicity objEthnicity) { return new EthnicityDAO().UpdateEthnicity(objEthnicity); }
public static Ethnicity GetEthnicity(int EthnicityID) { Ethnicity objEthnicity = new Ethnicity(); return (Ethnicity)(new EthnicityDAO().FillDTO(objEthnicity, "EthnicityID=" + EthnicityID)); }
public static int InsertEthnicity(Ethnicity objEthnicity) { return new EthnicityDAO().InsertEthnicity(objEthnicity); }