Beispiel #1
0
        public string DeleteHoardingMaster(string ID)
        {
            string result = string.Empty;

            try
            {
                int HoardingID = Convert.ToInt32(ID);

                //Cascade check in hoarding history table
                var IsUsedInHoarding = Global.dc.HoardingHistories.FirstOrDefault(i => i.IsActive == true && (!i.IsDeleted.HasValue || !i.IsDeleted.Value) && i.HoardingMasterID == HoardingID);

                if (IsUsedInHoarding != null)
                {
                    return("4");
                }
                else
                {
                    //extra condition
                    //&& i.IsActive == true && (!i.IsDeleted.Value || !i.IsDeleted.HasValue)
                    HoardingMaster hoarding = Global.dc.HoardingMasters.FirstOrDefault(i => i.ID == HoardingID);
                    if (hoarding != null)
                    {
                        hoarding.IsDeleted = true;
                        int count = Global.dc.SaveChanges();
                        result = Convert.ToString(count);
                    }
                    else
                    {
                        result = "3";
                    }
                }
            }
            catch (Exception)
            {
                result = "-1";
            }
            return(result);
        }
Beispiel #2
0
        public string AddHoardingMaster(string CityID, string AreaID, string SubAreaID, string HoardingNo, string HoardingMasterID, string HoardingSize, string Operation)
        {
            string         result         = string.Empty;
            int            count          = 0;
            HoardingMaster hoardingMaster = new HoardingMaster();

            try
            {
                int?subAreaID;
                if (!string.IsNullOrEmpty(SubAreaID))
                {
                    subAreaID = Convert.ToInt32(SubAreaID);
                }
                else
                {
                    subAreaID = null;
                }

                if (Operation.ToLower() == "add")
                {
                    var hoarding = Global.dc.IsHoardingExsist(subAreaID, (int?)Convert.ToInt32(HoardingNo), (int?)Convert.ToInt32(AreaID)).ToList();
                    if (hoarding.Count > 0)
                    {
                        result = "2";
                    }
                    else
                    {
                        hoardingMaster.CityID       = Convert.ToInt32(CityID);
                        hoardingMaster.AreaID       = Convert.ToInt32(AreaID);
                        hoardingMaster.HoardingSize = HoardingSize;
                        if (!string.IsNullOrEmpty(SubAreaID))
                        {
                            hoardingMaster.SubAreaID = subAreaID;
                        }

                        hoardingMaster.HoardingNo = (int?)Convert.ToInt32(HoardingNo.Trim());
                        hoardingMaster.IsActive   = true;
                        hoardingMaster.IsDeleted  = false;
                        Global.dc.HoardingMasters.Add(hoardingMaster);

                        count  = Global.dc.SaveChanges();
                        result = count.ToString();
                    }
                }
                else if (Operation.ToLower() == "update")
                {
                    var hoarding = Global.dc.IsHoardingExsist(subAreaID, (int?)Convert.ToInt32(HoardingNo), (int?)Convert.ToInt32(AreaID)).ToList();
                    if (hoarding.Count > 0 && hoarding.FirstOrDefault().HoardingSize != null)
                    {
                        //HoardingSize field is added at the end so while updating we need to always check for already assign hoarding

                        int ID = Convert.ToInt32(HoardingMasterID);
                        hoardingMaster = Global.dc.HoardingMasters.FirstOrDefault(i => i.ID == ID);

                        if (hoardingMaster != null)
                        {
                            hoardingMaster.HoardingSize = HoardingSize;
                            count  = Global.dc.SaveChanges();
                            result = Convert.ToString(count);
                        }
                        else
                        {
                            result = "2";
                        }
                    }
                    else
                    {
                        int ID = Convert.ToInt32(HoardingMasterID);
                        hoardingMaster = Global.dc.HoardingMasters.FirstOrDefault(i => i.ID == ID);
                        if (hoardingMaster != null)
                        {
                            hoardingMaster.CityID    = Convert.ToInt32(CityID);
                            hoardingMaster.AreaID    = Convert.ToInt32(AreaID);
                            hoardingMaster.SubAreaID = subAreaID;

                            hoardingMaster.HoardingSize = HoardingSize;
                            hoardingMaster.HoardingNo   = (int?)Convert.ToInt32(HoardingNo.Trim());
                            hoardingMaster.IsActive     = true;
                            hoardingMaster.IsDeleted    = false;
                            count  = Global.dc.SaveChanges();
                            result = count.ToString();
                        }
                        else
                        {
                            //Record not found
                            result = "3";
                        }
                    }
                }
            }
            catch (Exception)
            {
                result = "-1";
            }
            return(result);
        }