public VendorViewModel()
{
Vendor_Grid = new List <VendorInfo>();
Material_Vendor_Grid = new List <MaterialVendorInfo>();
Vendor = new VendorInfo();
Material_Vendor = new MaterialVendorInfo();
Friendly_Message = new List <FriendlyMessageInfo>();
Pager = new PaginationInfo();
States = new List <StateInfo>();
Nations = new List <NationInfo>();
Filter = new Vendor_Filter();
Material_Category = new List <MaterialCategoryInfo>();
Is_Primary = false;
Attribute_Code = new AttributeCodeInfo();
Material_Category_Info = new MaterialCategoryInfo();
Materials = new List <MaterialInfo>();
}
private List <SqlParameter> Set_Values_In_Attribute_Code(AttributeCodeInfo attributeCodes)
{
List <SqlParameter> sqlParamList = new List <SqlParameter>();
sqlParamList.Add(new SqlParameter("@Status", attributeCodes.Status));
sqlParamList.Add(new SqlParameter("@Attribute_Id", attributeCodes.Attribute_Id));
sqlParamList.Add(new SqlParameter("@Attribute_Code_Name", attributeCodes.Attribute_Code_Name));
sqlParamList.Add(new SqlParameter("@Code", attributeCodes.Code));
sqlParamList.Add(new SqlParameter("@UpdatedBy", attributeCodes.UpdatedBy));
if (attributeCodes.Attribute_Code_Id == 0)
{
sqlParamList.Add(new SqlParameter("@CreatedBy", attributeCodes.CreatedBy));
}
if (attributeCodes.Attribute_Code_Id != 0)
{
sqlParamList.Add(new SqlParameter("@Attribute_Code_Id", attributeCodes.Attribute_Code_Id));
}
return(sqlParamList);
}
public AttributeCodeInfo Get_Attribute_Code_By_Id(int attributeCodeId)
{
AttributeCodeInfo retVal = new AttributeCodeInfo();
List <SqlParameter> sqlParams = new List <SqlParameter>();
sqlParams.Add(new SqlParameter("@Attribute_Code_Id", attributeCodeId));
DataTable dt = _sqlRepo.ExecuteDataTable(sqlParams, StoredProcedures.Get_Attribute_Code_By_Id_sp.ToString(), CommandType.StoredProcedure);
if (dt != null && dt.Rows.Count > 0)
{
int count = 0;
List <DataRow> drList = new List <DataRow>();
drList = dt.AsEnumerable().ToList();
count = drList.Count();
foreach (DataRow dr in drList)
{
retVal = (Get_Attribute_Code_Values(dr));
}
}
return(retVal);
}
public List <AttributeCodeInfo> Get_Weave_Types()
{
List <AttributeCodeInfo> retVal = new List <AttributeCodeInfo>();
DataTable dt = _sqlRepo.ExecuteDataTable(null, StoredProcedures.Get_Weaves_Types_sp.ToString(), CommandType.StoredProcedure);
if (dt != null && dt.Rows.Count > 0)
{
int count = 0;
List <DataRow> drList = new List <DataRow>();
drList = dt.AsEnumerable().ToList();
count = drList.Count();
foreach (DataRow dr in drList)
{
AttributeCodeInfo yarnTypes = new AttributeCodeInfo();
yarnTypes.Attribute_Code_Id = Convert.ToInt32(dr["Attribute_Code_Id"]);
yarnTypes.Attribute_Code_Name = Convert.ToString(dr["Attribute_Code_Name"]);
retVal.Add(yarnTypes);
}
}
return(retVal);
}
public int Insert_Attribute_Code(AttributeCodeInfo attributeCode)
{
int Attribute_Code_Id = 0;
Attribute_Code_Id = Convert.ToInt32(_sqlRepo.ExecuteScalerObj(Set_Values_In_Attribute_Code(attributeCode), StoredProcedures.Insert_Attribute_Code_sp.ToString(), CommandType.StoredProcedure));
return(Attribute_Code_Id);
}
public AttributeCodeInfo Get_Attribute_Code_By_Id(int attributeCodeId)
{
AttributeCodeInfo attributeCodeInfo = new AttributeCodeInfo();
AttributeCodeRepo dRepo = new AttributeCodeRepo();
attributeCodeInfo = dRepo.Get_Attribute_Code_By_Id(attributeCodeId);
return(attributeCodeInfo);
}
public AttributeCodeViewModel()
{
Attribute_Code = new AttributeCodeInfo();
Attribute_Code_Grid = new List <AttributeCodeInfo>();
Edit_Mode = new Attribute_Code_Edit_Mode();
Filter = new Attribute_Code_Filter();
Pager = new PaginationInfo();
Friendly_Message = new List <FriendlyMessageInfo>();
}
private AttributeCodeInfo Get_Attribute_Code_Values(DataRow dr)
{
AttributeCodeInfo attributeCodes = new AttributeCodeInfo();
attributeCodes.Attribute_Code_Id = Convert.ToInt32(dr["Attribute_Code_Id"]);
attributeCodes.Attribute_Id = Convert.ToInt32(dr["Attribute_Id"]);
attributeCodes.Attribute_Code_Name = Convert.ToString(dr["Attribute_Code_Name"]);
attributeCodes.Code = Convert.ToString(dr["Code"]);
attributeCodes.Status = Convert.ToBoolean(dr["Status"]);
attributeCodes.Attribute_Name = LookupInfo.GetAttributeNames()[attributeCodes.Attribute_Id];
return(attributeCodes);
}
public void Update(AttributeCodeInfo attributeCode)
{
AttributeCodeRepo dRepo = new AttributeCodeRepo();
dRepo.Update(attributeCode);
}
public void Insert(AttributeCodeInfo attributeCode)
{
AttributeCodeRepo dRepo = new AttributeCodeRepo();
dRepo.Insert(attributeCode);
}
public void Update(AttributeCodeInfo attributeCode)
{
_sqlRepo.ExecuteNonQuery(Set_Values_In_Attribute_Code(attributeCode), StoredProcedures.Update_Attribute_Code_sp.ToString(), CommandType.StoredProcedure);
}
public int Insert_Attribute_Code(AttributeCodeInfo attributeCode)
{
VendorRepo vRepo = new VendorRepo();
return(vRepo.Insert_Attribute_Code(attributeCode));
}
