new void Update()
{
try
{
Functions.TBL_Stock stock = DB.TBL_Stocks.First(s => s.ID == StockID);
stock.StockName = txtStockName.Text;
stock.StockPurchasePrice = decimal.Parse(txtPurchasePrice.Text);
stock.StockPurchaseTAX = decimal.Parse(txtPurchaseTAX.Text);
stock.StockBarcode = txtBarcode.Text;
stock.StockUnit = txtboxUnit.Text;
stock.StockGroupID = GroupID;
stock.StockCode = txtStockCode.Text;
if (SelectedPhoto)
{
stock.StockPicture = new System.Data.Linq.Binary(Photos.AddPhoto(pictureBox1.Image));
}
stock.StockSalePrice = decimal.Parse(txtSalePrice.Text);
stock.StockSaleTAX = decimal.Parse(txtSaleTAX.Text);
stock.StockEditDate = DateTime.Now;
stock.StockEditUser = frmMain.UserID;
DB.SubmitChanges();
Messages.Update(true);
Clear();
}
catch (Exception e)
{
Messages.Error(e);
}
}
void NewSave()
{
try
{
Functions.TBL_Stock stock = new Functions.TBL_Stock();
stock.StockName = txtStockName.Text;
stock.StockPurchasePrice = decimal.Parse(txtPurchasePrice.Text);
stock.StockPurchaseTAX = decimal.Parse(txtPurchaseTAX.Text);
stock.StockBarcode = txtBarcode.Text;
stock.StockUnit = txtboxUnit.Text;
stock.StockGroupID = GroupID;
stock.StockCode = txtStockCode.Text;
if (SelectedPhoto)
{
stock.StockPicture = new System.Data.Linq.Binary(Photos.AddPhoto(pictureBox1.Image));
}
stock.StockSalePrice = decimal.Parse(txtSalePrice.Text);
stock.StockSaleTAX = decimal.Parse(txtSaleTAX.Text);
stock.StockSaveDate = DateTime.Now;
stock.StockSaveUser = frmMain.UserID;
DB.TBL_Stocks.InsertOnSubmit(stock);
DB.SubmitChanges();
Messages.NewRecord("Yeni stok kaydı oluşturuldu.");
Clear();
}
catch (Exception e)
{
Messages.Error(e);
}
}
public void Open(int ID)
{
Edit = true;
StockID = ID;
Functions.TBL_Stock stock = DB.TBL_Stocks.First(s => s.ID == StockID);
OpenGroup(stock.StockGroupID.Value);
if (stock.StockPicture != null)
{
pictureBox1.Image = Photos.GetPhoto(stock.StockPicture.ToArray());
}
txtPurchasePrice.Text = stock.StockPurchasePrice.ToString();
txtPurchaseTAX.Text = stock.StockPurchaseTAX.ToString();
txtBarcode.Text = stock.StockBarcode;
txtboxUnit.Text = stock.StockUnit;
txtSalePrice.Text = stock.StockSalePrice.ToString();
txtSaleTAX.Text = stock.StockSaleTAX.ToString();
txtStockName.Text = stock.StockName;
txtStockCode.Text = stock.StockCode;
}
private void btnStockSelect_ButtonClick(object sender, DevExpress.XtraEditors.Controls.ButtonPressedEventArgs e)
{
int StockID = forms.StockList(true);
if (StockID > 0)
{
Functions.TBL_Stock stock = db.TBL_Stocks.First(s => s.ID == StockID);
gridView1.AddNewRow();
gridView1.SetFocusedRowCellValue("Quantity", "0");
gridView1.SetFocusedRowCellValue("Barcode", stock.StockBarcode);
gridView1.SetFocusedRowCellValue("StockCode", stock.StockCode);
gridView1.SetFocusedRowCellValue("StockName", stock.StockName);
gridView1.SetFocusedRowCellValue("Unit", stock.StockUnit);
gridView1.SetFocusedRowCellValue("UnitPrice", stock.StockSalePrice);
gridView1.SetFocusedRowCellValue("TAX", stock.StockSaleTAX);
}
frmMain.Transfer = -1;
}
