private List <SqlParameter> Set_Values_In_PArticle(PArticleInfo pArticle)
{
List <SqlParameter> sqlParams = new List <SqlParameter>();
sqlParams.Add(new SqlParameter("@Quality_No", pArticle.Quality_No));
sqlParams.Add(new SqlParameter("@Yarn_Type_Id", pArticle.Yarn_Type_Id));
sqlParams.Add(new SqlParameter("@Weave_Id", pArticle.Weave_Id));
sqlParams.Add(new SqlParameter("@Shade_Id", pArticle.Shade_Id));
sqlParams.Add(new SqlParameter("@Chemical_Finish_Id", pArticle.Chemical_Finish_Id));
sqlParams.Add(new SqlParameter("@Mechanical_Finish_Id", pArticle.Mechanical_Finish_Id));
sqlParams.Add(new SqlParameter("@P_Finish_width", pArticle.P_Finish_width));
sqlParams.Add(new SqlParameter("@Type_Id", pArticle.Type_Id));
sqlParams.Add(new SqlParameter("@Full_Code", pArticle.Full_Code));
sqlParams.Add(new SqlParameter("@Given_By_Id", pArticle.Given_By_Id));
sqlParams.Add(new SqlParameter("@Validated_By_Id", pArticle.Validated_By_Id));
sqlParams.Add(new SqlParameter("@Developed_Under_Id", pArticle.Developed_Under_Id));
sqlParams.Add(new SqlParameter("@Batch", pArticle.Batch));
sqlParams.Add(new SqlParameter("@Is_Active", pArticle.Is_Active));
if (pArticle.P_Article_Id == 0)
{
sqlParams.Add(new SqlParameter("@CreatedBy", pArticle.CreatedBy));
sqlParams.Add(new SqlParameter("@CreatedOn", pArticle.CreatedOn));
}
if (pArticle.P_Article_Id != 0)
{
sqlParams.Add(new SqlParameter("@P_Article_Id", pArticle.P_Article_Id));
}
sqlParams.Add(new SqlParameter("@UpdatedBy", pArticle.UpdatedBy));
sqlParams.Add(new SqlParameter("@UpdatedOn", pArticle.UpdatedOn));
return(sqlParams);
}
public int Insert_PArticle(PArticleInfo pArticle)
{
int pArticle_Id = 0;
pArticle_Id = Convert.ToInt32(_sqlRepo.ExecuteScalerObj(Set_Values_In_PArticle(pArticle), StoredProcedures.Insert_P_Article_Sp.ToString(), CommandType.StoredProcedure));
return(pArticle_Id);
}
private PArticleInfo Get_PArticle_Values(DataRow dr)
{
PArticleInfo pArticle = new PArticleInfo();
pArticle.P_Article_Id = Convert.ToInt32(dr["P_Article_Id"]);
pArticle.Quality_No = Convert.ToInt32(dr["Quality_No"]);
pArticle.Yarn_Type_Id = Convert.ToInt32(dr["Yarn_Type_Id"]);
pArticle.Weave_Id = Convert.ToInt32(dr["Weave_Id"]);
pArticle.Shade_Id = Convert.ToInt32(dr["Shade_Id"]);
pArticle.Chemical_Finish_Id = Convert.ToInt32(dr["Chemical_Finish_Id"]);
pArticle.Mechanical_Finish_Id = Convert.ToInt32(dr["Mechanical_Finish_Id"]);
pArticle.Type_Id = Convert.ToInt32(dr["Type_Id"]);
pArticle.Full_Code = Convert.ToString(dr["Full_Code"]);
pArticle.Given_By_Id = Convert.ToInt32(dr["Given_By_Id"]);
pArticle.Validated_By_Id = Convert.ToInt32(dr["Validated_By_Id"]);
pArticle.Developed_Under_Id = Convert.ToInt32(dr["Developed_Under_Id"]);
pArticle.Batch = Convert.ToString(dr["Batch"]);
pArticle.Is_Active = Convert.ToBoolean(dr["Is_Active"]);
pArticle.CreatedBy = Convert.ToInt32(dr["CreatedBy"]);
pArticle.CreatedOn = Convert.ToDateTime(dr["CreatedOn"]);
pArticle.UpdatedBy = Convert.ToInt32(dr["UpdatedBy"]);
pArticle.UpdatedOn = Convert.ToDateTime(dr["UpdatedOn"]);
pArticle.P_Finish_width = Convert.ToDecimal(dr["P_Finish_width"]);
pArticle.Yarn_Type_Name = Convert.ToString(dr["Yarn_Type_Name"]);
pArticle.Weave_Name = Convert.ToString(dr["Weave_Name"]);
pArticle.Shades_Name = Convert.ToString(dr["Shade_Name"]);
pArticle.Developed_Under_Name = Convert.ToString(dr["Developed_Under_Name"]);
pArticle.Validated_By_Name = Convert.ToString(dr["Validated_By_Name"]);
pArticle.Given_By_Name = Convert.ToString(dr["Given_By_Name"]);
pArticle.Quality_Nos = Convert.ToInt32(dr["Quality_Nos"]);
//
pArticle.Type_Name = Convert.ToString(dr["Type_Name"]);
pArticle.Chemical_Finish_Name = Convert.ToString(dr["Chemical_Finish"]);
pArticle.Mechanical_Finish_Name = Convert.ToString(dr["Mechanical_Finish"]);
pArticle.Yarn_Type_Code = Convert.ToString(dr["Yarn_Type_Code"]);
pArticle.Weave_Code = Convert.ToString(dr["Weave_Code"]);
pArticle.Shade_Code = Convert.ToString(dr["Shade_Code"]);
pArticle.Chemical_Finish_Code = Convert.ToString(dr["Chemical_Finish_Code"]);
pArticle.Mechanical_Finish_Code = Convert.ToString(dr["Mechanical_Finish_Code"]);
pArticle.Type_Code = Convert.ToString(dr["Type_Code"]);
return(pArticle);
}
public PArticleViewModel()
{
PArticles = new List <PArticleInfo>();
PArticle = new PArticleInfo();
Friendly_Message = new List <FriendlyMessageInfo>();
Pager = new PaginationInfo();
Filter = new PArticle_Filter();
Attribute_Codes = new List <AttributeCodeInfo>();
Quality_Nos = new List <QualityInfo>();
}
public PArticleInfo Get_PArticles_By_Id(int pArticle_Id)
{
PArticleInfo pArticle = new PArticleInfo();
List <SqlParameter> sqlparam = new List <SqlParameter>();
sqlparam.Add(new SqlParameter("@pArticle_Id", pArticle_Id));
DataTable dt = _sqlRepo.ExecuteDataTable(sqlparam, StoredProcedures.Get_P_Article_By_Id_sp.ToString(), CommandType.StoredProcedure);
List <DataRow> drList = new List <DataRow>();
drList = dt.AsEnumerable().ToList();
foreach (DataRow dr in drList)
{
pArticle = Get_PArticle_Values(dr);
}
return(pArticle);
}
public void Update_PArticle(PArticleInfo pArticle)
{
_pArticleRepo.Update_PArticle(pArticle);
}
public int Insert_PArticle(PArticleInfo pArticle)
{
return(_pArticleRepo.Insert_PArticle(pArticle));
}
public void Update_PArticle(PArticleInfo pArticle)
{
_sqlRepo.ExecuteNonQuery(Set_Values_In_PArticle(pArticle), StoredProcedures.Update_P_Article_Sp.ToString(), CommandType.StoredProcedure);
}
