public List<TB_BusinessPartnerExt> ReadAll(int TableID)
{
List<TB_BusinessPartnerExt> list = new List<TB_BusinessPartnerExt>();
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_BusinessPartnerExt model = new TB_BusinessPartnerExt();
model.ID = Convert.ToInt32(dr["ID"]);
model.BusinessPartnerTypeID = Convert.ToInt32(dr["BusinessPartnerTypeID"]);
model.BusinessPartnerType = dr["FK_BusinessPartnerTypeID_ID"].ToString();
model.FirmID = Convert.ToInt32(dr["FirmID"]);
model.Firm = dr["FK_FirmID_ID"].ToString();
model.CountryID = Convert.ToInt32(dr["CountryID"]);
model.Country = dr["FK_CountryID_ID"].ToString();
model.City = dr["FK_CityID_ID"].ToString();
if (dr["CityID"].ToString() != null && dr["CityID"].ToString() != "")
{
model.CityID = Convert.ToInt32(dr["CityID"]);
}
else
{
model.CityID = 0;
}
model.Name = dr["Name"].ToString();
model.Description = dr["Description"].ToString();
model.Address = dr["Address"].ToString();
model.Phone = dr["Phone"].ToString();
model.Fax = dr["Fax"].ToString();
model.PostCode = dr["PostCode"].ToString();
model.WebAddress = dr["WebAddress"].ToString();
model.Email = dr["Email"].ToString();
string value = Convert.ToString(dr["TransferCostCurrencyID"]);
if (dr["TransferCostCurrencyID"].ToString() != null && dr["TransferCostCurrencyID"].ToString() != "")
{
model.TransferCostCurrencyID = Convert.ToInt32(dr["TransferCostCurrencyID"].ToString());
}
else
{
model.TransferCostCurrencyID = 0;
}
model.TransferCostCurrency = dr["FK_TransferCostCurrencyID_ID"].ToString();
if (dr["TransferCurrencyID"].ToString() != null && dr["TransferCurrencyID"].ToString() != "")
{
model.TransferCurrencyID = Convert.ToInt32(dr["TransferCurrencyID"]);
}
else
{
model.TransferCurrencyID = 0;
}
model.TransferCurrency = dr["FK_TransferCurrencyID_ID"].ToString();
if (dr["TransferDepositTypeID"].ToString() != null && dr["TransferDepositTypeID"].ToString() != "")
{
model.TransferDepositTypeID = Convert.ToInt32(dr["TransferDepositTypeID"]);
}
else
{
model.TransferDepositTypeID = 0;
}
model.TransferDepositType = dr["FK_TransferDepositTypeID_ID"].ToString();
if (dr["TourCostCurrencyID"].ToString() != null && dr["TourCostCurrencyID"].ToString() != "")
{
model.TourCostCurrencyID = Convert.ToInt32(dr["TourCostCurrencyID"]);
}
else
{
model.TourCostCurrencyID = 0;
}
model.TourCostCurrency = dr["FK_TourCostCurrencyID_ID"].ToString();
if (dr["TourCurrencyID"].ToString() != null && dr["TourCurrencyID"].ToString() != "")
{
model.TourCurrencyID = Convert.ToInt32(dr["TourCurrencyID"]);
}
else
{
model.TourCurrencyID = 0;
}
model.TourCurrency = dr["FK_TourCurrencyID_ID"].ToString();
if (dr["TourDepositTypeID"].ToString() != null && dr["TourDepositTypeID"].ToString() != "")
{
model.TourDepositTypeID = Convert.ToInt32(dr["TourDepositTypeID"]);
}
else
{
model.TourDepositTypeID = 0;
}
model.TourDepositType = dr["FK_TourDepositTypeID_ID"].ToString();
if (dr["DealCostCurrencyID"].ToString() != null && dr["DealCostCurrencyID"].ToString() != "")
{
model.DealCostCurrencyID = Convert.ToInt32(dr["DealCostCurrencyID"]);
}
else
{
model.DealCostCurrencyID = 0;
}
model.DealCostCurrency = dr["FK_DealCostCurrencyID_ID"].ToString();
if (dr["DealCurrencyID"].ToString() != null && dr["DealCurrencyID"].ToString() != "")
{
model.DealCurrencyID = Convert.ToInt32(dr["DealCurrencyID"]);
}
else
{
model.DealCurrencyID = 0;
}
model.DealCurrency = dr["FK_DealCurrencyID_ID"].ToString();
if (dr["DealDepositTypeID"].ToString() != null && dr["DealDepositTypeID"].ToString() != "")
{
model.DealDepositTypeID = Convert.ToInt32(dr["DealDepositTypeID"]);
}
else
{
model.DealDepositTypeID = 0;
}
model.DealDepositType = dr["FK_DealDepositTypeID_ID"].ToString();
model.HitCount = dr["HitCount"].ToString();
model.Sorts = dr["Sort"].ToString();
model.StatusID = Convert.ToInt32(dr["StatusID"]);
model.Status = dr["FK_StatusID_ID"].ToString();
model.Active = Convert.ToBoolean(dr["Active"]);
model.IPAddress = dr["IPAddress"].ToString();
list.Add(model);
}
}
return list;
}
public bool Update(TB_BusinessPartnerExt model, ref string Msg, Controller ctrl)
{
bool status = true;
var obj = db.TB_BusinessPartner.Where(x => x.ID == model.ID).FirstOrDefault();
obj.ID = model.ID;
obj.BusinessPartnerTypeID = Convert.ToInt32(model.BusinessPartnerTypeID);
obj.FirmID = Convert.ToInt32(model.FirmID);
obj.CountryID = Convert.ToInt32(model.CountryID);
if (model.CityID != 0)
{
obj.CityID = Convert.ToInt32(model.CityID);
}
else
{
obj.CityID = null;
}
obj.Name = model.Name;
obj.Description_en = model.Description;
obj.Address = model.Address;
obj.Phone = model.Phone;
obj.Fax = model.Fax;
obj.PostCode = model.PostCode;
obj.WebAddress = model.WebAddress;
obj.Email = model.Email;
if (model.TransferCostCurrencyID != 0)
{
obj.TransferCostCurrencyID = model.TransferCostCurrencyID;
}
else
{
obj.TransferCostCurrencyID = null;
}
if (model.TransferCurrencyID != 0)
{
obj.TransferCurrencyID = model.TransferCurrencyID;
}
else
{
obj.TransferCurrencyID = null;
}
if (model.TransferDepositTypeID != 0)
{
obj.TransferDepositTypeID = model.TransferDepositTypeID;
}
else
{
obj.TransferDepositTypeID = null;
}
if (model.TourCostCurrencyID != 0)
{
obj.TourCostCurrencyID = model.TourCostCurrencyID;
}
else
{
obj.TourCostCurrencyID = null;
}
if (model.TourCurrencyID != 0)
{
obj.TourCurrencyID = model.TourCurrencyID;
}
else
{
obj.TourCurrencyID = null;
}
if (model.TourDepositTypeID != 0)
{
obj.TourDepositTypeID = model.TourDepositTypeID;
}
else
{
obj.TourDepositTypeID = null;
}
if (model.DealCostCurrencyID != 0)
{
obj.DealCostCurrencyID = model.DealCostCurrencyID;
}
else
{
obj.DealCostCurrencyID = null;
}
if (model.DealCurrencyID != 0)
{
obj.DealCurrencyID = model.DealCurrencyID;
}
else
{
obj.DealCurrencyID = null;
}
if (model.DealDepositTypeID != 0)
{
obj.DealDepositTypeID = model.DealDepositTypeID;
}
else
{
obj.DealDepositTypeID = null;
}
if (model.HitCount != "" && model.HitCount != null)
{
obj.HitCount = Convert.ToInt64(model.HitCount);
}
else
{
obj.HitCount = null;
}
if (model.Sorts != "" && model.Sorts != null)
{
obj.Sort = Convert.ToInt32(model.Sorts);
}
else
{
obj.Sort = null;
}
obj.StatusID = Convert.ToInt32(model.StatusID);
obj.Active = model.Active;
obj.IPAddress = model.IPAddress;
obj.CreateDateTime = DateTime.Now;
obj.CreateUserID = Convert.ToInt64(ctrl.Session["UserID"]);
obj.OpDateTime = DateTime.Now;
obj.OpUserID = Convert.ToInt64(ctrl.Session["UserID"]);
db.SaveChanges();
return status;
}
public bool Delete(TB_BusinessPartnerExt model, ref string Msg, Controller ctrl)
{
bool status = true;
var obj = db.TB_BusinessPartner.Where(x => x.ID == model.ID).FirstOrDefault();
db.TB_BusinessPartner.Remove(obj);
db.SaveChanges();
return status;
}
