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);
}
