public int Insert_Material_Vendor(MaterialVendorInfo MaterialVendorInfo)
{
int Material_Vendor_Id = 0;
Material_Vendor_Id = Convert.ToInt32(_sqlRepo.ExecuteScalerObj(Set_Values_In_Material_Vendor(MaterialVendorInfo), StoredProcedures.Insert_Material_Vendor_Sp.ToString(), CommandType.StoredProcedure));
return(Material_Vendor_Id);
}
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>();
}
public MaterialVendorViewModel()
{
Material_Vendor_Grid = new List <MaterialVendorInfo>();
Material_Vendor = new MaterialVendorInfo();
Friendly_Message = new List <FriendlyMessageInfo>();
Pager = new PaginationInfo();
}
private MaterialVendorInfo Get_Material_Vendor_Values(DataRow dr)
{
MaterialVendorInfo Material_vendor = new MaterialVendorInfo();
Material_vendor.Material_Vendor_Id = Convert.ToInt32(dr["Material_Vendor_Id"]);
Material_vendor.Material_Id = Convert.ToInt32(dr["Material_Id"]);
Material_vendor.Vendor_Id = Convert.ToInt32(dr["Vendor_Id"]);
Material_vendor.Vendor_Name = Convert.ToString(dr["Vendor_Name"]);
Material_vendor.Priority_Order = Convert.ToInt32(dr["Priority_Order"]);
return(Material_vendor);
}
public MaterialViewModel()
{
Material = new MaterialInfo();
Material_Vendor = new MaterialVendorInfo();
Materials = new List <MaterialInfo>();
Material_Vendors = new List <MaterialVendorInfo>();
Pager = new PaginationInfo();
Material_Categories = new List <MaterialCategoryInfo>();
Material_SubCategories = new List <MaterialSubCategoryInfo>();
Friendly_Message = new List <FriendlyMessageInfo>();
Filter = new MaterialFilter();
Vendor_Grid = new List <VendorInfo>();
}
private List <SqlParameter> Set_Values_In_Material_Vendor(MaterialVendorInfo MaterialVendorInfo)
{
List <SqlParameter> sqlParamList = new List <SqlParameter>();
if (MaterialVendorInfo.Material_Vendor_Id != 0)
{
sqlParamList.Add(new SqlParameter("@Material_Vendor_Id", MaterialVendorInfo.Material_Vendor_Id));
}
sqlParamList.Add(new SqlParameter("@Material_Id", MaterialVendorInfo.Material_Id));
sqlParamList.Add(new SqlParameter("@Vendor_Id", MaterialVendorInfo.Vendor_Id));
sqlParamList.Add(new SqlParameter("@Priority_Order", MaterialVendorInfo.Priority_Order));
if (MaterialVendorInfo.Material_Vendor_Id == 0)
{
sqlParamList.Add(new SqlParameter("@CreatedBy", MaterialVendorInfo.CreatedBy));
}
return(sqlParamList);
}
public void Update_Material_Vendor(MaterialVendorInfo MaterialVendorInfo)
{
}
public int Insert_Material_Vendor(MaterialVendorInfo MaterialVendorInfo)
{
return(_materialRepo.Insert_Material_Vendor(MaterialVendorInfo));
}
