public static void UpdateWOVEN(Sale_B_WOVEN _Sale_B_WOVEN, int SaleId, string User) { DbCommand command = Catalog_Access.CreateCommand(); command.CommandText = "sp_UpdateSale_B_WOVEN"; DbParameter param; param = command.CreateParameter(); param.ParameterName = "@Id"; param.Value = _Sale_B_WOVEN.Id; param.DbType = DbType.Int32; command.Parameters.Add(param); param = command.CreateParameter(); param.ParameterName = "@SaleId"; param.Value = SaleId; param.DbType = DbType.Int32; command.Parameters.Add(param); param = command.CreateParameter(); param.ParameterName = "@REGION"; param.Value = _Sale_B_WOVEN.REGION; param.DbType = DbType.String; command.Parameters.Add(param); param = command.CreateParameter(); param.ParameterName = "@WARP"; param.Value = _Sale_B_WOVEN.WARP; param.DbType = DbType.Decimal; command.Parameters.Add(param); param = command.CreateParameter(); param.ParameterName = "@YARN1"; param.Value = _Sale_B_WOVEN.YARN1; param.DbType = DbType.Int32; command.Parameters.Add(param); param = command.CreateParameter(); param.ParameterName = "@YARNHD1"; param.Value = _Sale_B_WOVEN.YARNHD1; param.DbType = DbType.Int32; command.Parameters.Add(param); param = command.CreateParameter(); param.ParameterName = "@COMP1"; param.Value = _Sale_B_WOVEN.COMP1; param.DbType = DbType.Int32; command.Parameters.Add(param); param = command.CreateParameter(); param.ParameterName = "@BRAND1"; param.Value = _Sale_B_WOVEN.BRAND1; param.DbType = DbType.Int32; command.Parameters.Add(param); param = command.CreateParameter(); param.ParameterName = "@RATE1"; param.Value = _Sale_B_WOVEN.RATE1; param.DbType = DbType.Decimal; command.Parameters.Add(param); param = command.CreateParameter(); param.ParameterName = "@CONSMP1"; param.Value = _Sale_B_WOVEN.CONSMP1; param.DbType = DbType.Decimal; command.Parameters.Add(param); param = command.CreateParameter(); param.ParameterName = "@UNIT1"; param.Value = _Sale_B_WOVEN.UNIT1; param.DbType = DbType.Int32; command.Parameters.Add(param); param = command.CreateParameter(); param.ParameterName = "@WIDTH"; param.Value = _Sale_B_WOVEN.WIDTH; param.DbType = DbType.Decimal; command.Parameters.Add(param); param = command.CreateParameter(); param.ParameterName = "@WEFT"; param.Value = _Sale_B_WOVEN.WEFT; param.DbType = DbType.Decimal; command.Parameters.Add(param); param = command.CreateParameter(); param.ParameterName = "@YARN2"; param.Value = _Sale_B_WOVEN.YARN2; param.DbType = DbType.Int32; command.Parameters.Add(param); param = command.CreateParameter(); param.ParameterName = "@YARNHD2"; param.Value = _Sale_B_WOVEN.YARNHD2; param.DbType = DbType.Int32; command.Parameters.Add(param); param = command.CreateParameter(); param.ParameterName = "@COMP2"; param.Value = _Sale_B_WOVEN.COMP2; param.DbType = DbType.Int32; command.Parameters.Add(param); param = command.CreateParameter(); param.ParameterName = "@BRAND2"; param.Value = _Sale_B_WOVEN.BRAND2; param.DbType = DbType.Int32; command.Parameters.Add(param); param = command.CreateParameter(); param.ParameterName = "@RATE2"; param.Value = _Sale_B_WOVEN.RATE2; param.DbType = DbType.Decimal; command.Parameters.Add(param); param = command.CreateParameter(); param.ParameterName = "@CONSMP2"; param.Value = _Sale_B_WOVEN.CONSMP2; param.DbType = DbType.Decimal; command.Parameters.Add(param); param = command.CreateParameter(); param.ParameterName = "@UNIT2"; param.Value = _Sale_B_WOVEN.UNIT2; param.DbType = DbType.Int32; command.Parameters.Add(param); param = command.CreateParameter(); param.ParameterName = "@UpdatedBy"; param.Value = User; param.DbType = DbType.String; command.Parameters.Add(param); Catalog_Access.ExecuteNonQuery(command); }
public List<Sale_B_WOVEN> GetWOVEN(int SaleId) { List<Sale_B_WOVEN> list_Sale_B_WOVEN = new List<Sale_B_WOVEN>(); DataTable dt = Sale_DA.GetWOVEN(SaleId); foreach (DataRow row in dt.Rows) { Sale_B_WOVEN _Sale_B_WOVEN = new Sale_B_WOVEN(); _Sale_B_WOVEN.Id = int.Parse(row["Id"].ToString()); _Sale_B_WOVEN.REGION = row["REGION"].ToString(); if (row["WARP"].ToString() != "") _Sale_B_WOVEN.WARP = float.Parse(row["WARP"].ToString()); if (row["YARN1"].ToString() != "") _Sale_B_WOVEN.YARN1 = int.Parse(row["YARN1"].ToString()); if (row["YARNHD1"].ToString() != "") _Sale_B_WOVEN.YARNHD1 = int.Parse(row["YARNHD1"].ToString()); if (row["COMP1"].ToString() != "") _Sale_B_WOVEN.COMP1 = int.Parse(row["COMP1"].ToString()); if (row["BRAND1"].ToString() != "") _Sale_B_WOVEN.BRAND1 = int.Parse(row["BRAND1"].ToString()); if (row["RATE1"].ToString() != "") _Sale_B_WOVEN.RATE1 = float.Parse(row["RATE1"].ToString()); if (row["CONSMP1"].ToString() != "") _Sale_B_WOVEN.CONSMP1 = float.Parse(row["CONSMP1"].ToString()); if (row["UNIT1"].ToString() != "") _Sale_B_WOVEN.UNIT1 = int.Parse(row["UNIT1"].ToString()); if (row["WIDTH"].ToString() != "") _Sale_B_WOVEN.WIDTH = float.Parse(row["WIDTH"].ToString()); if (row["WEFT"].ToString() != "") _Sale_B_WOVEN.WEFT = float.Parse(row["WEFT"].ToString()); if (row["YARN2"].ToString() != "") _Sale_B_WOVEN.YARN2 = int.Parse(row["YARN2"].ToString()); if (row["YARNHD2"].ToString() != "") _Sale_B_WOVEN.YARNHD2 = int.Parse(row["YARNHD2"].ToString()); if (row["COMP2"].ToString() != "") _Sale_B_WOVEN.COMP2 = int.Parse(row["COMP2"].ToString()); if (row["BRAND2"].ToString() != "") _Sale_B_WOVEN.BRAND2 = int.Parse(row["BRAND2"].ToString()); if (row["RATE2"].ToString() != "") _Sale_B_WOVEN.RATE2 = float.Parse(row["RATE2"].ToString()); if (row["CONSMP2"].ToString() != "") _Sale_B_WOVEN.CONSMP2 = float.Parse(row["CONSMP2"].ToString()); if (row["UNIT2"].ToString() != "") _Sale_B_WOVEN.UNIT2 = int.Parse(row["UNIT2"].ToString()); list_Sale_B_WOVEN.Add(_Sale_B_WOVEN); } return list_Sale_B_WOVEN; }