Exemple #1
0
        public int Insert_YArticle(YArticleInfo yArticle)
        {
            int yArticle_Id = 0;

            yArticle_Id = Convert.ToInt32(_sqlRepo.ExecuteScalerObj(Set_Values_In_YArticle(yArticle), StoredProcedures.Insert_Y_Article_sp.ToString(), CommandType.StoredProcedure));

            return(yArticle_Id);
        }
        public YArticleViewModel()
        {
            YArticles = new List <YArticleInfo>();

            YArticle = new YArticleInfo();

            Friendly_Message = new List <FriendlyMessageInfo>();

            Pager = new PaginationInfo();

            Filter = new YArticle_Filter();

            Attribute_Codes = new List <AttributeCodeInfo>();

            Is_Primary = false;
        }
Exemple #3
0
        public YArticleInfo Get_YArticle_By_Id(int yArticle_Id)
        {
            YArticleInfo yArticle = new YArticleInfo();

            List <SqlParameter> sqlparam = new List <SqlParameter>();

            sqlparam.Add(new SqlParameter("@yArticle_Id", yArticle_Id));

            DataTable dt = _sqlRepo.ExecuteDataTable(sqlparam, StoredProcedures.Get_Y_Article_By_Id_sp.ToString(), CommandType.StoredProcedure);

            List <DataRow> drList = new List <DataRow>();

            drList = dt.AsEnumerable().ToList();

            foreach (DataRow dr in drList)
            {
                yArticle = Get_YArticle_Values(dr);
            }

            return(yArticle);
        }
Exemple #4
0
        public List <SqlParameter> Set_Values_In_YArticle(YArticleInfo yArticle)
        {
            List <SqlParameter> sqlparam = new List <SqlParameter>();

            if (yArticle.Y_Article_Id != 0)
            {
                sqlparam.Add(new SqlParameter("@Y_Article_Id", yArticle.Y_Article_Id));
            }
            sqlparam.Add(new SqlParameter("@Denier_Id", yArticle.Denier_Id));
            sqlparam.Add(new SqlParameter("@Twist_Mingle_Id", yArticle.Twist_Mingle_Id));
            sqlparam.Add(new SqlParameter("@Twist_Type_Id", yArticle.Twist_Type_Id));
            sqlparam.Add(new SqlParameter("@Ply_Id", yArticle.Ply_Id));
            sqlparam.Add(new SqlParameter("@Yarn_Type_Id", yArticle.Yarn_Type_Id));
            sqlparam.Add(new SqlParameter("@Shade_Id", yArticle.Shade_Id));
            sqlparam.Add(new SqlParameter("@Filaments_Id", yArticle.Filaments_Id));
            sqlparam.Add(new SqlParameter("@Origin_Id", yArticle.Origin_Id));
            sqlparam.Add(new SqlParameter("@Shrinkage_Id", yArticle.Shrinkage_Id));
            sqlparam.Add(new SqlParameter("@Tenasity_Id", yArticle.Tenasity_Id));
            sqlparam.Add(new SqlParameter("@Chemical_Treatment_Id", yArticle.Chemical_Treatment_Id));
            sqlparam.Add(new SqlParameter("@Colour_Id", yArticle.Colour_Id));
            sqlparam.Add(new SqlParameter("@Supplier_Id", yArticle.Supplier_Id));
            sqlparam.Add(new SqlParameter("@Full_Code", yArticle.Full_Code));
            sqlparam.Add(new SqlParameter("@Given_By_Id", yArticle.Given_By_Id));
            sqlparam.Add(new SqlParameter("@Validated_By_Id", yArticle.Validated_By_Id));
            sqlparam.Add(new SqlParameter("@Developed_Under_Id", yArticle.Developed_Under_Id));
            sqlparam.Add(new SqlParameter("@Lead_Time_To_Purchase", yArticle.Lead_Time_To_Purchase));
            sqlparam.Add(new SqlParameter("@Work_Center_Id", yArticle.Work_Center_Id));
            sqlparam.Add(new SqlParameter("@Is_Active", yArticle.Is_Active));
            if (yArticle.Y_Article_Id == 0)
            {
                sqlparam.Add(new SqlParameter("@CreatedBy", yArticle.CreatedBy));
            }
            sqlparam.Add(new SqlParameter("@UpdatedBy", yArticle.UpdatedBy));

            return(sqlparam);
        }
 public void Update_YArticle(YArticleInfo yArticle)
 {
     yArticleRepo.Update_YArticle(yArticle);
 }
 public int Insert_YArticle(YArticleInfo yArticle)
 {
     return(yArticleRepo.Insert_YArticle(yArticle));
 }
Exemple #7
0
 public void Update_YArticle(YArticleInfo yArticle)
 {
     _sqlRepo.ExecuteNonQuery(Set_Values_In_YArticle(yArticle), StoredProcedures.Update_Y_Article_sp.ToString(), CommandType.StoredProcedure);
 }
