public static void DeletePurRetInv(string purid)
{
var dm = new PurReturnDataManger();
dm.DeletePurRetInv(purid, Utils.Company);
}
public string DoSave()
{
var dm = new PurReturnDataManger();
var retval = dm.DoSave(RetinvmainRow, Retinvdetail);
if (retval == "1")
{
Retinvid = Utils.Retinvid;
}
return retval;
//string retval;
// SqlTransaction tran = null;
// var isnew = false;
// try
// {
// var cn = new SqlConnection(Properties.Settings.Default.POSConnectionString);
// cn.Open();
// tran = cn.BeginTransaction(IsolationLevel.ReadUncommitted);
// var ds = new DsInventory();
// var dt = ds.RETURNMAST;
// var dm = new DataManager();
// var taPurMain = new RETURNMASTTableAdapter();
// var taPurDetail = new RETURNDETAILTableAdapter();
// var taStockMaster = new STOCKMASTERTableAdapter();
// taStockMaster.Fill(ds.STOCKMASTER);
// taPurMain.Fill(ds.RETURNMAST);
// // Assaign Transaction
// taPurMain.AssignConnection(cn, tran);
// taPurDetail.AssignConnection(cn, tran);
// taStockMaster.AssignConnection(cn, tran);
// var dr = dt.FindByRETURNID(Retinvid);
// if (dr != null)
// { dr.BeginEdit(); }
// else
// { dr = (DsInventory.RETURNMASTRow)dt.NewRow(); }
// if (string.IsNullOrEmpty(Retinvid))
// {
// var autoid = dm.GetAutoId(2);
// autoid++;
// Retinvid = COMMON.Functions.CreateFormatedAutoNo(autoid);
// dr.RETURNID = Retinvid;
// dr.USERID = COMMON.Utils.Userid;
// dr.COMPANY = COMMON.Utils.Company;
// isnew = true;
// }
// else
// {
// dr.EDATE = DateTime.Now;
// dr.EUSERID = COMMON.Utils.Userid;
// }
// dr.SUPID = Supid;
// dr.SUPNAME = Supname;
// dr.INVDATE = Invdate;
// dr.INVNO = Invno;
// dr.SPDISCOUNT = Spdiscount;
// dr.WHID = Whid;
// dr.ADJVALUE = Adjvalue;
// dr.NETVALUE = Netvalue;
// dr.HOLD = Hold;
// if (isnew)
// {
// dt.Rows.Add(dr);
// taPurMain.Update(dt);
// }
// else
// {
// dr.EndEdit();
// taPurMain.Update(dr);
// }
// foreach (DataRow purd in Retinvdetail.Rows)
// {
// if ((purd.RowState != DataRowState.Deleted))
// purd["RETURNID"] = Retinvid;
// }
// taPurDetail.Update(Retinvdetail);
// if (!dr.HOLD)
// {
// COMMON.Functions.UpdateQtyInStockDataSet(ref ds, Retinvdetail,true);
// taStockMaster.Update(ds.STOCKMASTER);
// }
// tran.Commit();
// dm.UpdateAutoNum(2);
// retval = "1";
// }
// catch (Exception ex)
// {
// if (tran != null)
// tran.Rollback();
// if (isnew)
// Retinvid = string.Empty;
// retval = ex.ToString();
// }
// return retval;
}
void DoUploadPurchaseReturn()
{
txtstatus.Caption = "Uploading Purchase Return";
try
{
var dm = new PurReturnDataManger();
var dt = dm.GetPurchaseInvoiceReturnNotSync();
var syc = new RemoteSync();
if (dt.Rows.Count == 0)
{
var drd = _dsdownload.NewRow();
drd[0] = "";
drd[1] = DateTime.Now.Date;
drd[2] = "Purchase Return";
drd[3] = "Nothing to Upload ";
_dsdownload.Rows.Add(drd);
}
foreach (DsPurchase.RETURNMASTRow dr in dt.Rows)
{
if (Utils.PingServer())
{
var drd = _dsdownload.NewRow();
drd[0] = dr.RETURNID;
drd[1] = DateTime.Now.Date;
drd[2] = "Purchase Return";
var ret = syc.DoSavePurchaseInvoiceReturnInRemote(dr, dm.GetPurRetInvDetailsById(dr.RETURNID));
if (ret == "1")
{
dm.UpdatedSynReturn(dr.RETURNID);
drd[3] = "Uploaded";
}
else
{
drd[3] = "Error " + ret;
}
_dsdownload.Rows.Add(drd);
}
else
{
XtraMessageBox.Show("Failed to connect server ", "POS", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
}
}
catch (Exception exp)
{
XtraMessageBox.Show(exp.ToString(), "POS", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
}
