public void SaleInvoice_AddDetail(SaleInvoiceDetail s)
{
Database db = DatabaseFactory.CreateDatabase("ABC");
DbCommand command = db.GetStoredProcCommand("SaleInvoice_AddDetail");
db.AddInParameter(command, "SaleInvoiceCode", DbType.Int32, s.SaleInvoiceCode);
db.AddInParameter(command, "ProductCode", DbType.Int32, s.ProductCode);
db.AddInParameter(command, "Qty", DbType.Int32, s.Qty);
db.AddInParameter(command, "Rate", DbType.Decimal, s.Rate);
db.AddInParameter(command, "Total", DbType.Decimal, s.Total);
db.ExecuteNonQuery(command);
}
protected void DropDownList1_SelectedIndexChanged(object sender, EventArgs e)
{
if (DropDownList1.SelectedValue == "0")
{
this.ShowErrorNotification("Please select proper id");
}
else
{
Load_Data_Grid();
lblCustName.Visible = true;
gridProduct1.Visible = true;
lblTotal1.Visible = true;
txtDiscount1.Visible = true;
txtTax1.Visible = true;
lblNetTotal1.Visible = true;
SaleInvoice repository = new SaleInvoice();
tblSaleInvoice saleInvoice = repository.Get(Convert.ToInt32(DropDownList1.SelectedValue));
Customer c = new Customer();
tblCustomer cust = c.Get(saleInvoice.CustomerId);
lblCustName.Text = cust.Firstname + " " +cust.Lastname;
lblTotal1.Text= saleInvoice.TotalSale.ToString();
txtTax1.Text= saleInvoice.Tax.ToString();
txtDiscount1.Text=saleInvoice.Discount.ToString();
lblNetTotal1.Text=saleInvoice.NetSale.ToString();
SaleInvoiceDetail repo = new SaleInvoiceDetail();
tblSaleInvoiceDetail sid = new tblSaleInvoiceDetail();
IEnumerable<tblSaleInvoiceDetail> enume= repo.GetOnInvoiceId(Convert.ToInt32(saleInvoice.InvoiceId));
var enumer= enume.GetEnumerator();
while (enumer.MoveNext())
{
int rowindex = enumer.Current.ProductId - 1;
CheckBox cb = (CheckBox)gridProduct1.Rows[rowindex].FindControl("chkbox1");
cb.Checked = true;
TextBox txt = (TextBox)gridProduct1.Rows[rowindex].FindControl("txtQuantity");
txt.Visible = true;
txt.Text = enumer.Current.Quantity.ToString();
}
total = Convert.ToDouble(lblTotal1.Text);
}
}
private void btnTransfer_Click(object sender, EventArgs e)
{
try
{
if (hasError)
{
MessageBox.Show("لا يمكن تحويل الأصناف الا بعد معالجة الأخطاء الموجدة");
return;
}
//Validate gird
//for (int i = 0; i < gridView1.RowCount; i++)
//{
// int rowHandle = gridView1.GetVisibleRowHandle(i);
// if (gridView1.IsDataRow(rowHandle))
// {
// gridView1.FocusedRowHandle = rowHandle;
// hasError = gridView1.HasColumnErrors;
// }
//}
if (MessageBox.Show("هل أنت متأكد من إجراء العملية؟", "سيتم تحويل الكميات بالفاتورة", MessageBoxButtons.YesNo, MessageBoxIcon.Question) == System.Windows.Forms.DialogResult.Yes)
{
StringBuilder pushMSG1 = new StringBuilder();
StringBuilder pushMSG2 = new StringBuilder();
StringBuilder pushMSG3 = new StringBuilder();
SaleInvoice invoice1, invoice2, invoice3;
invoice1 = new SaleInvoice();
invoice1.BranchID = 0;//المخزن
invoice1.Date = DateTime.Now;
invoice1.Discount = 0;
invoice1.Flag = 0;
invoice1.Remarks = "Transfer";
invoice1.Total = 0;
invoice1.UserID = Convert.ToInt32(UserData.Default.UserID);
db.SaleInvoices.Add(invoice1);
invoice2 = new SaleInvoice();
invoice2.BranchID = 0;//المخزن
invoice2.Date = DateTime.Now;
invoice2.Discount = 0;
invoice2.Flag = 0;
invoice2.Remarks = "Transfer";
invoice2.Total = 0;
invoice2.UserID = Convert.ToInt32(UserData.Default.UserID);
db.SaleInvoices.Add(invoice2);
invoice3 = new SaleInvoice();
invoice3.BranchID = 0;//المخزن
invoice3.Date = DateTime.Now;
invoice3.Discount = 0;
invoice3.Flag = 0;
invoice3.Remarks = "Transfer";
invoice3.Total = 0;
invoice3.UserID = Convert.ToInt32(UserData.Default.UserID);
db.SaleInvoices.Add(invoice3);
SaleInvoiceDetail detail1;
SaleInvoiceDetail detail2;
SaleInvoiceDetail detail3;
// PurchaseInvoice purchaseInvoice1 = new PurchaseInvoice();
DataAccess.PurchaseInvoice purchaseInvoice1 = db.PurchaseInvoices.Create();
purchaseInvoice1.BranchID = 1;
purchaseInvoice1.Date = DateTime.Now;
purchaseInvoice1.Discount = 0;
purchaseInvoice1.Flag = 0;
purchaseInvoice1.Number = "Transfer Reda1" + purchaseInvoice.ID;
purchaseInvoice1.Total = 0;
purchaseInvoice1.UserID = Convert.ToInt32(UserData.Default.UserID);
db.PurchaseInvoices.Add(purchaseInvoice1);
//PurchaseInvoice purchaseInvoice2 = new PurchaseInvoice();
DataAccess.PurchaseInvoice purchaseInvoice2 = db.PurchaseInvoices.Create();
purchaseInvoice2.BranchID = 2;
purchaseInvoice2.Date = DateTime.Now;
purchaseInvoice2.Discount = 0;
purchaseInvoice2.Flag = 0;
purchaseInvoice2.Number = "Transfer Reda2" + purchaseInvoice.ID;
purchaseInvoice2.Total = 0;
purchaseInvoice2.UserID = Convert.ToInt32(UserData.Default.UserID);
db.PurchaseInvoices.Add(purchaseInvoice2);
DataAccess.PurchaseInvoice purchaseInvoice3 = db.PurchaseInvoices.Create();
purchaseInvoice3.BranchID = 3;
purchaseInvoice3.Date = DateTime.Now;
purchaseInvoice3.Discount = 0;
purchaseInvoice3.Flag = 0;
purchaseInvoice3.Number = "Transfer Reda2" + purchaseInvoice.ID;
purchaseInvoice3.Total = 0;
purchaseInvoice3.UserID = Convert.ToInt32(UserData.Default.UserID);
db.PurchaseInvoices.Add(purchaseInvoice3);
PurchaseInvoiceDetail purchaseInvoiceDetail1;
PurchaseInvoiceDetail purchaseInvoiceDetail2;
PurchaseInvoiceDetail purchaseInvoiceDetail3;
foreach (var row in DT.Rows)
{
detail1 = new SaleInvoiceDetail();
detail2 = new SaleInvoiceDetail();
detail3 = new SaleInvoiceDetail();
DataAccess.DamegeDS.DamegeDTRow currentRow = (DataAccess.DamegeDS.DamegeDTRow)row;
detail1.InventoryID = Convert.ToInt32(currentRow.ID);
detail1.ItemID = Convert.ToInt32(currentRow.ItemID);
detail1.PurchaseQuantity = Convert.ToInt32(currentRow.Quantity);
detail1.Quanitity = Convert.ToInt32(currentRow.Reda1);
detail1.Remarks = "Transfer from purchase invoice id: " + purchaseInvoice.ID;
detail1.SaleInvoiceID = invoice1.ID;
detail1.UnitPrice = Convert.ToDecimal(currentRow.PurchasePrice);
pushMSG1.Append(currentRow.Name + " " + currentRow.Reda1).Append(Environment.NewLine);
invoice1.SaleInvoiceDetails.Add(detail1);
detail2.InventoryID = Convert.ToInt32(currentRow.ID);
detail2.ItemID = Convert.ToInt32(currentRow.ItemID);
detail2.PurchaseQuantity = Convert.ToInt32(currentRow.Quantity);
detail2.Quanitity = Convert.ToInt32(currentRow.Reda2);
detail2.Remarks = "Transfer from purchase invoice id: " + purchaseInvoice.ID;
detail2.SaleInvoiceID = invoice1.ID;
detail2.UnitPrice = Convert.ToDecimal(currentRow.PurchasePrice);
pushMSG2.Append(currentRow.Name + " " + currentRow.Reda2).Append(Environment.NewLine);
invoice2.SaleInvoiceDetails.Add(detail2);
detail3.InventoryID = Convert.ToInt32(currentRow.ID);
detail3.ItemID = Convert.ToInt32(currentRow.ItemID);
detail3.PurchaseQuantity = Convert.ToInt32(currentRow.Quantity);
detail3.Quanitity = Convert.ToInt32(currentRow.Reda3);
detail3.Remarks = "Transfer from purchase invoice id: " + purchaseInvoice.ID;
detail3.SaleInvoiceID = invoice1.ID;
detail3.UnitPrice = Convert.ToDecimal(currentRow.PurchasePrice);
pushMSG3.Append(currentRow.Name + " " + currentRow.Reda2).Append(Environment.NewLine);
invoice3.SaleInvoiceDetails.Add(detail3);
//Purchase details 1
purchaseInvoiceDetail1 = db.PurchaseInvoiceDetails.Create(); //new PurchaseInvoiceDetail();
purchaseInvoiceDetail1.DiscountPrice = 0;
purchaseInvoiceDetail1.ItemID = Convert.ToInt32(currentRow.ItemID);
//purchaseInvoiceDetail1.PurchaseInvoiceID = purchaseInvoice1.ID;
purchaseInvoiceDetail1.PurchasePrice = Convert.ToDecimal(currentRow.PurchasePrice);
purchaseInvoiceDetail1.Quantity = Convert.ToInt32(currentRow.Reda1);
purchaseInvoiceDetail1.Remarks = "Transfer from purchase invoice id: " + purchaseInvoice.ID;
purchaseInvoiceDetail1.SalePrice = 0;
purchaseInvoice1.PurchaseInvoiceDetails.Add(purchaseInvoiceDetail1);
//Purchase details 2
purchaseInvoiceDetail2 = db.PurchaseInvoiceDetails.Create(); //new PurchaseInvoiceDetail();
purchaseInvoiceDetail2.DiscountPrice = 0;
purchaseInvoiceDetail2.ItemID = Convert.ToInt32(currentRow.ItemID);
//purchaseInvoiceDetail2.PurchaseInvoiceID = purchaseInvoice1.ID;
purchaseInvoiceDetail2.PurchasePrice = Convert.ToDecimal(currentRow.PurchasePrice);
purchaseInvoiceDetail2.Quantity = Convert.ToInt32(currentRow.Reda2);
purchaseInvoiceDetail2.Remarks = "Transfer from purchase invoice id: " + purchaseInvoice.ID;
purchaseInvoiceDetail2.SalePrice = 0;
purchaseInvoice2.PurchaseInvoiceDetails.Add(purchaseInvoiceDetail2);
//Purchase details 3
purchaseInvoiceDetail3 = db.PurchaseInvoiceDetails.Create(); //new PurchaseInvoiceDetail();
purchaseInvoiceDetail3.DiscountPrice = 0;
purchaseInvoiceDetail3.ItemID = Convert.ToInt32(currentRow.ItemID);
//purchaseInvoiceDetail2.PurchaseInvoiceID = purchaseInvoice1.ID;
purchaseInvoiceDetail3.PurchasePrice = Convert.ToDecimal(currentRow.PurchasePrice);
purchaseInvoiceDetail3.Quantity = Convert.ToInt32(currentRow.Reda3);
purchaseInvoiceDetail3.Remarks = "Transfer from purchase invoice id: " + purchaseInvoice.ID;
purchaseInvoiceDetail3.SalePrice = 0;
purchaseInvoice3.PurchaseInvoiceDetails.Add(purchaseInvoiceDetail3);
}
if (db.SaveChanges() > 0)
{
invoice1.Flag = 1;
invoice2.Flag = 1;
invoice3.Flag = 1;
purchaseInvoice1.Flag = 1;
purchaseInvoice2.Flag = 1;
purchaseInvoice3.Flag = 1;
if (db.SaveChanges() > 0)
{
PushMessage.SendTransferItems("رضا1" + Environment.NewLine + pushMSG1.ToString());
Thread.Sleep(3000);
PushMessage.SendTransferItems("رضا2" + Environment.NewLine + pushMSG2.ToString());
Thread.Sleep(3000);
PushMessage.SendTransferItems("رضا3" + Environment.NewLine + pushMSG3.ToString());
MessageBox.Show("تم التحويل بنجاح");
}
this.Close();
}
else
{
MessageBox.Show("لم يتم التحويل");
}
}
}
catch (Exception ex)
{
ModuleClass.ShowExceptionMessage(this, ex, "خطأ", null);
}
}
