public bool CheckDuplicateAreaTerritory(territory mTerritory)
{
var checkDuplicateTerritory = _entities.territories.FirstOrDefault(a => a.territory_name == mTerritory.territory_name && a.area_id == mTerritory.area_id && a.territory_id != mTerritory.area_id);
bool returnType = (checkDuplicateTerritory != null);
return(returnType);
}
public territory[] getTerritoryCount(DataTable table)
{
territory[] TerritoryList = new territory[table.Rows.Count];
for (int i = 0; i < TerritoryList.Length; i++)
{
TerritoryList[i].name = (string)table.Rows[i]["Territory"];
TerritoryList[i].count = (int)table.Rows[i]["Count"];
}
return(TerritoryList);
}
public bool DeleteTerritory(long territory_id)
{
try
{
territory objTerritory = _entities.territories.FirstOrDefault(t => t.territory_id == territory_id);
_entities.territories.Attach(objTerritory);
_entities.territories.Remove(objTerritory);
_entities.SaveChanges();
return(true);
}
catch (Exception)
{
return(false);
}
}
public HttpResponseMessage Post([FromBody] Models.territory oTerritory)
{
try
{
if (string.IsNullOrEmpty(oTerritory.territory_name))
{
var formatter = RequestFormat.JsonFormaterString();
return(Request.CreateResponse(HttpStatusCode.OK, new Confirmation {
output = "error", msg = "Area Name is Empty"
}, formatter));
}
if (_territoryRepository.CheckDuplicateAreaTerritory(oTerritory))
{
var formatter = RequestFormat.JsonFormaterString();
return(Request.CreateResponse(HttpStatusCode.OK, new Confirmation {
output = "error", msg = "Same Area and Zone Already Exists! "
}, formatter));
}
else
{
var iTerritory = new territory
{
territory_name = oTerritory.territory_name,
territory_code = oTerritory.territory_code,
area_id = oTerritory.area_id,
is_active = oTerritory.is_active,
created_by = oTerritory.created_by,
created_date = DateTime.Now,
updated_by = oTerritory.updated_by,
updated_date = DateTime.Now
};
_territoryRepository.AddTerritory(iTerritory);
var formatter = RequestFormat.JsonFormaterString();
return(Request.CreateResponse(HttpStatusCode.OK, new Confirmation {
output = "success", msg = "Territory saved successfully"
}, formatter));
}
}
catch (Exception ex)
{
var formatter = RequestFormat.JsonFormaterString();
return(Request.CreateResponse(HttpStatusCode.OK, new Confirmation {
output = "error", msg = ex.ToString()
}, formatter));
}
}
public territory Createterritory(String territoryID = null, String territoryDescription = null, Int32?regionID = null)
{
territory value = CreateObject <territory>();
if (territoryID != null)
{
value.TerritoryID = territoryID;
}
if (territoryDescription != null)
{
value.TerritoryDescription = territoryDescription;
}
if (regionID != null)
{
value.RegionID = regionID.Value;
}
return(value);
}
public bool EditTerritory(territory oTerritory)
{
try
{
territory t = _entities.territories.Find(oTerritory.territory_id);
t.area_id = oTerritory.area_id;
t.territory_name = oTerritory.territory_name;
t.territory_code = oTerritory.territory_code;
t.is_active = oTerritory.is_active;
t.updated_by = oTerritory.updated_by;
t.updated_date = DateTime.Now;
_entities.SaveChanges();
return(true);
}
catch (Exception)
{
return(false);
}
}
public bool AddTerritory(territory oTerritory)
{
try
{
var iTerritory = new territory
{
area_id = oTerritory.area_id,
territory_name = oTerritory.territory_name,
territory_code = oTerritory.territory_code,
is_active = oTerritory.is_active,
created_date = DateTime.Now,
created_by = oTerritory.created_by,
updated_date = DateTime.Now,
updated_by = oTerritory.updated_by
};
_entities.territories.Add(iTerritory);
_entities.SaveChanges();
return(true);
}
catch (Exception ex)
{
return(false);
}
}
void fight(territory t1, territory t2)
{
}
/// <summary>
/// Deprecated Method for adding a new object to the territories EntitySet. Consider using the .Add method of the associated ObjectSet<T> property instead.
/// </summary>
public void AddToterritories(territory territory)
{
base.AddObject("territories", territory);
}
