private void SaveCollection()
{
DataClasses1DataContext db = new DataClasses1DataContext();
using (var scope = new System.Transactions.TransactionScope())
{
foreach (DataGridViewRow row in dataGridView3.Rows)
{
Edison_DispatchPayment AddItems1 = new Edison_DispatchPayment();
AddItems1.Date = dateTimePicker1.Value;
AddItems1.CustID = Convert.ToInt32(row.Cells[1].Value.ToString() == "" ? "0" : row.Cells[1].Value.ToString());
AddItems1.Amount = Convert.ToDecimal(row.Cells[5].Value.ToString() == "" ? "0" : row.Cells[5].Value.ToString());
AddItems1.DispatchNo = Convert.ToInt32(textBox4.Text);
db.Edison_DispatchPayments.InsertOnSubmit(AddItems1);
db.SubmitChanges();
}
scope.Complete();
}
INV_RevertState();
Inv_DisableAll();
db.Dispose();
form1.RefreshForm();
}
private void Invoice_SaveAll()
{
try
{
DataClasses1DataContext db = new DataClasses1DataContext();
var validation = from s in db.Edison_InvoiceHDRs
where s.DispatchNo.Equals(textBox2.Text) && s.CustID.Equals(InvCustomerList.EditValue)
select s;
if (validation.Any())
{
MessageBox.Show("You cannot Make Another Bill Of the Same Customer, Please Check!!");
return;
}
using (var scope = new System.Transactions.TransactionScope())
{
Edison_InvoiceHDR objCourse = new Edison_InvoiceHDR();
objCourse.Date = InvDate.Value.Date;
objCourse.DispatchNo = Convert.ToInt32(textBox2.Text);
objCourse.CustID = Convert.ToInt32(InvCustomerList.EditValue);
objCourse.TotalAmount = Convert.ToDecimal(txtInvoicingAmount.Text == "" ? "0" : txtInvoicingAmount.Text);
objCourse.DiscountAmount = Convert.ToDecimal(textBox3.Text == "" ? "0" : textBox3.Text);
objCourse.DiscountPercentage = Convert.ToDecimal(textBox4.Text == "" ? "0" : textBox4.Text);
objCourse.NetAmount = Convert.ToDecimal(textBox5.Text == "" ? "0" : textBox5.Text);
objCourse.PrevBalance = Convert.ToDecimal(textBox8.Text == "" ? "0" : textBox8.Text);
objCourse.GrandTotal = Convert.ToDecimal(textBox7.Text == "" ? "0" : textBox7.Text);
db.Edison_InvoiceHDRs.InsertOnSubmit(objCourse);
db.SubmitChanges();
textBox9.Text = objCourse.InvoiceID.ToString();
//dataGridView4.Sort(dataGridView1.Columns[1], ListSortDirection.Ascending);
//this.dataGridView4.Columns[1].HeaderCell.SortGlyphDirection = System.Windows.Forms.SortOrder.Ascending;
int i = 1;
foreach (DataGridViewRow row in dataGridView4.Rows)
{
Edison_InvoiceDTL AddItems = new Edison_InvoiceDTL();
AddItems.PID = Convert.ToInt32(row.Cells[1].Value.ToString() == "" ? "0" : row.Cells[1].Value.ToString());
AddItems.Qty = Convert.ToInt32(row.Cells[3].Value.ToString() == "" ? "0" : row.Cells[3].Value.ToString());
AddItems.Rate = Convert.ToDecimal(row.Cells[4].Value.ToString() == "" ? "0" : row.Cells[4].Value.ToString());
AddItems.TotalAmount = Convert.ToDecimal(row.Cells[5].Value.ToString() == "" ? "0" : row.Cells[5].Value.ToString());
AddItems.DispatchNo = Convert.ToInt32(textBox2.Text);
var getTheSelecteddata = from s in db.Edison_Products
where s.ProductID.Equals(AddItems.PID)
select s;
if (getTheSelecteddata.Any())
{
foreach (var ab in getTheSelecteddata)
{
AddItems.OriginalRetailSaleRate = ab.RSSalePrice;
AddItems.OriginalWholeSaleRate = ab.WSSalePrice;
AddItems.OriginalPurchRate = ab.PurchasePrice;
break;
}
}
else
{
AddItems.OriginalRetailSaleRate = 0;
AddItems.OriginalWholeSaleRate = 0;
AddItems.OriginalPurchRate = 0;
}
AddItems.InvoiceID = Convert.ToInt32(textBox9.Text);
db.Edison_InvoiceDTLs.InsertOnSubmit(AddItems);
db.SubmitChanges();
}
scope.Complete();
INV_RevertState();
Inv_DisableAll();
}
form1.RefreshForm();
}
catch (Exception err)
{
MessageBox.Show("Error on Save " + err);
}
}