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); }