public static void InsertLEATHER(Sale_B_LEATHER _Sale_B_LEATHER, int SaleId, string User)
{
DbCommand command = Catalog_Access.CreateCommand();
command.CommandText = "sp_insertSale_B_LEATHER";
DbParameter param;
param = command.CreateParameter();
param.ParameterName = "@SaleId";
param.Value = SaleId;
param.DbType = DbType.Int32;
command.Parameters.Add(param);
param = command.CreateParameter();
param.ParameterName = "@LEATHER";
param.Value = _Sale_B_LEATHER.LEATHER;
param.DbType = DbType.String;
command.Parameters.Add(param);
param = command.CreateParameter();
param.ParameterName = "@CreatedBy";
param.Value = User;
param.DbType = DbType.String;
command.Parameters.Add(param);
Catalog_Access.ExecuteNonQuery(command);
}
public static string Insert(Sale _Sale, Sale_B_KNITTED _Sale_B_KNITTED, List<Sale_B_WOVEN> list_Sale_B_WOVEN, Sale_B_NONWOVEN _Sale_B_NONWOVEN, Sale_B_TERRY _Sale_B_TERRY, Sale_B_KNITWRIST _Sale_B_KNITWRIST, Sale_B_LEATHER _Sale_B_LEATHER)
{
_Sale.ID = InsertSale(_Sale);
if (_Sale.ID > 0)
{
if (_Sale_B_KNITTED != null)
InsertKNITTED(_Sale_B_KNITTED, _Sale.ID, _Sale.CreatedBy);
if (list_Sale_B_WOVEN != null)
foreach (Sale_B_WOVEN _Sale_B_WOVEN in list_Sale_B_WOVEN)
InsertWOVEN(_Sale_B_WOVEN, _Sale.ID, _Sale.CreatedBy);
if (_Sale_B_NONWOVEN != null)
InsertNONWOVEN(_Sale_B_NONWOVEN, _Sale.ID, _Sale.CreatedBy);
if (_Sale_B_TERRY != null)
InsertTERRY(_Sale_B_TERRY, _Sale.ID, _Sale.CreatedBy);
if (_Sale_B_KNITWRIST != null)
InsertKNITWRIST(_Sale_B_KNITWRIST, _Sale.ID, _Sale.CreatedBy);
if (_Sale_B_LEATHER != null)
InsertLEATHER(_Sale_B_LEATHER, _Sale.ID, _Sale.CreatedBy);
return "0";
}
else
{
return "1";
}
}
public string Submit(Sale _Sale, Sale_B_KNITTED _Sale_B_KNITTED, List<Sale_B_WOVEN> list_Sale_B_WOVEN, Sale_B_NONWOVEN _Sale_B_NONWOVEN, Sale_B_TERRY _Sale_B_TERRY, Sale_B_KNITWRIST _Sale_B_KNITWRIST, Sale_B_LEATHER _Sale_B_LEATHER)
{
string msg = "";
if (_Sale.ID == 0)
{
_Sale.CreatedBy = Session["User"].ToString();
msg = Sale_DA.Insert(_Sale, _Sale_B_KNITTED, list_Sale_B_WOVEN, _Sale_B_NONWOVEN, _Sale_B_TERRY, _Sale_B_KNITWRIST, _Sale_B_LEATHER);
}
else
{
_Sale.UpdatedBy = Session["User"].ToString();
msg = Sale_DA.Update(_Sale, _Sale_B_KNITTED, list_Sale_B_WOVEN, _Sale_B_NONWOVEN, _Sale_B_TERRY, _Sale_B_KNITWRIST, _Sale_B_LEATHER);
}
return msg;
}
public static string Update(Sale _Sale, Sale_B_KNITTED _Sale_B_KNITTED, List<Sale_B_WOVEN> list_Sale_B_WOVEN, Sale_B_NONWOVEN _Sale_B_NONWOVEN, Sale_B_TERRY _Sale_B_TERRY, Sale_B_KNITWRIST _Sale_B_KNITWRIST, Sale_B_LEATHER _Sale_B_LEATHER)
{
if (UpdateSale(_Sale) == "4")
{
if (_Sale_B_KNITTED != null)
if (_Sale_B_KNITTED.Id == 0)
InsertKNITTED(_Sale_B_KNITTED, _Sale.ID, _Sale.UpdatedBy);
else
UpdateKNITTED(_Sale_B_KNITTED, _Sale.ID, _Sale.UpdatedBy);
if (list_Sale_B_WOVEN != null)
foreach (Sale_B_WOVEN _Sale_B_WOVEN in list_Sale_B_WOVEN)
{
if (_Sale_B_WOVEN.Id == 0)
InsertWOVEN(_Sale_B_WOVEN, _Sale.ID, _Sale.UpdatedBy);
else
UpdateWOVEN(_Sale_B_WOVEN, _Sale.ID, _Sale.UpdatedBy);
}
if (_Sale_B_NONWOVEN != null)
if (_Sale_B_NONWOVEN.Id == 0)
InsertNONWOVEN(_Sale_B_NONWOVEN, _Sale.ID, _Sale.UpdatedBy);
else
UpdateNONWOVEN(_Sale_B_NONWOVEN, _Sale.ID, _Sale.UpdatedBy);
if (_Sale_B_TERRY != null)
if (_Sale_B_TERRY.Id == 0)
InsertTERRY(_Sale_B_TERRY, _Sale.ID, _Sale.UpdatedBy);
else
UpdateTERRY(_Sale_B_TERRY, _Sale.ID, _Sale.UpdatedBy);
if (_Sale_B_KNITWRIST != null)
if (_Sale_B_KNITWRIST.Id == 0)
InsertKNITWRIST(_Sale_B_KNITWRIST, _Sale.ID, _Sale.UpdatedBy);
else
UpdateKNITWRIST(_Sale_B_KNITWRIST, _Sale.ID, _Sale.UpdatedBy);
if (_Sale_B_LEATHER != null)
if (_Sale_B_LEATHER.Id == 0)
InsertLEATHER(_Sale_B_LEATHER, _Sale.ID, _Sale.UpdatedBy);
else
UpdateLEATHER(_Sale_B_LEATHER, _Sale.ID, _Sale.UpdatedBy);
return "4";
}
else
{
return "1";
}
}
public Sale_B_LEATHER GetLEATHER(int SaleId)
{
Sale_B_LEATHER _Sale_B_LEATHER = null;
DataTable dt = Sale_DA.GetLEATHER(SaleId);
foreach (DataRow row in dt.Rows)
{
_Sale_B_LEATHER = new Sale_B_LEATHER();
_Sale_B_LEATHER.Id = int.Parse(row["Id"].ToString());
_Sale_B_LEATHER.LEATHER = row["LEATHER"].ToString();
}
return _Sale_B_LEATHER;
}
