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