public ActionResult _Destroy([DataSourceRequest]DataSourceRequest request, TB_TourAttributeExt model) { string Msg = ""; try { TB_TourAttributeRepository modelRepo = new TB_TourAttributeRepository(); if (modelRepo.Delete(model, ref Msg, this) == false) { return this.Json(new DataSourceResult { Errors = Msg }); } } catch (Exception ex) { string hostName1 = Dns.GetHostName(); string GetUserIPAddress = Dns.GetHostByName(hostName1).AddressList[0].ToString(); string PageName = Convert.ToString(Session["PageName"]); //string GetUserIPAddress = GetUserIPAddress1(); using (BaseRepository baseRepo = new BaseRepository()) { //BizContext BizContext1 = new BizContext(); BizApplication.AddError(baseRepo.BizDB, PageName, ex.Message, ex.StackTrace, DateTime.Now, GetUserIPAddress); } Session["PageName"] = ""; string error = ErrorHandling.HandleException(ex); return this.Json(new DataSourceResult { Errors = error }); } return Json(request); }
public bool Update(TB_TourAttributeExt model, ref string Msg, Controller ctrl) { bool status = true; var obj = db.TB_TourAttribute.Where(x => x.ID == model.ID).FirstOrDefault(); obj.ID = model.ID; obj.TourID = model.TourID; obj.AttributeID = model.AttributeID; obj.Charged = model.Charged; obj.UnitValue = model.UnitValue; obj.Charge = model.Charge; obj.CurrencyID = model.CurrencyID; obj.StartDate = Convert.ToDateTime(model.StartDate); obj.EndDate = Convert.ToDateTime(model.EndDate); obj.Active = model.Active; obj.OpDateTime = DateTime.Now; obj.OpUserID = Convert.ToInt64(ctrl.Session["UserID"]); db.SaveChanges(); return status; }
public bool Delete(TB_TourAttributeExt model, ref string Msg, Controller ctrl) { bool status = true; var obj = db.TB_TourAttribute.Where(x => x.ID == model.ID).FirstOrDefault(); db.TB_TourAttribute.Remove(obj); db.SaveChanges(); return status; }
public List<TB_TourAttributeExt> ReadAll(int TableID) { List<TB_TourAttributeExt> list = new List<TB_TourAttributeExt>(); DataTable dt = new DataTable(); SQLCon.Open(); SqlCommand cmd = new SqlCommand("B_DisplayTableNew_BizTbl_Table_Sp", SQLCon); cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.AddWithValue("@TableID", TableID); cmd.Parameters.AddWithValue("@CultureCode", CultureCode); SqlDataAdapter sda = new SqlDataAdapter(cmd); sda.Fill(dt); SQLCon.Close(); if (dt.Rows.Count > 0) { foreach (DataRow dr in dt.Rows) { TB_TourAttributeExt model = new TB_TourAttributeExt(); model.ID = Convert.ToInt32(dr["ID"]); model.Tour = dr["FK_TourID_ID"].ToString(); model.Attribute = dr["FK_AttributeID_ID"].ToString(); model.Charged = Convert.ToBoolean(dr["Charged"].ToString()); model.UnitValue = dr["UnitValue"].ToString(); //model.Charge = Convert.ToDecimal(dr["Charge"].ToString()); //model.CurrencyID = Convert.ToInt32(dr["CurrencyID"].ToString()); model.Charge = (Nullable<decimal>)CheckEmptyStringDBParameter(dr["Charge"].ToString(), false, false, false, true); model.CurrencyID = (Nullable<int>)CheckEmptyStringDBParameter(dr["CurrencyID"].ToString(), true); model.StartDate = Convert.ToDateTime(dr["StartDate"].ToString()); model.EndDate = Convert.ToDateTime(dr["EndDate"].ToString()); model.Active = Convert.ToBoolean(dr["Active"]); model.TourID = Convert.ToInt32(dr["TourID"]); model.AttributeID = Convert.ToInt32(dr["AttributeID"]); list.Add(model); } } return list; }
public bool Create(TB_TourAttributeExt model, ref string Msg, Controller ctrl) { bool status = true; TB_TourAttribute obj = new TB_TourAttribute(); obj.TourID = model.TourID; obj.AttributeID = model.AttributeID; obj.Charged = model.Charged; obj.UnitValue = model.UnitValue; obj.Charge = model.Charge; obj.CurrencyID = model.CurrencyID; obj.StartDate = Convert.ToDateTime(model.StartDate); obj.EndDate = Convert.ToDateTime(model.EndDate); obj.Active = model.Active; obj.OpDateTime = DateTime.Now; obj.OpUserID = Convert.ToInt64(ctrl.Session["UserID"]); db.TB_TourAttribute.Add(obj); db.SaveChanges(); int id = obj.ID; return status; }