Exemple #8
0
        public YArticleInfo Get_YArticle_Values(DataRow dr)
        {
            YArticleInfo yArticle = new YArticleInfo();

            yArticle.Y_Article_Id          = Convert.ToInt32(dr["Y_Article_Id"]);
            yArticle.Denier_Id             = Convert.ToInt32(dr["Denier_Id"]);
            yArticle.Twist_Mingle_Id       = Convert.ToInt32(dr["Twist_Mingle_Id"]);
            yArticle.Twist_Type_Id         = Convert.ToInt32(dr["Twist_Type_Id"]);
            yArticle.Ply_Id                = Convert.ToInt32(dr["Ply_Id"]);
            yArticle.Yarn_Type_Id          = Convert.ToInt32(dr["Yarn_Type_Id"]);
            yArticle.Shade_Id              = Convert.ToInt32(dr["Shade_Id"]);
            yArticle.Filaments_Id          = Convert.ToInt32(dr["Filaments_Id"]);
            yArticle.Origin_Id             = Convert.ToInt32(dr["Origin_Id"]);
            yArticle.Shrinkage_Id          = Convert.ToInt32(dr["Shrinkage_Id"]);
            yArticle.Tenasity_Id           = Convert.ToInt32(dr["Tenasity_Id"]);
            yArticle.Chemical_Treatment_Id = Convert.ToInt32(dr["Chemical_Treatment_Id"]);
            yArticle.Colour_Id             = Convert.ToInt32(dr["Colour_Id"]);
            yArticle.Supplier_Id           = Convert.ToInt32(dr["Supplier_Id"]);
            yArticle.Full_Code             = Convert.ToString(dr["Full_Code"]);
            yArticle.Given_By_Id           = Convert.ToInt32(dr["Given_By_Id"]);
            yArticle.Validated_By_Id       = Convert.ToInt32(dr["Validated_By_Id"]);
            yArticle.Developed_Under_Id    = Convert.ToInt32(dr["Developed_Under_Id"]);
            yArticle.Lead_Time_To_Purchase = Convert.ToString(dr["Lead_Time_To_Purchase"]);
            yArticle.Work_Center_Id        = Convert.ToInt32(dr["Work_Center_Id"]);
            yArticle.Is_Active             = Convert.ToBoolean(dr["Is_Active"]);
            yArticle.CreatedBy             = Convert.ToInt32(dr["CreatedBy"]);
            yArticle.CreatedOn             = Convert.ToDateTime(dr["CreatedOn"]);
            yArticle.UpdatedBy             = Convert.ToInt32(dr["UpdatedBy"]);
            yArticle.UpdatedOn             = Convert.ToDateTime(dr["UpdatedOn"]);


            yArticle.Denier_Name             = Convert.ToString(dr["Denier_Name"]);
            yArticle.Twist_Mingle_Name       = Convert.ToString(dr["Twist_Mingle_Name"]);
            yArticle.Twist_Type_Name         = Convert.ToString(dr["Twist_Type_Name"]);
            yArticle.Ply_Name                = Convert.ToString(dr["Ply_Name"]);
            yArticle.Yarn_Type_Name          = Convert.ToString(dr["Yarn_Type_Name"]);
            yArticle.Shade_Name              = Convert.ToString(dr["Shade_Name"]);
            yArticle.Filaments_Name          = Convert.ToString(dr["Filaments_Name"]);
            yArticle.Shrinkage_Name          = Convert.ToString(dr["Shrinkage_Name"]);
            yArticle.Tenasity_Name           = Convert.ToString(dr["Tenasity_Name"]);
            yArticle.Chemical_Treatment_Name = Convert.ToString(dr["Chemical_Treatment_Name"]);
            yArticle.Colour_Name             = Convert.ToString(dr["Colour_Name"]);
            yArticle.Supplier_Name           = Convert.ToString(dr["Supplier_Name"]);
            yArticle.Origin_Name             = Convert.ToString(dr["Origin_Name"]);


            yArticle.Developed_Under_Name = Convert.ToString(dr["Developed_Under_Name"]);
            yArticle.Validated_By_Name    = Convert.ToString(dr["Validated_By_Name"]);
            yArticle.Given_By_Name        = Convert.ToString(dr["Given_By_Name"]);
            yArticle.Work_Center_Code     = Convert.ToString(dr["Work_Center_Code"]);
            //
            yArticle.Denier_Code             = Convert.ToString(dr["Denier_Code"]);
            yArticle.Twist_Mingle_Code       = Convert.ToString(dr["Twist_Mingle_Code"]);
            yArticle.Twist_Type_Code         = Convert.ToString(dr["Twist_Type_Code"]);
            yArticle.Ply_Code                = Convert.ToString(dr["Ply_Code"]);
            yArticle.Yarn_Type_Code          = Convert.ToString(dr["Yarn_Type_Code"]);
            yArticle.Shade_Code              = Convert.ToString(dr["Shade_Code"]);
            yArticle.Filaments_Code          = Convert.ToString(dr["Filaments_Code"]);
            yArticle.Shrinkage_Code          = Convert.ToString(dr["Shrinkage_Code"]);
            yArticle.Tenasity_Code           = Convert.ToString(dr["Tenasity_Code"]);
            yArticle.Chemical_Treatment_Code = Convert.ToString(dr["Chemical_Treatment_Code"]);
            yArticle.Colour_Code             = Convert.ToString(dr["Colour_Code"]);
            yArticle.Supplier_Code           = Convert.ToString(dr["Supplier_Code"]);
            yArticle.Origin_Code             = Convert.ToString(dr["Origin_Code"]);

            return(yArticle);
        }