public List<BizTbl_UserBusinessPartnerExt> GetTableValue()
{
DBEntities entity = new DBEntities();
DataTable dt = new DataTable();
//var Culture = new SqlParameter("@CultureCode", CultureCode);
dt.Columns.Add("id");
dt.Columns.Add("Name");
List<BizTbl_UserBusinessPartnerExt> ListOfModel = new List<BizTbl_UserBusinessPartnerExt>();
var result = entity.Database.SqlQuery<GetBusinessPartener_Result>("B_Ex_GetBusinessPartner_BizTbl_UserBusinessPartner_SP").ToList();
foreach (GetBusinessPartener_Result Val in result)
{
dt.Rows.Add(Val.id, Val.Name);
}
if (dt.Rows.Count > 0)
{
foreach (DataRow dr in dt.Rows)
{
BizTbl_UserBusinessPartnerExt HitObj = new BizTbl_UserBusinessPartnerExt();
HitObj.ID = Convert.ToInt32(dr["id"]);
HitObj.Name = dr["Name"].ToString();
ListOfModel.Add(HitObj);
}
}
return ListOfModel;
}
public List<BizTbl_UserBusinessPartnerExt> ReadAll(int TableID)
{
List<BizTbl_UserBusinessPartnerExt> list = new List<BizTbl_UserBusinessPartnerExt>();
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)
{
BizTbl_UserBusinessPartnerExt model = new BizTbl_UserBusinessPartnerExt();
model.ID = Convert.ToInt32(dr["ID"]);
model.User = dr["FK_UserID_ID"].ToString();
model.BusinessPartnerID = Convert.ToInt32(dr["BusinessPartnerID"]);
model.BusinessPartner = dr["FK_BusinessPartnerID_ID"].ToString();
list.Add(model);
}
}
return list;
}