public bool Delete(TB_TypeHotelChainExt model, ref string Msg, Controller ctrl)
 {
     bool status = true;
     using (DBEntities DE = new DBEntities())
     {
         var DepObj = DE.TB_TypeHotelChain.Where(x => x.ID == model.ID).FirstOrDefault();
         DE.TB_TypeHotelChain.Remove(DepObj);
         DE.SaveChanges();
     }
     return status;
 }
 public bool Create(TB_TypeHotelChainExt model, ref string Msg, Controller ctrl)
 {
     bool status = true;
     DBEntities insertentity = new DBEntities();
     TB_TypeHotelChain DepObj = new TB_TypeHotelChain();
     DepObj.Name = model.Name;
     DepObj.Sort = Convert.ToInt16(model.Sorts);
     DepObj.Active = model.Active;
     DepObj.OpDateTime = DateTime.Now;
     DepObj.OpUserID = 0;
     insertentity.TB_TypeHotelChain.Add(DepObj);
     insertentity.SaveChanges();
     int id = DepObj.ID;
     return status;
 }
 public bool Create(TB_AttributeHeaderExt model, ref string Msg, Controller ctrl)
 {
     bool status = true;
     DBEntities insertentity = new DBEntities();
     TB_AttributeHeader DepObj = new TB_AttributeHeader();
        // DepObj.ID = model.ID;
     DepObj.Code = model.Code;
     DepObj.Name_en = model.Name;
     DepObj.Sort = Convert.ToInt16(model.Sorts);
     DepObj.Active = model.Active;
     DepObj.OpDateTime = DateTime.Now;
     DepObj.OpUserID = Convert.ToInt64(ctrl.Session["UserID"]);
     insertentity.TB_AttributeHeader.Add(DepObj);
     insertentity.SaveChanges();
     int id = DepObj.ID;
     return status;
 }
 public bool Update(TB_TypeHotelChainExt model, ref string Msg, Controller ctrl)
 {
     bool status = true;
     using (DBEntities DE = new DBEntities())
     {
         var DepObj = DE.TB_TypeHotelChain.Where(x => x.ID == model.ID).FirstOrDefault();
         DepObj.Name = model.Name;
         DepObj.Sort = Convert.ToInt16(model.Sorts);
         DepObj.Active = model.Active;
         DepObj.OpDateTime = DateTime.Now;
         DepObj.OpUserID = 0;
         DepObj.Sort = Convert.ToInt16(model.Sorts);
         DepObj.Active = model.Active;
         DepObj.OpDateTime = DateTime.Now;
         DepObj.OpUserID = 0;
         DE.SaveChanges();
     }
     return status;
 }
        public bool Delete(MessageExt model, ref string Msg, Controller ctrl)
        {
            bool status = true;
            //DBEntities insertentity = new DBEntities();
            //var IDParam = new SqlParameter("@ID", model.ID);
            //int i = insertentity.Database.ExecuteSqlCommand("B_Ex_Delete_BizTbl_Message_SP @ID", IDParam);

            using (DBEntities DE = new DBEntities())
            {
                var MessageTable = DE.BizTbl_Message.Where(x => x.ID == model.ID).FirstOrDefault();
                DE.BizTbl_Message.Remove(MessageTable);
                DE.SaveChanges();
            }
            return status;
        }
 public bool Create(TB_TypeHotelClassExt model, ref string Msg, Controller ctrl)
 {
     bool status = true;
     DBEntities insertentity = new DBEntities();
     TB_TypeHotelClass DepObj = new TB_TypeHotelClass();
     DepObj.Code = model.Code;
     DepObj.Name_en = model.Name_en;
     DepObj.Name_tr = model.Name_tr;
     DepObj.Name_de = model.Name_de;
     DepObj.Name_es = model.Name_es;
     DepObj.Name_fr = model.Name_fr;
     DepObj.Name_ru = model.Name_ru;
     DepObj.Name_it = model.Name_it;
     DepObj.Name_ar = model.Name_ar;
     DepObj.Name_ja = model.Name_ja;
     DepObj.Name_pt = model.Name_pt;
     DepObj.Name_zh = model.Name_zh;
     DepObj.Sort = Convert.ToInt16(model.Sorts);
     DepObj.Active = model.Active;
     DepObj.OpDateTime = DateTime.Now;
     DepObj.OpUserID = 0;
     insertentity.TB_TypeHotelClass.Add(DepObj);
     insertentity.SaveChanges();
     int id = DepObj.ID;
     return status;
 }
 public bool Create(TB_TypeSalutationExt model, ref string Msg, Controller ctrl)
 {
     bool status = true;
     DBEntities insertentity = new DBEntities();
     TB_TypeSalutation DepObj = new TB_TypeSalutation();
     DepObj.Name_en = model.Name_en;
     DepObj.Name_tr = model.Name_tr;
     DepObj.Name_de = model.Name_de;
     DepObj.Name_es = model.Name_es;
     DepObj.Name_fr = model.Name_fr;
     DepObj.Name_ru = model.Name_ru;
     DepObj.Name_it = model.Name_it;
     DepObj.Name_ar = model.Name_ar;
     DepObj.Name_ja = model.Name_ja;
     DepObj.Name_pt = model.Name_pt;
     DepObj.Name_zh = model.Name_zh;
     DepObj.OpDateTime = DateTime.Now;
     DepObj.OpUserID = 0;
     insertentity.TB_TypeSalutation.Add(DepObj);
     insertentity.SaveChanges();
     int id = DepObj.ID;
     return status;
 }
 public bool Delete(RegionExt model, ref string Msg, Controller ctrl)
 {
     bool status = true;
     using (DBEntities DE = new DBEntities())
     {
         var RegionTable = DE.TB_Region.Where(x => x.ID == model.ID).FirstOrDefault();
         DE.TB_Region.Remove(RegionTable);
         DE.SaveChanges();
     }
     return status;
 }
 public bool Create(ParameterExt model, ref string Msg, Controller ctrl)
 {
     bool status = true;
     DBEntities insertentity = new DBEntities();
     BizTbl_Parameter MsgObj = new BizTbl_Parameter();
     MsgObj.ID = model.ID;
     MsgObj.Code = model.Code;
     MsgObj.Value = model.Value;
     MsgObj.Description_en = model.Description;
     MsgObj.IsCommon = model.IsCommon;
     MsgObj.OpDateTime = DateTime.Now;
     MsgObj.OpUserID = Convert.ToInt64(ctrl.Session["UserID"]);
     insertentity.BizTbl_Parameter.Add(MsgObj);
     insertentity.SaveChanges();
     int id = MsgObj.ID;
     return status;
 }
 public bool Update(ParameterExt model, ref string Msg, Controller ctrl)
 {
     bool status = true;
     using (DBEntities DE = new DBEntities())
     {
         var MessageTable = DE.BizTbl_Parameter.Where(x => x.ID == model.ID).FirstOrDefault();
         MessageTable.Code = model.Code;
         MessageTable.Value = model.Value;
         MessageTable.Description_en = model.Description;
         MessageTable.IsCommon = model.IsCommon;
         MessageTable.OpDateTime = DateTime.Now;
         MessageTable.OpUserID = model.OpUserID;
         DE.SaveChanges();
     }
     return status;
 }
 public bool Update(TB_TransferExt model, ref string Msg, Controller ctrl)
 {
     bool status = true;
     using (DBEntities DE = new DBEntities())
     {
         var DepObj = DE.TB_Transfer.Where(x => x.ID == model.ID).FirstOrDefault();
         DepObj.BusinessPartnerID = model.BusinessPartnerID;
         DepObj.CostCurrencyID = model.CostCurrencyID;
         DepObj.CurrencyID = model.CurrencyID;
         DepObj.TransferPaxID = model.TransferPaxID;
         DepObj.DepartureRegionID = model.DepartureRegionID;
         DepObj.DepositCurrencyID = model.DepositCurrencyID;
         DepObj.TransferPeriodID = model.TransferPeriodID;
         DepObj.Deposit = model.Deposit;
         DepObj.Amount = model.Amount;
         DepObj.Cost = model.Amount;
         DepObj.HitCount = model.HitCount;
         DepObj.Active = model.Active;
         DepObj.OpDateTime = DateTime.Now;
         DepObj.OpUserID = 0;
         DE.SaveChanges();
     }
     return status;
 }
 public bool Create(TB_TransferExt model, ref string Msg, Controller ctrl)
 {
     bool status = true;
     DBEntities insertentity = new DBEntities();
     TB_Transfer DepObj = new TB_Transfer();
     //DepObj.ID = model.ID;
     DepObj.BusinessPartnerID = model.BusinessPartnerID;
     DepObj.CostCurrencyID = model.CostCurrencyID;
     DepObj.CurrencyID = model.CurrencyID;
     DepObj.TransferPaxID = model.TransferPaxID;
     DepObj.DepartureRegionID = model.DepartureRegionID;
     DepObj.DepositCurrencyID = model.DepositCurrencyID;
     DepObj.TransferPeriodID = model.TransferPeriodID;
     DepObj.Deposit = model.Deposit;
     DepObj.Amount = model.Amount;
     DepObj.Cost = model.Amount;
     DepObj.HitCount = model.HitCount;
     DepObj.Active = model.Active;
     DepObj.OpDateTime = DateTime.Now;
     DepObj.CreateDateTime = DateTime.Now;
     DepObj.OpUserID = 0;
     DepObj.CreateUserID = 0;
     insertentity.TB_Transfer.Add(DepObj);
     insertentity.SaveChanges();
     int id = DepObj.ID;
     return status;
 }
 public bool Create(TB_TypeReviewScaleExt model, ref string Msg, Controller ctrl)
 {
     bool status = true;
     DBEntities insertentity = new DBEntities();
     TB_TypeReviewScale DepObj = new TB_TypeReviewScale();
     DepObj.ID = model.ID;
     DepObj.Name_en = model.Name_en;
     DepObj.Name_tr = model.Name_tr;
     DepObj.Name_de = model.Name_de;
     DepObj.Name_es = model.Name_es;
     DepObj.Name_fr = model.Name_fr;
     DepObj.Name_ru = model.Name_ru;
     DepObj.Name_it = model.Name_it;
     DepObj.Name_ar = model.Name_ar;
     DepObj.Name_ja = model.Name_ja;
     DepObj.Name_pt = model.Name_pt;
     DepObj.Name_zh = model.Name_zh;
     DepObj.Point = Convert.ToDecimal(model.Points);
     DepObj.Active = model.Active;
     DepObj.OpDateTime = DateTime.Now;
     DepObj.OpUserID = 0;
     insertentity.TB_TypeReviewScale.Add(DepObj);
     insertentity.SaveChanges();
     int id = DepObj.ID;
     return status;
 }
        public bool Update(MessageExt model, ref string Msg, Controller ctrl)
        {
            bool status = true;
            using (DBEntities DE = new DBEntities())
            {
                var MessageTable = DE.BizTbl_Message.Where(x => x.ID == model.ID).FirstOrDefault();
                MessageTable.Code = model.Code;
                MessageTable.Description_en = model.Description_en;
                MessageTable.Description_tr = model.Description_tr;
                MessageTable.Description_de = model.Description_de;
                MessageTable.Description_es = model.Description_es;
                MessageTable.Description_fr = model.Description_fr;
                MessageTable.Description_ru = model.Description_ru;
                MessageTable.Description_it = model.Description_it;
                MessageTable.Description_ar = model.Description_ar;
                MessageTable.Description_ja = model.Description_ja;
                MessageTable.Description_pt = model.Description_pt;
                MessageTable.Description_zh = model.Description_zh;
                MessageTable.IsCommon = model.IsCommon;
                MessageTable.OpDateTime = DateTime.Now;
                MessageTable.OpUserID = Convert.ToInt64(ctrl.Session["UserID"]);
                DE.SaveChanges();
            }

            //var IDParam = new SqlParameter("@ID", model.ID);
            //var CodeParam = new SqlParameter("@Code", model.Code);
            //var Description_trparam = new SqlParameter("@Description_tr", model.Description_tr);
            //var Description_enparam = new SqlParameter("@Description_en", model.Description_en);
            //var Description_deparam = new SqlParameter("@Description_de", model.Description_de);
            //var Description_esparam = new SqlParameter("@Description_es", model.Description_es);
            //var Description_frParam = new SqlParameter("@Description_fr", model.Description_fr);
            //var Description_ruparam = new SqlParameter("@Description_ru", model.Description_ru);
            //var Description_itparam = new SqlParameter("@Description_it", model.Description_it);
            //var Description_arparam = new SqlParameter("@Description_ar", model.Description_ar);
            //var Description_jaParam = new SqlParameter("@Description_ja", model.Description_ja);
            //var Description_ptParam = new SqlParameter("@Description_pt", model.Description_pt);
            //var Description_zhparam = new SqlParameter("@Description_zh", model.Description_zh);
            //var IsCommonparam = new SqlParameter("@IsCommon", model.IsCommon);
            //var i = updateentity.Database.ExecuteSqlCommand("B_Ex_Update_BizTbl_Message_SP @ID,@Code,@Description_tr,@Description_en,@Description_de,@Description_es,@Description_fr,@Description_ru,@Description_it,@Description_ar,@Description_ja,@Description_pt,@Description_zh,@IsCommon", IDParam, CodeParam, Description_trparam, Description_enparam, Description_deparam, Description_esparam, Description_frParam, Description_ruparam, Description_itparam, Description_itparam, Description_arparam, Description_jaParam, Description_ptParam, Description_zhparam, IsCommonparam);
            return status;
        }
        public bool Delete(ParameterExt model, ref string Msg, Controller ctrl)
        {
            bool status = true;

            using (DBEntities DE = new DBEntities())
            {
                var MessageTable = DE.BizTbl_Parameter.Where(x => x.ID == model.ID).FirstOrDefault();
                DE.BizTbl_Parameter.Remove(MessageTable);
                DE.SaveChanges();
            }
            return status;
        }
 public bool Create(RegionExt model, ref string Msg, Controller ctrl)
 {
     bool status = true;
     DBEntities insertentity = new DBEntities();
     TB_Region RegionTable = new TB_Region();
     RegionTable.ID = model.ID;
     RegionTable.CountryID = Convert.ToInt32(model.CountryID);
     RegionTable.ParentID = Convert.ToInt64(model.ParentID);
     RegionTable.SecondParentID = Convert.ToInt64(model.secondParentID);
     RegionTable.RegionType = model.RegionType;
     RegionTable.SubRegionType = model.SubRegionType;
     RegionTable.Name = model.Name;
     RegionTable.NameASCII = model.NameASCII;
     RegionTable.Name_en = model.Name_en;
     RegionTable.Name_tr = model.Name_tr;
     RegionTable.Name_de = model.Name_de;
     RegionTable.Name_es = model.Name_es;
     RegionTable.Name_fr = model.Name_fr;
     RegionTable.Name_ru = model.Name_ru;
     RegionTable.Name_it = model.Name_it;
     RegionTable.Name_ar = model.Name_ar;
     RegionTable.Name_ja = model.Name_ja;
     RegionTable.Name_pt = model.Name_pt;
     RegionTable.Name_zh = model.Name_zh;
     RegionTable.Code = model.Code;
     RegionTable.Population = Convert.ToInt64(model.Population);
     RegionTable.IsIncludedInDestinationSearch = model.IsIncludedInSearch;
     RegionTable.IsCity = model.IsCity;
     RegionTable.IsPopular = model.IsPopular;
     RegionTable.IsFilter = model.IsFilter;
     RegionTable.IsMainPageDisplay = model.IsMainPageDisplay;
     RegionTable.MainPageDisplaySort = Convert.ToInt32(model.MainPageDisplaySort);
     RegionTable.HitCount = Convert.ToInt64(model.HitCount);
     RegionTable.Sort = Convert.ToInt16(model.Sort);
     RegionTable.Latitude = model.Latitude;
     RegionTable.Longitude = model.Longitude;
     RegionTable.MapZoomIndex = Convert.ToInt32(model.MapZoomIndex);
     RegionTable.HasCityTax = model.CityTax;
     RegionTable.Active = model.Active;
     RegionTable.OpDateTime = DateTime.Now;
     RegionTable.OpUserID = Convert.ToInt64(ctrl.Session["UserID"]);
     insertentity.TB_Region.Add(RegionTable);
     insertentity.SaveChanges();
     return status;
 }
 public bool Update(TB_TypeHotelBudgetExt model, ref string Msg, Controller ctrl)
 {
     bool status = true;
     using (DBEntities DE = new DBEntities())
     {
         var DepObj = DE.TB_TypeHotelBudget.Where(x => x.ID == model.ID).FirstOrDefault();
         DepObj.CurrencyID = model.CurrencyID;
         DepObj.EndValue = model.EndValue;
         DepObj.Margin = model.Margin;
         DepObj.OpDateTime = DateTime.Now;
         DepObj.OpUserID = 0;
         DE.SaveChanges();
     }
     return status;
 }
 public bool Update(RegionExt model, ref string Msg, Controller ctrl)
 {
     bool status = true;
     using (DBEntities DE = new DBEntities())
     {
         var RegionTable = DE.TB_Region.Where(x => x.ID == model.ID).FirstOrDefault();
         RegionTable.ID = model.ID;
         RegionTable.CountryID = Convert.ToInt32(model.CountryID);
         RegionTable.ParentID = Convert.ToInt64(model.ParentID);
         RegionTable.SecondParentID = Convert.ToInt64(model.secondParentID);
         RegionTable.RegionType = model.RegionType;
         RegionTable.SubRegionType = model.SubRegionType;
         RegionTable.Name = model.Name;
         RegionTable.NameASCII = model.NameASCII;
         RegionTable.Name_en = model.Name_en;
         RegionTable.Name_tr = model.Name_tr;
         RegionTable.Name_de = model.Name_de;
         RegionTable.Name_es = model.Name_es;
         RegionTable.Name_fr = model.Name_fr;
         RegionTable.Name_ru = model.Name_ru;
         RegionTable.Name_it = model.Name_it;
         RegionTable.Name_ar = model.Name_ar;
         RegionTable.Name_ja = model.Name_ja;
         RegionTable.Name_pt = model.Name_pt;
         RegionTable.Name_zh = model.Name_zh;
         RegionTable.Code = model.Code;
         RegionTable.Population = Convert.ToInt64(model.Population);
         RegionTable.IsIncludedInDestinationSearch = model.IsIncludedInSearch;
         RegionTable.IsCity = model.IsCity;
         RegionTable.IsPopular = model.IsPopular;
         RegionTable.IsFilter = model.IsFilter;
         RegionTable.IsMainPageDisplay = model.IsMainPageDisplay;
         RegionTable.MainPageDisplaySort = Convert.ToInt32(model.MainPageDisplaySort);
         RegionTable.HitCount = Convert.ToInt64(model.HitCount);
         RegionTable.Sort = Convert.ToInt16(model.Sort);
         RegionTable.Latitude = model.Latitude;
         RegionTable.Longitude = model.Longitude;
         RegionTable.MapZoomIndex = Convert.ToInt32(model.MapZoomIndex);
         RegionTable.HasCityTax = model.CityTax;
         RegionTable.Active = model.Active;
         DE.SaveChanges();
     }
     return status;
 }
 public bool Create(TB_TypeHotelBudgetExt model, ref string Msg, Controller ctrl)
 {
     bool status = true;
     DBEntities insertentity = new DBEntities();
     TB_TypeHotelBudget DepObj = new TB_TypeHotelBudget();
     //DepObj.ID = model.ID;
     DepObj.CurrencyID = model.CurrencyID;
     DepObj.EndValue = model.EndValue;
     DepObj.Margin = model.Margin;
     DepObj.OpDateTime = DateTime.Now;
     DepObj.OpUserID = 0;
     insertentity.TB_TypeHotelBudget.Add(DepObj);
     insertentity.SaveChanges();
     int id = DepObj.ID;
     return status;
 }
 public bool Update(TB_PromotionExt model, ref string Msg, Controller ctrl)
 {
     bool status = true;
     using (DBEntities DE = new DBEntities())
     {
         var DepObj = DE.TB_Promotion.Where(x => x.ID == model.ID).FirstOrDefault();
         DepObj.PartID = model.PartID;
         switch (CultureCode)
         {
             case "en": //ID from BizTbl_Table for this Table
                 DepObj.Name_en = model.Name;
                 DepObj.Description_en = model.Description;
                 break;
             case "tr":
                 DepObj.Name_tr = model.Name;
                 DepObj.Description_tr = model.Description;
                 break;
             case "de":
                 DepObj.Name_de = model.Name;
                 DepObj.Description_de = model.Description;
                 break;
             case "es":
                 DepObj.Name_es = model.Name;
                 DepObj.Description_es = model.Description;
                 break;
             case "fr":
                 DepObj.Name_fr = model.Name;
                 DepObj.Description_fr = model.Description;
                 break;
             case "ru":
                 DepObj.Name_ru = model.Name;
                 DepObj.Description_ru = model.Description;
                 break;
             case "it":
                 DepObj.Name_it = model.Name;
                 DepObj.Description_it = model.Description;
                 break;
             case "ar":
                 DepObj.Name_ar = model.Name;
                 DepObj.Description_ar = model.Description;
                 break;
             case "ja":
                 DepObj.Name_ja = model.Name;
                 DepObj.Description_ja = model.Description;
                 break;
             case "pt":
                 DepObj.Name_pt = model.Name;
                 DepObj.Description_pt = model.Description;
                 break;
             case "zh":
                 DepObj.Name_zh = model.Name;
                 DepObj.Description_zh = model.Description;
                 break;
             default:
                 break;
         }
         DepObj.Type = model.Type;
         DepObj.GeneralPromotion = model.GeneralPromotion;
         DepObj.StartDate = model.StartDate;
         DepObj.TargetStartDate = model.TargetStartDate;
         DepObj.TargetEndDate = model.TargetEndDate;
         DepObj.Count = model.Count;
         DepObj.DiscountPercentage = model.DiscountPercentage;
         DepObj.RegionID = model.RegionID;
         DepObj.Sort = Convert.ToInt16(model.Sorts);
         DepObj.Active = model.Active;
         DepObj.OpDateTime = DateTime.Now;
         DepObj.OpUserID = 0;
         DE.SaveChanges();
     }
     return status;
 }
 public bool Update(TB_AttributeHeaderExt model, ref string Msg, Controller ctrl)
 {
     bool status = true;
     using (DBEntities DE = new DBEntities())
     {
         var DepObj = DE.TB_AttributeHeader.Where(x => x.ID == model.ID).FirstOrDefault();
         DepObj.Code = model.Code;
         DepObj.Name_en = model.Name;
         DepObj.Sort = Convert.ToInt16(model.Sorts);
         DepObj.Active = model.Active;
         DepObj.OpDateTime = DateTime.Now;
         DepObj.OpUserID = Convert.ToInt64(ctrl.Session["UserID"]);
         DE.SaveChanges();
     }
     return status;
 }
 public bool Update(TB_TypeHotelClassExt model, ref string Msg, Controller ctrl)
 {
     bool status = true;
     using (DBEntities DE = new DBEntities())
     {
         var DepObj = DE.TB_TypeHotelClass.Where(x => x.ID == model.ID).FirstOrDefault();
         DepObj.Code = model.Code;
         DepObj.Name_en = model.Name_en;
         DepObj.Name_tr = model.Name_tr;
         DepObj.Name_de = model.Name_de;
         DepObj.Name_es = model.Name_es;
         DepObj.Name_fr = model.Name_fr;
         DepObj.Name_ru = model.Name_ru;
         DepObj.Name_it = model.Name_it;
         DepObj.Name_ar = model.Name_ar;
         DepObj.Name_ja = model.Name_ja;
         DepObj.Name_pt = model.Name_pt;
         DepObj.Name_zh = model.Name_zh;
         DepObj.Sort = Convert.ToInt16(model.Sorts);
         DepObj.Active = model.Active;
         DepObj.OpDateTime = DateTime.Now;
         DepObj.OpUserID = 0;
         DE.SaveChanges();
     }
     return status;
 }
 public bool Create(MessageExt model, ref string Msg, Controller ctrl)
 {
     bool status = true;
     DBEntities insertentity = new DBEntities();
     BizTbl_Message MsgObj = new BizTbl_Message();
     MsgObj.Code = model.Code;
     MsgObj.Description_tr = model.Description_tr;
     MsgObj.Description_en = model.Description_en;
     MsgObj.Description_de = model.Description_de;
     MsgObj.Description_es = model.Description_es;
     MsgObj.Description_fr = model.Description_fr;
     MsgObj.Description_ru = model.Description_ru;
     MsgObj.Description_it = model.Description_it;
     MsgObj.Description_ar = model.Description_ar;
     MsgObj.Description_ja = model.Description_ja;
     MsgObj.Description_pt = model.Description_pt;
     MsgObj.Description_zh = model.Description_zh;
     MsgObj.Description_pt = model.Description_pt;
     MsgObj.IsCommon = true;
     MsgObj.OpDateTime = DateTime.Now;
     MsgObj.OpUserID = Convert.ToInt64(ctrl.Session["UserID"]);
     insertentity.BizTbl_Message.Add(MsgObj);
     insertentity.SaveChanges();
     int id = MsgObj.ID;
     return status;
 }