public static int Update(SupplierMasterData suppliermasterdata)
{
var r = DataFacade.GetDataRow("SupplierMasterDataUpdate",
new ParameterValue("SupplierMasterDataID",
suppliermasterdata.SupplierMasterDataID),
new ParameterValue("SupplierID", suppliermasterdata.SupplierID),
new ParameterValue("DateCreated", suppliermasterdata.DateCreated),
new ParameterValue("SupplierSpecialistVerification",
suppliermasterdata.SupplierSpecialistVerification),
new ParameterValue("SupplierSpecialistVerificationDate",
suppliermasterdata.SupplierSpecialistVerificationDate),
new ParameterValue("AssignedCategoryManager",
suppliermasterdata.AssignedCategoryManager),
new ParameterValue("IsApproved", suppliermasterdata.IsApproved),
new ParameterValue("ApprovedDate", suppliermasterdata.ApprovedDate),
new ParameterValue("Comments", suppliermasterdata.Comments),
new ParameterValue("MasterDataStatus", suppliermasterdata.MasterDataStatus),
new ParameterValue("MasterDataStatusDate",
suppliermasterdata.MasterDataStatusDate),
new ParameterValue("Archive", suppliermasterdata.Archive)
);
var supplierMasterDataID = (int)r["SupplierMasterDataID"];
return(supplierMasterDataID);
}
public static SupplierMasterData SupplierMasterDataGet(int suppliermasterdataid)
{
var suppliermasterdata = new SupplierMasterData();
var paramList = new List <ParameterValue> {
new ParameterValue("SupplierMasterDataID", suppliermasterdataid)
};
var r = DataFacade.GetDataRow("SupplierMasterDataGet",
paramList.ToArray());
if (r != null)
{
Populate(suppliermasterdata, r);
}
return(suppliermasterdata);
}
public static List <SupplierMasterData> GetAll()
{
var paramList = new List <ParameterValue>();
var dataTable = DataFacade.GetDataTable("SupplierMasterDataGetAll",
paramList.ToArray());
var returnList = new List <SupplierMasterData>();
foreach (DataRow r in dataTable.Rows)
{
var suppliermasterdata = new SupplierMasterData();
Populate(suppliermasterdata, r);
returnList.Add(suppliermasterdata);
}
return(returnList);
}
public int Update(SupplierMasterData suppliermasterdata)
{
return(SupplierMasterDataDao.Update(suppliermasterdata));
}
public int Add(SupplierMasterData suppliermasterdata)
{
return(SupplierMasterDataDao.Add(suppliermasterdata));
}
public static SupplierMasterData Populate(SupplierMasterData suppliermasterdata, DataRow dr)
{
if (dr["SupplierMasterDataID"] != DBNull.Value)
{
suppliermasterdata.SupplierMasterDataID = Convert.ToInt32(dr["SupplierMasterDataID"]);
}
if (dr["SupplierID"] != DBNull.Value)
{
suppliermasterdata.SupplierID = Convert.ToInt32(dr["SupplierID"]);
}
if (dr["DateCreated"] != DBNull.Value)
{
suppliermasterdata.DateCreated = Convert.ToDateTime(dr["DateCreated"]);
}
if (dr["SupplierSpecialistVerification"] != DBNull.Value)
{
suppliermasterdata.SupplierSpecialistVerification =
Convert.ToString(dr["SupplierSpecialistVerification"]);
}
if (dr["SupplierSpecialistVerificationDate"] != DBNull.Value)
{
suppliermasterdata.SupplierSpecialistVerificationDate =
Convert.ToDateTime(dr["SupplierSpecialistVerificationDate"]);
}
if (dr["AssignedCategoryManager"] != DBNull.Value)
{
suppliermasterdata.AssignedCategoryManager = Convert.ToString(dr["AssignedCategoryManager"]);
}
if (dr["IsApproved"] != DBNull.Value)
{
suppliermasterdata.IsApproved = Convert.ToBoolean(dr["IsApproved"]);
}
if (dr["ApprovedDate"] != DBNull.Value)
{
suppliermasterdata.ApprovedDate = Convert.ToDateTime(dr["ApprovedDate"]);
}
if (dr["Comments"] != DBNull.Value)
{
suppliermasterdata.Comments = Convert.ToString(dr["Comments"]);
}
if (dr["MasterDataStatus"] != DBNull.Value)
{
suppliermasterdata.MasterDataStatus = Convert.ToString(dr["MasterDataStatus"]);
}
if (dr["MasterDataStatusDate"] != DBNull.Value)
{
suppliermasterdata.MasterDataStatusDate = Convert.ToDateTime(dr["MasterDataStatusDate"]);
}
if (dr["Archive"] != DBNull.Value)
{
suppliermasterdata.Archive = Convert.ToBoolean(dr["Archive"]);
}
return(suppliermasterdata);
}
