// GET api/districts
public IEnumerable<Districts> Get()
{
List<Districts> listDistricts = new List<Districts>();
DataView dvDistricts = DistrictBO.GetDistrictIDForSync();
foreach (DataRowView drvDistricts in dvDistricts)
{
Districts District = new Districts();
listDistricts.Add(DistrictBO.GetDistrict(Convert.ToInt32(drvDistricts["DistrictID"])));
}
return listDistricts;
}
// POST api/districts
public Districts Post(Districts Districts)
{
if (Districts.GUID > 0)
{
Districts.DistrictID = Districts.GUID;
Districts.SyncStatus = 1;
int rowResult = DistrictBO.UpdateDistrict(Districts);
//Return Back to The Client
return Districts;
}
else
{
int rowResult = DistrictBO.InsertDistrict(Districts);
//Return Back to The Client
return Districts;
}
}
public int InsertDistrict(Districts Districts)
{
Districts.DistrictID = -1;
BeginTransaction();
try
{
Districts.DistrictID = Insert(Districts);
CommitTransaction();
}
catch (Exception ex)
{
RollBackTransaction();
Districts.DistrictID = -1;
}
return Districts.DistrictID;
}
public int UpdateDistrict(Districts Districts)
{
int rowsaffected = -1;
BeginTransaction();
try
{
String[] UpdateProperties = new String[] { "DistrictName", "ZoneID", "DistrictCode", "UpdatedBy", "UpdatedDate", "SyncStatus" };
rowsaffected = Update(Districts, UpdateProperties);
CommitTransaction();
}
catch (Exception e)
{
RollBackTransaction();
rowsaffected = -1;
}
return rowsaffected;
}
public static int UpdateDistrict(Districts Districts)
{
return new DistrictsDAO().UpdateDistrict(Districts);
}
public static int InsertDistrict(Districts Districts)
{
return new DistrictsDAO().InsertDistrict(Districts);
}
public static Districts GetDistrict(int DistrictID)
{
Districts objDistricts = new Districts();
return (Districts)(new DistrictsDAO().FillDTO(objDistricts, "DistrictID=" + DistrictID));
}