private List <SqlParameter> Set_Values_In_WArticle(WArticleInfo wArticle)
{
List <SqlParameter> sqlParams = new List <SqlParameter>();
if (wArticle.W_Article_Id != 0)
{
sqlParams.Add(new SqlParameter("@W_Article_Id", wArticle.W_Article_Id));
}
sqlParams.Add(new SqlParameter("@Quality_Id", wArticle.Quality_Id));
sqlParams.Add(new SqlParameter("@Yarn_Type_Id", wArticle.Yarn_Type_Id));
sqlParams.Add(new SqlParameter("@Reed_Space_Inch", wArticle.Reed_Space_Inch));
sqlParams.Add(new SqlParameter("@Total_No_Of_Ends", wArticle.Total_No_Of_Ends));
sqlParams.Add(new SqlParameter("@Full_Code", wArticle.Full_Code));
sqlParams.Add(new SqlParameter("@Ideal_Beam", wArticle.Ideal_Beam));
sqlParams.Add(new SqlParameter("@Is_Active", wArticle.Is_Active));
if (wArticle.W_Article_Id == 0)
{
sqlParams.Add(new SqlParameter("@CreatedBy", wArticle.CreatedBy));
sqlParams.Add(new SqlParameter("@CreatedOn", wArticle.CreatedOn));
}
sqlParams.Add(new SqlParameter("@UpdatedBy", wArticle.UpdatedBy));
sqlParams.Add(new SqlParameter("@UpdatedOn", wArticle.UpdatedOn));
return(sqlParams);
}
public int Insert_WArticle(WArticleInfo wArticle)
{
int wArticle_Id = 0;
_sqlRepo.ExecuteNonQuery(Set_Values_In_WArticle(wArticle), StoredProcedures.Insert_W_Article_Sp.ToString(), CommandType.StoredProcedure);
return(wArticle_Id);
}
public WArticleViewModel()
{
WArticle = new WArticleInfo();
WArticles = new List <WArticleInfo>();
Quality_List = new List <QualityInfo>();
Attribute_Codes = new List <AttributeCodeInfo>();
Friendly_Message = new List <FriendlyMessageInfo>();
Pager = new PaginationInfo();
Filter = new WArticle_Filter();
}
private WArticleInfo Get_WArticle_Values(DataRow dr)
{
WArticleInfo wArticle = new WArticleInfo();
wArticle.W_Article_Id = Convert.ToInt32(dr["W_Article_Id"]);
if (DBNull.Value != dr["Quality_Id"])
{
wArticle.Quality_Id = Convert.ToInt32(dr["Quality_Id"]);
}
if (DBNull.Value != dr["Yarn_Type_Id"])
{
wArticle.Yarn_Type_Id = Convert.ToInt32(dr["Yarn_Type_Id"]);
}
if (DBNull.Value != dr["Reed_Space_Inch"])
{
wArticle.Reed_Space_Inch = Convert.ToDecimal(dr["Reed_Space_Inch"]);
}
if (DBNull.Value != dr["Total_No_Of_Ends"])
{
wArticle.Total_No_Of_Ends = Convert.ToDecimal(dr["Total_No_Of_Ends"]);
}
wArticle.Full_Code = Convert.ToString(dr["Full_Code"]);
wArticle.Ideal_Beam = Convert.ToString(dr["Ideal_Beam"]);
if (DBNull.Value != dr["Is_Active"])
{
wArticle.Is_Active = Convert.ToBoolean(dr["Is_Active"]);
}
wArticle.CreatedBy = Convert.ToInt32(dr["CreatedBy"]);
wArticle.CreatedOn = Convert.ToDateTime(dr["CreatedOn"]);
wArticle.UpdatedBy = Convert.ToInt32(dr["UpdatedBy"]);
wArticle.UpdatedOn = Convert.ToDateTime(dr["UpdatedOn"]);
if (DBNull.Value != dr["Quality_No"])
{
wArticle.Quality_No = Convert.ToInt32(dr["Quality_No"]);
}
wArticle.Yarn_Type_Name = Convert.ToString(dr["Yarn_Type_Name"]);
wArticle.Yarn_Type_Code = Convert.ToString(dr["Yarn_Type_Code"]); //
return(wArticle);
}
public WArticleInfo Get_WArticle_By_Id(int wArticle_Id)
{
WArticleInfo wArticle = new WArticleInfo();
List <SqlParameter> sqlparam = new List <SqlParameter>();
sqlparam.Add(new SqlParameter("@wArticle_Id", wArticle_Id));
DataTable dt = _sqlRepo.ExecuteDataTable(sqlparam, StoredProcedures.Get_W_Article_By_Id_Sp.ToString(), CommandType.StoredProcedure);
List <DataRow> drList = new List <DataRow>();
drList = dt.AsEnumerable().ToList();
foreach (DataRow dr in drList)
{
wArticle = Get_WArticle_Values(dr);
}
return(wArticle);
}
public void Update_WArticle(WArticleInfo wArticle)
{
_wArticleRepo.Update_WArticle(wArticle);
}
public int Insert_WArticle(WArticleInfo wArticle)
{
return(_wArticleRepo.Insert_WArticle(wArticle));
}
public void Update_WArticle(WArticleInfo wArticle)
{
_sqlRepo.ExecuteNonQuery(Set_Values_In_WArticle(wArticle), StoredProcedures.Update_W_Article_Sp.ToString(), CommandType.StoredProcedure);
}
