public List <ConsumableVendorInfo> Get_Consumable_Vendor_By_Consumable_Id(int consumable_Id)
{
List <ConsumableVendorInfo> consumable_vendors = new List <ConsumableVendorInfo>();
List <SqlParameter> sqlParams = new List <SqlParameter>();
sqlParams.Add(new SqlParameter("@Consumable_Id", consumable_Id));
DataSet ds = _sqlRepo.ExecuteDataSet(sqlParams, StoredProcedures.Get_Consumable_Vendor_sp.ToString(), CommandType.StoredProcedure);
DataTable dt = ds.Tables[0];
if (dt != null && dt.Rows.Count > 0)
{
List <DataRow> drList = new List <DataRow>();
drList = dt.AsEnumerable().ToList();
foreach (DataRow dr in drList)
{
ConsumableVendorInfo ConsumableVendor = new ConsumableVendorInfo();
ConsumableVendor.Consumable_Vendor_Id = Convert.ToInt32(dr["Consumable_Vendor_Id"]);
ConsumableVendor.Vendor_Id = Convert.ToInt32(dr["Vendor_Id"]);
ConsumableVendor.Consumable_Id = Convert.ToInt32(dr["Consumable_Id"]);
ConsumableVendor.Priority_Order = Convert.ToInt32(dr["Priority_Order"]);
ConsumableVendor.Vendor_Entity.Vendor_Name = Convert.ToString(dr["Vendor_Name"]);
consumable_vendors.Add(ConsumableVendor);
}
}
return(consumable_vendors);
}
public WorkStationInfo Get_Work_Stations_By_Work_Station_Id(int work_Station_Id)
{
WorkStationInfo work_Station = new WorkStationInfo();
List <SqlParameter> sqlParams = new List <SqlParameter>();
sqlParams.Add(new SqlParameter("@Work_Station_Id", work_Station_Id));
DataSet ds = _sqlRepo.ExecuteDataSet(sqlParams, StoredProcedures.Get_Work_Stations_By_Work_Station_Id_Sp.ToString(), CommandType.StoredProcedure);
DataTable dt = ds.Tables[0];
//DataTable dt1 = ds.Tables[1];
if (dt != null && dt.Rows.Count > 0)
{
List <DataRow> drList = new List <DataRow>();
drList = dt.AsEnumerable().ToList();
foreach (DataRow dr in drList)
{
work_Station = Get_Work_Station_Values_By_Id(dr);
}
}
return(work_Station);
}
public CustomerQualityInfo Get_Customer_Quality_By_Id(int customer_Quality_Id)
{
CustomerQualityInfo customer_Quality = new CustomerQualityInfo();
List <SqlParameter> sqlParams = new List <SqlParameter>();
sqlParams.Add(new SqlParameter("@Customer_Quality_Id", customer_Quality_Id));
DataSet ds = _sqlRepo.ExecuteDataSet(sqlParams, StoredProcedures.Get_Customer_Quality_By_Id_Sp.ToString(), CommandType.StoredProcedure);
DataTable dt = ds.Tables[0];
if (dt != null && dt.Rows.Count > 0)
{
List <DataRow> drList = new List <DataRow>();
drList = dt.AsEnumerable().ToList();
foreach (DataRow dr in drList)
{
customer_Quality = Get_Customer_Quality_Values_By_Id(dr);
}
}
return(customer_Quality);
}
public CustomerInfo Get_Customer_By_Id(int customer_Id)
{
CustomerInfo customer = new CustomerInfo();
List <SqlParameter> sqlParams = new List <SqlParameter>();
sqlParams.Add(new SqlParameter("@Customer_Id", customer_Id));
DataSet ds = _sqlRepo.ExecuteDataSet(sqlParams, StoredProcedures.Get_Customer_By_Id_Sp.ToString(), CommandType.StoredProcedure);
DataTable dt = ds.Tables[0];
DataTable dt1 = ds.Tables[1];
DataTable dt2 = ds.Tables[2];
if (dt != null && dt.Rows.Count > 0)
{
List <DataRow> drList = new List <DataRow>();
drList = dt.AsEnumerable().ToList();
foreach (DataRow dr in drList)
{
customer = Get_Customer_Values(dr); // To bind customer data
}
}
if (dt1 != null && dt1.Rows.Count > 0)
{
List <DataRow> drList = new List <DataRow>();
drList = dt1.AsEnumerable().ToList();
foreach (DataRow dr in drList)
{
customer.Bank_Details = Get_Bank_Details_Values(dr); // To bind bank details
}
}
if (dt2 != null && dt2.Rows.Count > 0)
{
customer.Customer_Address_List = Get_Customer_Addresses(dt2); // to bind customer addresses
}
return(customer);
}
public UserInfo Get_User_By_User_Id(int UserId)
{
UserInfo user = new UserInfo();
List <SqlParameter> sqlParams = new List <SqlParameter>();
sqlParams.Add(new SqlParameter("@UserId", UserId));
DataSet ds = sqlRepo.ExecuteDataSet(sqlParams, StoredProcedures.Get_Users_By_Id_Sp.ToString(), CommandType.StoredProcedure);
DataTable dt = ds.Tables[0];
DataTable dt1 = ds.Tables[1];
if (dt != null && dt.Rows.Count > 0)
{
int count = dt.Rows.Count;
List <DataRow> drList = new List <DataRow>();
drList = dt.AsEnumerable().ToList();
foreach (DataRow dr in drList)
{
user = Get_User_Values(dr);
foreach (DataRow dr1 in dt1.Rows)
{
UserRoleInfo user_role = new UserRoleInfo();
user_role.Role_Name = Convert.ToString(dr1["Role_Name"]);
user_role.Role_Id = Convert.ToInt32(dr1["Role_Id"]);
user_role.UserId = Convert.ToInt32(dr1["UserId"]);
user.User_Roles.Add(user_role);
}
}
}
return(user);
}
public ContactInfo Get_Contact_By_Id(int Contact_Id)
{
ContactInfo contact = new ContactInfo();
List <SqlParameter> sqlParams = new List <SqlParameter>();
sqlParams.Add(new SqlParameter("@Contact_Id", Contact_Id));
DataSet ds = _sqlRepo.ExecuteDataSet(sqlParams, StoredProcedures.Get_Contact_by_Id_sp.ToString(), CommandType.StoredProcedure);
DataTable dt = ds.Tables[0];
DataTable dt1 = ds.Tables[1];
if (dt != null && dt.Rows.Count > 0)
{
List <DataRow> drList = new List <DataRow>();
drList = dt.AsEnumerable().ToList();
foreach (DataRow dr in drList)
{
contact = Get_Contact_Values(dr);
}
}
if (dt1 != null && dt1.Rows.Count > 0)
{
List <DataRow> drList = new List <DataRow>();
drList = dt1.AsEnumerable().ToList();
foreach (DataRow dr in drList)
{
contact.Contact_Custom_Fields_List.Add(Get_Contact_Custom_Fields_values(dr));
}
}
return(contact);
}
