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