public void UpdateSalesMain(DataRow dr)
{
//string retval = "1";
//try
//{
var ta = new DsInventoryTableAdapters.SALESMAINTableAdapter { Connection = { ConnectionString = _constr } };
ta.Update(dr);
// var t = ta.Insert(sinvo, null, null, null, null, null, null, null, null, salesman, doctorid,
// Utils.Company,
// shiftcode, null, null, hold, compname, null, false, DateTime.Now, null, null, null,
// null, null, null, 0, 0, 0, 0, false, 0, 0, 0, false, false) > 0;
//}
//catch (Exception ex)
//{
// retval = ex.ToString();
//}
//return retval;
}
public DsInventory.SALESMAINDataTable GetHoldedInvoices(string compname)
{
var ta = new DsInventoryTableAdapters.SALESMAINTableAdapter {Connection = {ConnectionString = _constr}};
var ds = new DsInventory();
ta.FillByHold(ds.SALESMAIN, compname);
return ds.SALESMAIN;
}
public DsInventory.SALESMAINDataTable GetSalesInvMainBySinvno(string sinvno)
{
var ta = new DsInventoryTableAdapters.SALESMAINTableAdapter {Connection = {ConnectionString = _constr}};
var ds = new DsInventory().SALESMAIN;
ta.FillBySINVNO(ds,sinvno);
return ds;
}
public void DeleteSalesInvMain(string sinvno)
{
var ta = new DsInventoryTableAdapters.SALESMAINTableAdapter() {Connection = {ConnectionString = _constr}};
ta.DeleteSalesInvMainOnly(sinvno);
}
public void GetNonSaleInv()
{
var tasalMain = new DsInventoryTableAdapters.SALESMAINTableAdapter
{Connection = {ConnectionString = _constr}};
var tasaldetail = new DsInventoryTableAdapters.SALESINVDETAILTableAdapter
{Connection = {ConnectionString = _constr}};
var ds = new DsInventory();
tasalMain.FillByNonPost(ds.SALESMAIN, Environment.MachineName);
if (ds.SALESMAIN.Rows.Count > 0)
{
salesmainRow = ds.SALESMAIN[0];
var sinvno = salesmainRow[0].ToString();
try
{
tasaldetail.FillBySINVNO(ds.SALESINVDETAIL, sinvno);
salesinvdetailData = ds.SALESINVDETAIL;
}
catch (Exception ex)
{
System.Windows.Forms.MessageBox.Show(ex.ToString());
}
}
}
public DsInventory.SALESMAINDataTable GetSalesInvMain(string invno, bool issale = false, bool hold = false)
{
var ds = new DsInventory.SALESMAINDataTable();
var ta = new DsInventoryTableAdapters.SALESMAINTableAdapter {Connection = {ConnectionString = _constr}};
ta.FillByInvno(ds, invno, issale, hold);
return ds;
}
public string DoSave()
{
SqlTransaction tran = null;
var retval = "0";
try
{
var dsStockWithItemcodes = GetStockTableWithItemCodes(salesinvdetailData);
var cn = new SqlConnection(_constr);
cn.Open();
tran = cn.BeginTransaction(IsolationLevel.ReadUncommitted);
var ds = new DsInventory();
var dt = ds.SALESMAIN;
var tasalMain = new DsInventoryTableAdapters.SALESMAINTableAdapter();
var tasalDetail = new DsInventoryTableAdapters.SALESINVDETAILTableAdapter();
var tasalesamtdetails = new LedgersTableAdapters.SalesAmountDetailsTableAdapter();
tasalesamtdetails.AssignConnection(cn, tran);
tasalMain.Connection.ConnectionString = _constr;
// tasalMain.Fill(dt);
tasalMain.FillBySINVNO(dt,salesmainRow.SINVNO);
tasalMain.AssignConnection(cn, tran);
tasalDetail.AssignConnection(cn, tran);
var dr = dt.FindBySINVNO(salesmainRow.SINVNO);
bool isnew = false;
if (dr != null)
{
dr.BeginEdit();
dr.EndEdit();
}
else
{
dr = (DsInventory.SALESMAINRow) dt.NewRow();
dr.ItemArray = salesmainRow.ItemArray;
isnew = true;
}
if (isnew)
{
dt.Rows.Add(dr);
tasalMain.Update(dt);
}
else
{
tasalMain.Update(salesmainRow);
}
//salesmainRow.SALESTYPE
if (salesmainRow.SALESTYPE == "I" || salesmainRow.SALESTYPE == "C")
{
var taaparleder = new LedgersTableAdapters.APARMAINTableAdapter();
var taledger = new LedgersTableAdapters.LEDGERSTableAdapter();
taledger.AssignConnection(cn, tran);
taaparleder.AssignConnection(cn, tran);
var netamt = 0m;
var totaldiscper = 0m;
if (salesmainRow.SALESTYPE == "I")
{
totaldiscper = salesmainRow.CUSTOMERFIXDISC ;
netamt = salesmainRow.CREDITAMT;
}
else
{
netamt = salesmainRow.CREDITAMT;
totaldiscper = salesmainRow.CUSTOMERFIXDISC ;
}
if (netamt > 0)
{
string cdno = "";
if (!salesmainRow.IsCARDNONull())
cdno = salesmainRow.CARDNO.ToString();
taaparleder.Insert("C", salesmainRow.CUSTOMERID, salesmainRow.TRANDATE,
salesmainRow.TRANDATE,
cdno, salesmainRow.SINVNO, netamt, 0, netamt,
salesmainRow.COMPANY,
3, salesmainRow.SALESMAN, totaldiscper);
taledger.Insert("C", salesmainRow.CUSTOMERID, salesmainRow.TRANDATE,
salesmainRow.TRANDATE, cdno,
salesmainRow.SINVNO, netamt, 0, 3, salesmainRow.COMPANY,
Utils.Userid, "Sales Invoice");
}
}
foreach (DsInventory.SALESINVDETAILRow drstk in salesinvdetailData.Rows)
{
if(!drstk.IsSTOCKIDNull())
{
if(drstk.STOCKID > 0)
{
if (drstk.ISRETURN)
{
UpdateStockQty(ref cn, ref tran, drstk.STOCKID, (drstk.QTY * -1), drstk);
}
else
{
UpdateStockQty(ref cn, ref tran, drstk.STOCKID, -drstk.QTY, drstk);
}
}
else
{
if (drstk.ISRETURN)
{
AddNewItemItemInStock(ref cn, ref tran, drstk, dsStockWithItemcodes);
}
}
}
}
tasalDetail.Update(salesinvdetailData);
tasalesamtdetails.Update(SalesAmount);
tran.Commit();
retval = "1";
}
catch (Exception ex)
{
retval = ex.ToString();
tran.Rollback();
}
return retval;
}
public string DoSave(string sinvo, bool hold, int salesman, int doctorid, string shiftcode, string compname,decimal totamt=0,decimal netamt=0)
{
string retval = "1";
try
{
var ta = new DsInventoryTableAdapters.SALESMAINTableAdapter {Connection = {ConnectionString = _constr}};
var t = ta.Insert(sinvo, null, null, null, null,totamt, null, netamt, null, salesman, doctorid,
Utils.Company,
shiftcode, null, null, hold, compname, null, false, DateTime.Now, null, null, null,
null, null, null, 0, 0, 0, 0, false, 0, 0, 0, false, false,null) > 0;
}
catch (Exception ex)
{
retval = ex.ToString();
}
return retval;
}
