private void btnRemove_Click(object sender, RoutedEventArgs e)
{
IsRemove = true;
string rackNumber = "";
int cartonNumber = 0;
rackNumber = txtRackNumber.Text.ToUpper().ToString();
Int32.TryParse(txtCartonNumber.Text.ToString(), out cartonNumber);
if (String.IsNullOrEmpty(rackNumber))
{
txtRackNumber.SelectAll();
txtRackNumber.Focus();
return;
}
if (cartonNumber == 0)
{
txtCartonNumber.SelectAll();
txtCartonNumber.Focus();
return;
}
rackModel = new OutsoleMaterialRackPositionModel()
{
ProductNo = productNo,
OutsoleSupplierId = supplier.OutsoleSupplierId,
RackNumber = rackNumber,
CartonNumber = cartonNumber
};
this.Close();
}
public static bool Delete(OutsoleMaterialRackPositionModel model)
{
var @ProductNo = new SqlParameter("@ProductNo", model.ProductNo);
var @OutsoleSupplierId = new SqlParameter("@OutsoleSupplierId", model.OutsoleSupplierId);
var @RackNumber = new SqlParameter("@RackNumber", model.RackNumber);
var @CartonNumber = new SqlParameter("@CartonNumber", model.CartonNumber);
if (db.ExecuteStoreCommand("EXEC spm_DeleteOutsoleMaterialRackPosition @ProductNo, @OutsoleSupplierId, @RackNumber, @CartonNumber", @ProductNo, @OutsoleSupplierId, @RackNumber, @CartonNumber) >= 1)
{
return(true);
}
return(false);
}
public static bool Insert(OutsoleMaterialRackPositionModel model)
{
var @ProductNo = new SqlParameter("@ProductNo", model.ProductNo);
var @OutsoleSupplierId = new SqlParameter("@OutsoleSupplierId", model.OutsoleSupplierId);
var @RackNumber = new SqlParameter("@RackNumber", model.RackNumber);
var @CartonNumber = new SqlParameter("@CartonNumber", model.CartonNumber);
var @SizeNo = new SqlParameter("@SizeNo", model.SizeNo);
var @Pairs = new SqlParameter("@Pairs", model.Pairs);
if (db.ExecuteStoreCommand("EXEC spm_InsertOutsoleMaterialRackPosition_3 @ProductNo, @OutsoleSupplierId, @RackNumber, @CartonNumber,@SizeNo,@Pairs", @ProductNo, @OutsoleSupplierId, @RackNumber, @CartonNumber, @SizeNo, @Pairs) >= 1)
{
return(true);
}
return(false);
//var pairs = model.Pairs > 0 ? model.Pairs : 0;
}
private void GetDataFromDatagrid(string rackNumber, int cartonNumber)
{
rackPositionCurrentList.Clear();
// Get quantity and sizeno from datagrid.
try {
DataTable dt = ((DataView)dgSizeNoAndQuantity.ItemsSource).ToTable();
foreach (DataRow dr in dt.Rows)
{
for (int i = 0; i < sizeNoList.Count(); i++)
{
string sizeNo = sizeNoList[i].ToString();
int quantity = 0;
Int32.TryParse(dr[String.Format("Column{0}", i)].ToString(), out quantity);
int rackPositionId = 0;
if (actionType == ActionType.UPDATE)
{
rackPositionId = rackUpdateList.FirstOrDefault(w => w.SizeNo == sizeNo).RackPositionID;
}
var rackModel = new OutsoleMaterialRackPositionModel()
{
RackPositionID = rackPositionId,
ProductNo = productNo,
OutsoleSupplierId = supplier.OutsoleSupplierId,
RackNumber = rackNumber,
CartonNumber = cartonNumber,
SizeNo = sizeNo,
Pairs = quantity,
//Quantity = quantity.ToString(),
};
rackPositionCurrentList.Add(rackModel);
}
}
}
catch (Exception e)
{
MessageBox.Show(e.ToString(), "Master Schedule", MessageBoxButton.OK, MessageBoxImage.Error);
}
}
