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