public ActionResult _Destroy([DataSourceRequest]DataSourceRequest request, TB_TransferExt model)
{
string Msg = "";
try
{
TB_TransferRepository modelRepo = new TB_TransferRepository();
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_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 Delete(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();
DE.TB_Transfer.Remove(DepObj);
DE.SaveChanges();
}
return status;
}
public List<TB_TransferExt> GetAllTableValue(int TableID)
{
List<TB_TransferExt> list = new List<TB_TransferExt>();
DataTable dt = new DataTable();
SQLCon.Open();
SqlCommand cmd = new SqlCommand("B_DisplayTable_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_TransferExt model = new TB_TransferExt();
model.ID = Convert.ToInt32(dr["ID"]);
model.BusinessPartnerID = Convert.ToInt32(dr["BusinessPartnerID"]);
model.BusinessPartnerName = dr["FK_BusinessPartnerID_ID"].ToString();
model.TransferPeriodName = dr["FK_TransferPeriodID_ID"].ToString();
model.TransferPeriodID = Convert.ToInt32(dr["TransferPeriodID"]);
model.TransferPaxID = Convert.ToInt32(dr["TransferPaxID"]);
model.TransferPaxName = dr["FK_TransferPaxID_ID"].ToString();
model.DepartureRegionID = Convert.ToInt64(dr["DepartureRegionID"]);
model.DepartureRegionName = dr["FK_DepartureRegionID_ID"].ToString();
model.DestinationRegionID = Convert.ToInt64(dr["DestinationRegionID"]);
model.DestinationRegionName = dr["FK_DestinationRegionID_ID"].ToString();
model.Amount = Convert.ToDecimal(dr["Amount"]);
model.Cost = Convert.ToDecimal(dr["Cost"]);
model.Deposit = Convert.ToDecimal(dr["Deposit"]);
model.CurrencyID = Convert.ToInt32(dr["CurrencyID"]);
model.Currency = dr["FK_CurrencyID_ID"].ToString();
model.CostCurrencyID = Convert.ToInt32(dr["CostCurrencyID"]);
model.CostCurrencyName = dr["FK_CostCurrencyID_ID"].ToString();
model.DepositCurrencyID = Convert.ToInt32(dr["DepositCurrencyID"]);
model.DepositCurrencyName = dr["FK_DepositCurrencyID_ID"].ToString();
model.HitCount = Convert.ToInt64(dr["HitCount"]);
model.Active = Convert.ToBoolean(dr["Active"]);
list.Add(model);
}
}
return list;
}
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;
}