3 - tire code for Save
variable Declarations
ClsBEPurDetails be = new ClsBEPurDetails();
clsBEPurEntryStockUpdate beStock = new clsBEPurEntryStockUpdate();
clsDAPurEntry da = new clsDAPurEntry();
rc = dgvPurchase.Rows.Count - 1;
be.PurNo = cbxID.Text;
be.SupName = cbxSupName.Text;
for (int i = 0; i < rc; i++)
{
be.PurNo = cbxID.Text;
be.SlNo = dgvPurchase[0, i].Value.ToString();
be.PrType = dgvPurchase[1, i].Value.ToString();
be.ItemName = dgvPurchase[2, i].Value.ToString();
be.BatchNo = dgvPurchase[3, i].Value.ToString();
be.ExpDte = dgvPurchase[4, i].Value.ToString();
be.Nounit = dgvPurchase[5, i].Value.ToString();
be.TotUnit = dgvPurchase[6, i].Value.ToString();
be.FreeQty = dgvPurchase[7, i].Value.ToString();
be.NetQty = dgvPurchase[8, i].Value.ToString();
be.Mrp = dgvPurchase[9, i].Value.ToString();
be.DiscPers = dgvPurchase[10, i].Value.ToString();
be.Discamt = dgvPurchase[11, i].Value.ToString();
be.BasicRate = dgvPurchase[12, i].Value.ToString();
be.VatPers = dgvPurchase[13, i].Value.ToString();
be.VatAmt = dgvPurchase[14, i].Value.ToString();
be.TransPers = dgvPurchase[15, i].Value.ToString();
be.Netcost = dgvPurchase[16, i].Value.ToString();
be.SellingPers = dgvPurchase[17, i].Value.ToString();
be.SellingMargin = dgvPurchase[18, i].Value.ToString();
be.SellingAmt = dgvPurchase[19, i].Value.ToString();
be.DummyRate = dgvPurchase[20, i].Value.ToString();
be.MrpValue = dgvPurchase[21, i].Value.ToString();
be.WpValue = dgvPurchase[22, i].Value.ToString();
be.Maxqty = dgvPurchase[23, i].Value.ToString();
be.Minqty = dgvPurchase[24, i].Value.ToString();
be.Units = dgvPurchase[25, i].Value.ToString();
be.Tstrength = dgvPurchase[26, i].Value.ToString();
be.AgsSubNetTot = dgvPurchase[27, i].Value.ToString();
be.ClaimAmount = dgvPurchase[28, i].Value.ToString();
BAL CODE:
using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
namespace BusinessEntities
{
public class ClsBEPurDetails
{
private string _purNo;
private string _supName;
private string _SlNo;
private string _prType;
private string _itemName;
private string _batchNo;
private string _expDte;
private string _nounit;
private string _totUnit;
private string _freeQty;
private string _netQty;
private string _mrp;
private string _discPers;
private string _discamt;
private string _basicRate;
private string _VatPers;
private string _vatAmt;
private string _TransPers;
private string _netcost;
private string _sellingPers;
private string _sellingMargin;
private string _sellingAmt;
private string _dummyRate;
private string _mrpValue;
private string _wpValue;
private string _Tstrength;
private string _Units;
private string _maxqty;
private string _minqty;
private string _entryDate;
private string _bV;
private string _agsSubNetTot;
private string _claimAmount;
public string ClaimAmount
{
get { return _claimAmount; }
set { _claimAmount = value; }
}
public string AgsSubNetTot
{
get { return _agsSubNetTot; }
set { _agsSubNetTot = value; }
}
public string BV
{
get { return _bV; }
set { _bV = value; }
}
public string PurNo
{
get { return _purNo; }
set { _purNo = value; }
}
public string SupName
{
get { return _supName; }
set { _supName = value; }
}
public string SlNo
{
get { return _SlNo; }
set { _SlNo = value; }
}
public string PrType
{
get { return _prType; }
set { _prType = value; }
}
public string ItemName
{
get { return _itemName; }
set { _itemName = value; }
}
public string BatchNo
{
get { return _batchNo; }
set { _batchNo = value; }
}
public string ExpDte
{
get { return _expDte; }
set { _expDte = value; }
}
public string Nounit
{
get { return _nounit; }
set { _nounit = value; }
}
public string TotUnit
{
get { return _totUnit; }
set { _totUnit = value; }
}
public string FreeQty
{
get { return _freeQty; }
set { _freeQty = value; }
}
public string NetQty
{
get { return _netQty; }
set { _netQty = value; }
}
public string Mrp
{
get { return _mrp; }
set { _mrp = value; }
}
public string DiscPers
{
get { return _discPers; }
set { _discPers = value; }
}
public string Discamt
{
get { return _discamt; }
set { _discamt = value; }
}
public string BasicRate
{
get { return _basicRate; }
set { _basicRate = value; }
}
public string VatPers
{
get { return _VatPers; }
set { _VatPers = value; }
}
public string VatAmt
{
get { return _vatAmt; }
set { _vatAmt = value; }
}
public string TransPers
{
get { return _TransPers; }
set { _TransPers = value; }
}
public string Netcost
{
get { return _netcost; }
set { _netcost = value; }
}
public string SellingPers
{
get { return _sellingPers; }
set { _sellingPers = value; }
}
public string SellingMargin
{
get { return _sellingMargin; }
set { _sellingMargin = value; }
}
public string SellingAmt
{
get { return _sellingAmt; }
set { _sellingAmt = value; }
}
public string DummyRate
{
get { return _dummyRate; }
set { _dummyRate = value; }
}
public string MrpValue
{
get { return _mrpValue; }
set { _mrpValue = value; }
}
public string WpValue
{
get { return _wpValue; }
set { _wpValue = value; }
}
public string Tstrength
{
get { return _Tstrength; }
set { _Tstrength = value; }
}
public string Units
{
get { return _Units; }
set { _Units = value; }
}
public string Maxqty
{
get { return _maxqty; }
set { _maxqty = value; }
}
public string Minqty
{
get { return _minqty; }
set { _minqty = value; }
}
public string EntryDate
{
get { return _entryDate; }
set { _entryDate = value; }
}
}
}
DAL : CODE
public void DAPurDatagridIntoDB(ClsBEPurDetails be)
{
string str = "Insert into T_PurDetails(ID,IDs,SupName,SlNo,Mname,ItemName,BatchNo,ExpDate,ItemsPbox,TotalBox,FreeQty,NetQty,MRP,DiscPers,DiscAmt,Basicrate,VatPers,VatAmt,TransPers,Netcost,SellPrice,SellingMargin,SellingAmt,DummyRate,MRPValue,WPValue,MaxQty,MinQty,Units,Strength,AgsSubNet,Claim)values('" + be.PurNo + "','" + be.PurNo + "','" + be.SupName + "','" + be.SlNo + "','" + be.PrType + "','" + be.ItemName + "','" + be.BatchNo + "','" + be.ExpDte + "','" + be.Nounit + "','" + be.TotUnit + "','" + be.FreeQty + "','" + be.NetQty + "','" + be.Mrp + "','" + be.DiscPers + "','" + be.Discamt + "','" + be.BasicRate + "','" + be.VatPers + "','" + be.VatAmt + "','" + be.TransPers + "','" + be.Netcost + "','" + be.SellingPers + "','" + be.SellingMargin + "','" + be.SellingAmt + "','" + be.DummyRate + "','" + be.MrpValue + "','" + be.WpValue + "','" + be.Maxqty + "','" + be.Minqty + "','" + be.Units + "','" + be.Tstrength + "','"+be.AgsSubNetTot +"','"+be.ClaimAmount+"')";
con = new OleDbConnection(dbCon());
OleDbCommand cmd = new OleDbCommand(str, con);
con.Open();
cmd.ExecuteNonQuery();
con.Close();
}
// save
da.DAPurDatagridIntoDB(be);//Purchase item insert
No comments:
Post a Comment