public IHttpActionResult DeleteGeographical(GeographicalMaster Geographical) { string status = string.Empty; try { GeographicalMaster _Geographical = _geographicalService.GetGeographicalById(Geographical.Id); _Geographical.Deactivate = "Y"; _Geographical.DeactivateBy = Geographical.EnteredBy; _Geographical.DeactivateDate = DateTime.Now; _geographicalService.UpdateGeographical(_Geographical); status = "OK"; } catch (ACSException ex) { status = ex.InnerException.Message; } catch (Exception ex) { status = ex.InnerException.Message; } return(Json(status)); }
public void InsertGeographical(GeographicalMaster Geographical) { Geographical.Deactivate = "N"; Geographical.parentid = Geographical.parentid; Geographical.geogcode = Geographical.geogName.Replace(".", string.Empty).Substring(0, 2).ToUpper(); Geographical.EntryDate = DateTime.Now; Geographical.ModifiedBy = null; Geographical.ModifiedDate = null; Geographical.DeactivateBy = null; Geographical.DeactivateDate = null; _geographicalServiceRepository.Insert(Geographical); }
/// <summary> /// Check The duplicity of record before insertion and deletion /// </summary> /// <param name="GeographyType">Geography</param> public string DuplicityCheck(GeographicalMaster Geographical) { var dupes = _geographicalServiceRepository.Table.Where(x => x.geogName == Geographical.geogName && x.Deactivate == "N" && x.geogtype == Geographical.geogtype && x.parentid == Geographical.parentid && (Geographical.Id != 0 ? x.Id : 0) != (Geographical.Id != 0 ? Geographical.Id : 1)).FirstOrDefault(); if (dupes != null) { return("N"); } else { return("Y"); } }
public IHttpActionResult InsertGeographical(GeographicalMaster Geographical) { string status = ""; try { status = _geographicalService.DuplicityCheck(Geographical); if (status == "Y") { if (Geographical.Id == 0) { _geographicalService.InsertGeographical(Geographical); status = _localizationService.GetResource("Master.API.Success.Message"); } else { GeographicalMaster _Geographical = _geographicalService.GetGeographicalById(Geographical.Id); _Geographical.parentid = Geographical.parentid; _Geographical.geogName = Geographical.geogName; _Geographical.geogcode = Geographical.geogName.Replace(".", string.Empty).Substring(0, 2).ToUpper(); _Geographical.ModifiedBy = Geographical.EnteredBy; _Geographical.ModifiedDate = DateTime.Now; _geographicalService.UpdateGeographical(_Geographical); status = _localizationService.GetResource("Master.API.Success.Message"); } } else { status = "Duplicate"; } } catch (ACSException ex) { status = ex.InnerException.Message; } catch (Exception ex) { status = ex.InnerException.Message; } return(Json(status)); }
public IHttpActionResult getGeographical(int Id) { GeographicalMaster _geographicalMaster = _geographicalService.GetGeographicalById(Id); return(Json(SerializeObj.SerializeObject(new { _geographicalMaster }))); }
/// <summary> ///methos for selecting the geogType /// </summary> /// <param name="GeographyType">Geography</param> /// public IList <GeographicalMaster> GetAllGeog(GeographicalMaster geog) { return(_GeogRepository.Table.Where(c => c.Deactivate == "N" && c.geogtype == geog.geogtype && c.parentid == geog.parentid).Distinct().OrderBy(c => c.geogName).ToList()); }
public IHttpActionResult GeographicalUserControl(GeographicalMaster geog) { return(Json(_CommonDDLService.GetAllGeog(geog).ToList())); }
public void DeleteGeographical(GeographicalMaster Geographical) { _geographicalServiceRepository.Delete(Geographical); }
public void UpdateGeographical(GeographicalMaster Geographical) { _geographicalServiceRepository.Update(Geographical); }