public DsPurchase.PODETAILDataTable GetPoDetailById(string pono)
{
var ta = new PODETAILTableAdapter { Connection = { ConnectionString = _constr } };
var ds = new DsPurchase().PODETAIL;
ta.FillBy(ds,pono);
return ds;
}
public DsPurchase.POMAINDataTable GetPoMastById(string pono)
{
var ta = new POMAINTableAdapter { Connection = { ConnectionString = _constr } };
var ds = new DsPurchase().POMAIN;
ta.FillBy(ds,pono);
return ds;
}
public DsPurchase.RETURNDETAILDataTable GetPurRetInvDetailsById(string pkid)
{
var ta = new RETURNDETAILTableAdapter {Connection = {ConnectionString = _constr}};
var ds = new DsPurchase().RETURNDETAIL;
ta.FillByRetid(ds, pkid);
return ds;
}
public DsPurchase.RETURNMASTDataTable GetPurRetInvMainById(string pkid)
{
var ta = new RETURNMASTTableAdapter {Connection = {ConnectionString = _constr}};
var ds = new DsPurchase().RETURNMAST;
ta.FillByRetid(ds, pkid);
return ds;
}
public string DoSave(DsPurchase.RETURNMASTRow drow, DsPurchase.RETURNDETAILDataTable returndetail)
{
var dm = new DataManager();
string retval;
SqlTransaction tran = null;
var isnew = false;
try
{
var cn = new SqlConnection(_constr);
cn.Open();
tran = cn.BeginTransaction(IsolationLevel.ReadUncommitted);
var ds = new DsPurchase();
var dsStock = new DsInventory();
var dt = ds.RETURNMAST;
var taPurMain = new RETURNMASTTableAdapter {Connection = {ConnectionString = _constr}};
var taPurDetail = new RETURNDETAILTableAdapter();
var taStockMaster = new STOCKMASTERTableAdapter {Connection = {ConnectionString = _constr}};
var taapar = new LedgersTableAdapters.APARMAINTableAdapter();
var taledger = new LedgersTableAdapters.LEDGERSTableAdapter();
taStockMaster.Fill(dsStock.STOCKMASTER);
taPurMain.Fill(ds.RETURNMAST);
// Assaign Transaction
taPurMain.AssignConnection(cn, tran);
taPurDetail.AssignConnection(cn, tran);
taStockMaster.AssignConnection(cn, tran);
taapar.AssignConnection(cn, tran);
taledger.AssignConnection(cn, tran);
var dr = dt.FindByRETURNID(drow.RETURNID);
if (dr != null)
{ dr.BeginEdit(); }
else
{ dr = (DsPurchase.RETURNMASTRow)dt.NewRow(); }
if (string.IsNullOrEmpty(drow.RETURNID))
{
var autoid = dm.GetAutoId(2);
autoid++;
Utils.Retinvid = dm.CreateFormatedAutoNo(autoid);
dr.RETURNID = Utils.Retinvid;
dr.USERID = Utils.Userid;
dr.COMPANY = Utils.Company;
dr.TRANDATE = System.DateTime.Now;
isnew = true;
}
else
{
Utils.Retinvid = drow.RETURNID;
dr.EDATE = DateTime.Now;
dr.EUSERID = Utils.Userid;
}
dr.SUPID = drow.SUPID;
dr.SUPNAME = drow.SUPNAME;
dr.INVDATE = drow.INVDATE;
dr.INVNO = drow.INVNO;
dr.SPDISCOUNT = drow.SPDISCOUNT;
dr.WHID = drow.WHID;
dr.ADJVALUE = drow.ADJVALUE;
dr.NETVALUE = drow.NETVALUE;
dr.HOLD = drow.HOLD;
if (isnew)
{
dt.Rows.Add(dr);
taPurMain.Update(dt);
}
else
{
dr.EndEdit();
taPurMain.Update(dr);
}
foreach (DataRow purd in returndetail.Rows)
{
if ((purd.RowState != DataRowState.Deleted))
purd["RETURNID"] = Utils.Retinvid;
}
taPurDetail.Update(returndetail);
//STOCK
if (!dr.HOLD)
{
// Masters.StockMaster.UpdateQtyInStockDataSet(ref dsStock, returndetail, true);
// taStockMaster.Update(dsStock.STOCKMASTER);
Masters.StockMaster.UpdateQtyInStockDataSet(ref cn,ref tran, returndetail, true);
//LEDGER
taapar.Insert("S", dr.SUPID, DateTime.Now.Date, dr.INVDATE, Utils.Retinvid, dr.INVNO, -dr.NETVALUE, 0, -dr.NETVALUE, Utils.Company, 2, Utils.Userid, 0);
taledger.Insert("S", dr.SUPID, DateTime.Now.Date, dr.INVDATE, Utils.Retinvid, dr.INVNO, dr.NETVALUE,0, 2, Utils.Company, Utils.Userid, "Purchase Retun");
}
dm.UpdateAutoNum(2);
tran.Commit();
retval = "1";
}
catch (Exception ex)
{
if (tran != null)
tran.Rollback();
if (isnew)
Utils.Retinvid = string.Empty;
retval = ex.ToString();
}
return retval;
}
public void GeneratePOFrmPR(DsPurchase.PURCHASEREQUESTDataTable dt)
{
// LookupSupplier.EditValue = supno;
foreach (DataRow dr in dt.Rows)
{
if (dr["INORDER"].ToString() == bool.TrueString)
{
LookupSupplier.EditValue = dr["SUPPLIERNO"].ToString();
var blf = new BlItemMaster().FindItemByBarCode(dr["ITEMNO"].ToString());
foreach (DataRow drt in blf.Rows)
{
AddItemsToList("True", drt, int.Parse(dr["QTY"].ToString()));
}
}
}
ShowDialog();
}
public DsPurchase.PURCHASEREQUESTDataTable GetPurchaseRequestList(string company=null,bool inpo=false)
{
var ds = new DsPurchase().PURCHASEREQUEST;
var ta = new PURCHASEREQUESTTableAdapter { Connection = { ConnectionString = _constr } };
if (!inpo)
{
if (company == null)
{
ta.Fill(ds);
}
else
{
ta.FillByComp(ds, company);
}
}
if (inpo)
ta.FillByNotInPO(ds);
return ds;
}
public string DoSave()
{
string retval = "0";
SqlTransaction tran = null;
try
{
var cn = new SqlConnection(_constr);
cn.Open();
tran = cn.BeginTransaction(IsolationLevel.ReadUncommitted);
var ds = new DsPurchase();
var dt = ds.PURCHASEREQUEST;
var taPurMain = new PURCHASEREQUESTTableAdapter();
taPurMain.Connection.ConnectionString = _constr;
taPurMain.Fill(dt);
taPurMain.AssignConnection(cn,tran);
taPurMain.Update(Purchaserequest);
tran.Commit();
retval = "1";
}
catch (Exception ex)
{
if (tran != null)
tran.Rollback();
retval = ex.ToString();
}
return retval;
}
public DsPurchase.PurchaseAnalyseDataTable GetItemAnalyse(string itemno)
{
var ta = new PurchaseAnalyseTableAdapter {Connection = {ConnectionString = _constr}};
var ds = new DsPurchase().PurchaseAnalyse;
ta.Fill(ds, itemno);
return ds;
}
public DsPurchase.PURINVDETAILDataTable GetPurInvDetailsById(string pkid)
{
var ta = new PURINVDETAILTableAdapter {Connection = {ConnectionString = _constr}};
var ds = new DsPurchase().PURINVDETAIL;
ta.FillBypurid(ds, pkid);
return ds;
}
public DsPurchase.PURINVMAINDataTable GetPurInvoiceMainById(string pkid)
{
var ta = new PURINVMAINTableAdapter {Connection = {ConnectionString = _constr}};
var ds = new DsPurchase().PURINVMAIN;
ta.FillByPurid(ds, pkid);
return ds;
}
public string DoSave(DsPurchase.PURINVMAINRow drow, DsPurchase.PURINVDETAILDataTable purinvdetail,bool issale=false, string tostore = "")
{
var dm = new DataManager();
string retval;
SqlTransaction tran = null;
var isnew = false;
try
{
var cn = new SqlConnection(_constr);
cn.Open();
tran = cn.BeginTransaction(IsolationLevel.ReadUncommitted);
var ds = new DsPurchase();
var dt = ds.PURINVMAIN;
var taPurMain = new PURINVMAINTableAdapter();
var taPurDetail = new PURINVDETAILTableAdapter();
var taStockMaster = new STOCKMASTERTableAdapter();
var taPriceMaster = new DsMasterTableAdapters.PRICEMASTERTableAdapter();
var taItemMaster = new DsMasterTableAdapters.ITEMMASTTableAdapter();
var taapar = new LedgersTableAdapters.APARMAINTableAdapter();
var taledger = new LedgersTableAdapters.LEDGERSTableAdapter();
taPurMain.Connection.ConnectionString = _constr;
taPurMain.FillByPurid(ds.PURINVMAIN, drow.PURINVID);
// taPurMain.Fill(ds.PURINVMAIN);
// Assaign Transaction
taPurMain.AssignConnection(cn, tran);
taPurDetail.AssignConnection(cn, tran);
taStockMaster.AssignConnection(cn, tran);
taPriceMaster.AssignConnection(cn, tran);
taItemMaster.AssignConnection(cn, tran);
taapar.AssignConnection(cn, tran);
taledger.AssignConnection(cn, tran);
var dr = dt.FindByPURINVID(drow.PURINVID);
if (dr != null)
{ dr.BeginEdit(); }
else
{ dr = (DsPurchase.PURINVMAINRow)dt.NewRow(); }
if (string.IsNullOrEmpty(drow.PURINVID))
{
var autoid = dm.GetAutoId(1);
autoid++;
Utils.Purinvid = dm.CreateFormatedAutoNo(autoid);
dr.PURINVID = Utils.Purinvid;
dr.USERID = Utils.Userid;
dr.COMPANY = Utils.Company;
dr.UDATE = DateTime.Now;
isnew = true;
}
else
{
Utils.Purinvid = drow.PURINVID;
dr.EDATE = DateTime.Now;
dr.EUSERID = Utils.Userid;
}
dr.SUPID = drow.SUPID;
dr.SUPNAME = drow.SUPNAME;
dr.INVDATE = drow.INVDATE;
dr.INVNO = drow.INVNO;
dr.DUEDAYS = drow.DUEDAYS;
dr.SPDISCOUNT = drow.SPDISCOUNT;
dr.WHID = drow.WHID;
dr.ADJVALUE = drow.ADJVALUE;
dr.NETVALUE = drow.NETVALUE;
dr.HOLD = drow.HOLD;
if (isnew)
{
dt.Rows.Add(dr);
taPurMain.Update(dt);
}
else
{
dr.EndEdit();
taPurMain.Update(dr);
}
//bool issale = false;//string tostore = string.Empty;
//STOCK
if (!drow.HOLD)
{
if (issale)
{
new StockMaster().CreateStock(ref cn, ref tran, purinvdetail, drow.WHID, "S", true, false);
}
else
{
new StockMaster().CreateStock(ref cn, ref tran, purinvdetail, drow.WHID, "P", true, false);
}
//Price Master
taPriceMaster.Update(new PriceMaster().UpdatePriceMaster(purinvdetail, drow.SUPID));
//UPDATE LASTPRICE,LASTEXPIRY,LASTCOSTPRICE
//LEDGER
taapar.Insert("S", dr.SUPID, DateTime.Now.Date, dr.INVDATE, Utils.Purinvid, dr.INVNO, dr.NETVALUE, 0,
dr.NETVALUE, Utils.Company, 1, Utils.Userid, 0);
taledger.Insert("S", dr.SUPID, DateTime.Now.Date, dr.INVDATE, Utils.Purinvid, dr.INVNO, 0,
dr.NETVALUE, 1, Utils.Company, Utils.Userid,"Purchase Invoice");
}
foreach (DsPurchase.PURINVDETAILRow purd in purinvdetail.Rows)
{
if ((purd.RowState != DataRowState.Deleted))
{
purd.PURINVID = Utils.Purinvid;
if (!purd.IsISSUEFORSALENull())
{
issale = purd.ISSUEFORSALE;
tostore = purd.TOSTORE;
}
// Item Master Price
if (!drow.HOLD)
{
taItemMaster.UpdateCPSP(purd.SPRICE, purd.CPRICE, purd.ITEMNO);
}
}
}
taPurDetail.Update(purinvdetail);
tran.Commit();
dm.UpdateAutoNum(1);
retval = "1";
}
catch (Exception ex)
{
if (tran != null)
tran.Rollback();
if (isnew)
Utils.Purinvid = string.Empty;
retval = ex.ToString();
}
return retval;
}
public void CreateItemMoveFrmPr(DsPurchase.PURCHASEREQUESTDataTable dt,string whid)
{
var dsStore = ClsGetData.GetStoreList();
var dr1= dsStore.Select ("COMPANY = '" + Utils.Company + "'");
var dr = dr1[0];
var bl = new Blitemmove();
lookupfrom.EditValue = dr[0].ToString();
lookupto.EditValue = whid;
bl.CreateItemtransferdetailsFrmMr(dt, dr[0].ToString());
//foreach (DsInventory.ITEMTRANSFERDETAILRow drn in bl.Itemtransferdetail)
//{
// var nr = dsInventory1.ITEMTRANSFERDETAIL.NewRow();
// dsInventory1.ITEMTRANSFERDETAIL.Rows.Add(nr);
//}
// gridControl1.DataSource = bl.Itemtransferdetail;
dsInventory1.Merge(bl.Itemtransferdetail);
}
public DsMaster.PRICEMASTERDataTable UpdatePriceMaster(DsPurchase.PURINVDETAILDataTable dt, string suplierid)
{
var ds = new DsMaster().PRICEMASTER;
var dsf = new DsMaster().PRICEMASTER;
var ta = new DsMasterTableAdapters.PRICEMASTERTableAdapter();
foreach (DsPurchase.PURINVDETAILRow d in dt.Rows)
{
if (d.RowState != DataRowState.Deleted)
{
ta.Connection.ConnectionString = _constr;
ta.FillBySupNo(dsf, d["ITEMNO"].ToString(), suplierid);
if (dsf.Rows.Count > 0)
{
foreach (DsMaster.PRICEMASTERRow drf in dsf.Rows)
{
if (!d.IsEXPDATENull())
{
if (drf.LASTEXPDT != d.EXPDATE)
{
drf.LASTEXPDT = d.EXPDATE;
}
}
if (drf.PPRICE != d.CPRICE || drf.SPRICE != d.SPRICE)
{
var dr = (DsMaster.PRICEMASTERRow) ds.NewRow();
dr.SUPPLIERNO = suplierid;
dr.PPRICE = d.CPRICE;
dr.SPRICE = d.SPRICE;
dr.PDATE = DateTime.Now.Date;
if (!d.IsEXPDATENull())
{
dr.LASTEXPDT = d.EXPDATE;
}
ds.Rows.Add(dr);
}
}
}
else
{
var dr = (DsMaster.PRICEMASTERRow)ds.NewRow();
dr.SUPPLIERNO = suplierid;
dr.PPRICE = d.CPRICE;
dr.SPRICE = d.SPRICE;
dr.PDATE = DateTime.Now.Date;
if (!d.IsEXPDATENull())
{
dr.LASTEXPDT = d.EXPDATE;
}
ds.Rows.Add(dr);
}
}
}
return ds;
}
public void CreateItemtransferdetailsFrmMr(DsPurchase.PURCHASEREQUESTDataTable dst,string whid)
{
Itemtransferdetail = new ItemMoveDataManager().CreateItemtransferdetailsFrmMR(dst, whid);
}
public static decimal GetProfit(DsPurchase.PURINVDETAILRow dr)
{
decimal retval = 0;
if(!dr.IsCPRICENull() && !dr.IsSPRICENull())
retval = dr.SPRICE - dr.CPRICE ;
return retval;
}
public static decimal GetCost(DsPurchase.PURINVDETAILRow dr)
{
//cost = CostPrice(d.QTY, d.BONUSQTY, d.INVRATE, d.DISC, decimal.Parse(spdisc.EditValue.ToString()));
var cost6 = 0m;
if (dr.QTY != 0)
{
decimal cost1 = (dr.QTY + dr.BONUSQTY) ;
var cost2 = dr.QTY * dr.INVRATE;
var cost3 = cost2 / cost1;
//var cost5 = 0m;
//var cost4 = 0m;
if (dr.DISC > 0)
{
cost6 = cost3 - (cost3 * dr.DISC) / 100;
//cost6 = cost5;
}
else
{
cost6 = cost3;
}
if (dr.SPDISC > 0)
{
cost6 = cost6 - (cost6 * dr.SPDISC) / 100;
//cost6 = cost4;
}
if (dr.INVDISC > 0)
{
cost6 = cost6 - (cost6 * dr.INVDISC) / 100;
//cost6 = cost4;
}
if (dr.DISC == 0 && dr.SPDISC==0 && dr.INVDISC == 0 && dr.BONUSQTY == 0)
cost6 = dr.INVRATE;
//else if (dr.DISC == 0 && dr.INVDISC == 0 && dr.BONUSQTY != 0)
// cost6 = cost5;
}
return Math.Round(cost6,2);
}
public string DoSavePurchaseRequestInRemote(DsPurchase.PURCHASEREQUESTDataTable dt)
{
var dm = new DataManager();
string retval="0";
SqlTransaction tran = null;
var cn = new SqlConnection(_constr);
try
{
cn.Open();
tran = cn.BeginTransaction(IsolationLevel.ReadUncommitted);
var ds = new DsPurchase();
var dtdetail = ds.PURCHASEREQUEST;
var taPurDetail = new PURCHASEREQUESTTableAdapter();
taPurDetail.AssignConnection(cn, tran);
foreach (DsPurchase.PURCHASEREQUESTRow ditemdetarow in dt)
{
var newdetrow = dtdetail.NewRow();
foreach (DataColumn dc in dt.Columns)
{
if (!dc.ReadOnly)
{
newdetrow[dc.ColumnName] = ditemdetarow[dc.ColumnName];
}
}
dtdetail.Rows.Add(newdetrow);
}
taPurDetail.Update(dtdetail);
tran.Commit();
retval = "1";
}
catch (Exception ex)
{
if (cn != null)
{
if (tran != null)
tran.Rollback();
}
retval = ex.ToString();
}
return retval;
}
public DsPurchase.PURCHASEREQUESTDataTable GetPurchaseRequest(string prno)
{
var ds = new DsPurchase().PURCHASEREQUEST;
var ta = new PURCHASEREQUESTTableAdapter {Connection = {ConnectionString = _constr}};
ta.FillByPRNO(ds, prno);
return ds;
}
public string DoSavePurchaseInvoiceInRemote(DsPurchase.PURINVMAINRow mainrow, DsPurchase.PURINVDETAILDataTable purinvdetail)
{
var dm = new DataManager();
string retval="0";
SqlTransaction tran = null;
//var possql = new SqlAsyncConnectionString();
var cn = new SqlConnection(_constr);
try
{
cn.Open();
tran = cn.BeginTransaction(IsolationLevel.ReadUncommitted);
var ds = new DsPurchase();
var dt = ds.PURINVMAIN;
var dtdetail = ds.PURINVDETAIL;
var taPurMain = new PURINVMAINTableAdapter();
var taPurDetail = new PURINVDETAILTableAdapter();
var taapar = new LedgersTableAdapters.APARMAINTableAdapter();
var taledger = new LedgersTableAdapters.LEDGERSTableAdapter();
taPurMain.Connection.ConnectionString = _constr;
taPurMain.FillByPurid(dt, mainrow.PURINVID);
// Assaign Transaction
taPurMain.AssignConnection(cn, tran);
taPurDetail.AssignConnection(cn, tran);
taapar.AssignConnection(cn, tran);
taledger.AssignConnection(cn, tran);
DsPurchase.PURINVMAINRow dr = null;
if (dt.Rows.Count == 0)
{
dr = (DsPurchase.PURINVMAINRow) dt.NewRow();
dr.PURINVID = mainrow.PURINVID;
dr.USERID = mainrow.USERID;
dr.COMPANY = mainrow.COMPANY;
dr.UDATE = mainrow.UDATE;
if (!mainrow.IsEDATENull())
dr.EDATE = mainrow.EDATE;
if (!mainrow.IsEUSERIDNull())
dr.EUSERID = mainrow.EUSERID;
dr.SUPID = mainrow.SUPID;
dr.SUPNAME = mainrow.SUPNAME;
dr.INVDATE = mainrow.INVDATE;
dr.INVNO = mainrow.INVNO;
dr.DUEDAYS = mainrow.DUEDAYS;
dr.SPDISCOUNT = mainrow.SPDISCOUNT;
dr.WHID = mainrow.WHID;
dr.ADJVALUE = mainrow.ADJVALUE;
dr.NETVALUE = mainrow.NETVALUE;
dr.HOLD = mainrow.HOLD;
dt.Rows.Add(dr);
taPurMain.Update(dt);
//LEDGER
taapar.Insert("S", dr.SUPID, mainrow.UDATE, dr.INVDATE, mainrow.PURINVID, dr.INVNO, dr.NETVALUE, 0, dr.NETVALUE, Utils.Company, 1, Utils.Userid, 0);
taledger.Insert("S", dr.SUPID, DateTime.Now.Date, dr.INVDATE, mainrow.PURINVID, dr.INVNO, 0,dr.NETVALUE, 1, Utils.Company, Utils.Userid, "Purchase Invoice");
foreach (DsPurchase.PURINVDETAILRow ditemdetarow in purinvdetail)
{
var newdetrow = dtdetail.NewRow();
foreach (DataColumn dc in purinvdetail.Columns)
{
if (!dc.ReadOnly)
{
newdetrow[dc.ColumnName] = ditemdetarow[dc.ColumnName];
}
}
dtdetail.Rows.Add(newdetrow);
}
taPurDetail.Update(dtdetail);
}
else
{
dr = dt.FindByPURINVID(mainrow.PURINVID);
var cmd = "UPDATE [PURINVMAIN] SET SUPID = '" + dr.SUPID + "' ,SUPNAME = '" + dr.SUPNAME +
"', INVNO = '" + dr.INVNO + "' ,INVDATE = '" + dr.INVDATE.ToString("yyyy-MM-dd HH:mm:ss") + "', DUEDAYS] = " + dr.DUEDAYS + " WHERE PURINVID ='" + dr.PURINVID + "'";
var sqlcmd2 = new SqlCommand();
sqlcmd2.Connection = cn;
sqlcmd2.Transaction = tran;
sqlcmd2.CommandText = cmd;
cmd = "update APARMAIN set REFNO = '" + dr.SUPID + "',INVOICEDATE ='" + dr.INVDATE.ToString("yyyy-MM-dd HH:mm:ss") + "',invoiceno= '" + dr.INVNO + "' where SOURCEID=1 and TYPE='S' AND VOUCHERNO='" + dr.PURINVID + "'";
var sqlcmd = new SqlCommand();
sqlcmd.Connection = cn;
sqlcmd.Transaction = tran;
sqlcmd.CommandText = cmd;
sqlcmd.ExecuteNonQuery();
cmd = "update LEDGERS set REFNO = '" + dr.SUPID + "',INVOICEDATE = '" + dr.INVDATE.ToString("yyyy-MM-dd HH:mm:ss") + "' ,invoiceno= '" + dr.INVNO + "' where SORUCE =1 and LEDGERTYPE='S' AND VOUCHERNO= '" + dr.PURINVID + "'";
var sqlcmd1 = new SqlCommand();
sqlcmd1.Connection = cn;
sqlcmd1.Transaction = tran;
sqlcmd1.CommandText = cmd;
sqlcmd1.ExecuteNonQuery();
}
tran.Commit();
retval = "1";
}
catch (Exception ex)
{
if (cn != null)
{
if (tran != null)
tran.Rollback();
}
retval = ex.ToString();
}
return retval;
}
public string DoSavePurchaseInvoiceReturnInRemote(DsPurchase.RETURNMASTRow drow, DsPurchase.RETURNDETAILDataTable returndetail)
{
var dm = new DataManager();
string retval="0";
SqlTransaction tran = null;
try
{
var cn = new SqlConnection(_constr);
cn.Open();
tran = cn.BeginTransaction(IsolationLevel.ReadUncommitted);
var ds = new DsPurchase();
var dt = ds.RETURNMAST;
var dtdetail = ds.RETURNDETAIL;
var taPurMain = new RETURNMASTTableAdapter ();
var taPurDetail = new RETURNDETAILTableAdapter();
var taapar = new LedgersTableAdapters.APARMAINTableAdapter();
var taledger = new LedgersTableAdapters.LEDGERSTableAdapter();
// Assaign Transaction
taPurMain.AssignConnection(cn, tran);
taPurDetail.AssignConnection(cn, tran);
taapar.AssignConnection(cn, tran);
taledger.AssignConnection(cn, tran);
var dr = (DsPurchase.RETURNMASTRow)dt.NewRow();
dr.RETURNID = drow.RETURNID;
dr.USERID = drow.USERID;
dr.COMPANY = drow.COMPANY;
dr.TRANDATE = drow.TRANDATE;
if(!dr.IsEDATENull())
dr.EDATE = dr.EDATE;
if(!dr.IsEUSERIDNull())
dr.EUSERID = dr.EUSERID;
dr.SUPID = drow.SUPID;
dr.SUPNAME = drow.SUPNAME;
dr.INVDATE = drow.INVDATE;
dr.INVNO = drow.INVNO;
dr.SPDISCOUNT = drow.SPDISCOUNT;
dr.WHID = drow.WHID;
dr.ADJVALUE = drow.ADJVALUE;
dr.NETVALUE = drow.NETVALUE;
dr.HOLD = drow.HOLD;
dt.Rows.Add(dr);
taPurMain.Update(dt);
//LEDGER
taapar.Insert("S", dr.SUPID, drow.TRANDATE, dr.INVDATE, drow.RETURNID, dr.INVNO, -dr.NETVALUE, 0, -dr.NETVALUE, Utils.Company, 2, Utils.Userid, 0);
taledger.Insert("S", dr.SUPID, drow.TRANDATE, dr.INVDATE, drow.RETURNID, dr.INVNO, dr.NETVALUE, 0, 2, Utils.Company, Utils.Userid, "Purchase Retun");
foreach (DsPurchase.RETURNDETAILRow ditemdetarow in returndetail)
{
var newdetrow = dtdetail.NewRow();
foreach (DataColumn dc in returndetail.Columns)
{
if (!dc.ReadOnly)
{
newdetrow[dc.ColumnName] = ditemdetarow[dc.ColumnName];
}
}
dtdetail.Rows.Add(newdetrow);
}
taPurDetail.Update(dtdetail);
tran.Commit();
retval = "1";
}
catch (Exception ex)
{
if (tran != null)
tran.Rollback();
retval = ex.ToString();
}
return retval;
}
private void PrintRowErrs(DsPurchase dataSet)
{
foreach (DataTable table in dataSet.Tables)
{
foreach (DataRow row in table.Rows)
{
if (row.HasErrors)
{
Console.WriteLine(row.RowError);
}
}
}
}
public string DoSave()
{
var dm = new DataManager();
string retval;
SqlTransaction tran = null;
var isnew = false;
try
{
var cn = new SqlConnection(_constr);
cn.Open();
tran = cn.BeginTransaction(IsolationLevel.ReadUncommitted);
var ds = new DsPurchase();
var dt = ds.POMAIN;
var taPurMain = new POMAINTableAdapter();
var taPurDetail = new PODETAILTableAdapter();
taPurMain.Connection.ConnectionString = _constr;
taPurMain.Fill(dt);
// Assaign Transaction
taPurMain.AssignConnection(cn, tran);
taPurDetail.AssignConnection(cn, tran);
var dr = dt.FindByPONO(Drow.PONO);
if (dr != null)
{ dr.BeginEdit(); }
else
{ dr = (DsPurchase.POMAINRow)dt.NewRow(); }
if (string.IsNullOrEmpty(Drow.PONO))
{
var autoid = dm.GetAutoId(11);
autoid++;
Utils.Pono = dm.CreateFormatedAutoNo(autoid);
dr.PONO = Utils.Pono;
dr.USERID = Utils.Userid;
dr.COMPANY = Utils.Company;
dr.UDATE = DateTime.Now;
isnew = true;
}
else
{
Utils.Pono = Drow.PONO;
dr.EDATE = DateTime.Now;
dr.EUSERID = Utils.Userid;
}
dr.TRANDATE = Drow.TRANDATE;
dr.SUPID = Drow.SUPID;
dr.SUPNAME = Drow.SUPNAME;
dr.SUPADD = Drow.SUPADD;
dr.DELADD = Drow.DELADD;
dr.DUEDAYS = Drow.DUEDAYS;
dr.STORECODE = Drow.STORECODE;
dr.EXTRDISC = Drow.EXTRDISC;
dr.NETVALUE = Drow.NETVALUE;
dr.PAYTERMS = Drow.PAYTERMS;
dr.supnote = Drow.supnote;
if (isnew)
{
dt.Rows.Add(dr);
taPurMain.Update(dt);
}
else
{
dr.EndEdit();
taPurMain.Update(dr);
}
foreach (DataRow purd in Podetail.Rows)
{
if ((purd.RowState != DataRowState.Deleted))
purd["PONO"] = Utils.Pono;
}
taPurDetail.Update(Podetail);
tran.Commit();
dm.UpdateAutoNum(11);
retval = "1";
}
catch (Exception ex)
{
if (tran != null)
tran.Rollback();
if (isnew)
Utils.Pono = string.Empty;
retval = ex.ToString();
}
return retval;
}
public DsInventory.ITEMTRANSFERDETAILDataTable CreateItemtransferdetailsFrmMR(DsPurchase.PURCHASEREQUESTDataTable dst, string whid)
{
var ret = new DsInventory.ITEMTRANSFERDETAILDataTable();
var dsS = new StockMaster().GetStockItemsForTransferDataTable(Utils.Company, whid);
foreach (DsPurchase.PURCHASEREQUESTRow dr in dst.Rows)
{
if (!dr.IsISSUEDNull())
{
if (dr.ISSUED > 0)
{
var q = from p in dsS where p.ITEMNO == dr.ITEMNO orderby p.QTY ascending select p ;
var tb = q.CopyToDataTable();
if (tb.Rows.Count > 0)
{
AddItemsToItemMoveDetails(tb, ref ret, dr.ITEMNO, dr.ISSUED,dr.COMPANY);
}
}
}
}
return ret;
}
