public string DoUpLoadPromotions(Ledgers.COMMISIONMASTRow CommisionmastRow, Ledgers.COMMISIONDETAILDataTable commisiondetail,bool isRemote=false)
{
var dm = new DataManager();
string retval;
SqlTransaction tran = null;
try
{
if (isRemote)
_syncConstr = Utils.Connectionstring;
var cn = new SqlConnection(_syncConstr);
cn.Open();
tran = cn.BeginTransaction(IsolationLevel.ReadUncommitted);
var ds = new Ledgers();
var dt = ds.COMMISIONMAST;
var dtdetail = ds.COMMISIONDETAIL;
var taCommMain = new COMMISIONMASTTableAdapter();
var taCommDetail = new COMMISIONDETAILTableAdapter();
// Assaign Transaction
taCommMain.AssignConnection(cn, tran);
taCommDetail.AssignConnection(cn, tran);
var dr = (Ledgers.COMMISIONMASTRow)dt.NewRow();
dr.PRMOFRM = CommisionmastRow.PRMOFRM;
dr.PRMOTO = CommisionmastRow.PRMOTO;
dr.PROMONAME = CommisionmastRow.PROMONAME;
dr.STOREID = CommisionmastRow.STOREID;
dr.EMPNO = CommisionmastRow.EMPNO;
dr.STATUS = CommisionmastRow.STATUS;
dr.COMID = CommisionmastRow.COMID;
dr.USERID = CommisionmastRow.USERID;
dr.UDATE = DateTime.Now;
dt.Rows.Add(dr);
taCommMain.Update(dt);
//LEDGER
foreach (Ledgers.COMMISIONDETAILRow ditemdetarow in commisiondetail)
{
var newdetrow = dtdetail.NewRow();
foreach (DataColumn dc in commisiondetail.Columns)
{
if (!dc.ReadOnly)
{
newdetrow[dc.ColumnName] = ditemdetarow[dc.ColumnName];
}
}
dtdetail.Rows.Add(newdetrow);
}
taCommDetail.Update(dtdetail);
if (isRemote)
{
var dmu = new CommissionSetup();
dmu.UpdateSync(dr.COMID, true);
}
tran.Commit();
retval = "1";
}
catch (Exception ex)
{
if (tran != null)
tran.Rollback();
retval = ex.ToString();
}
return retval;
}
public string DoSave()
{
var dl = new VIRETAILDAL.Masters.CommissionSetup
{CommisionmastRow = CommisionmastRow, Commisiondetail = Commisiondetail};
var retval = dl.DoSave();
if (retval == "1")
{
tranid = Utils.CommissionNo;
}
return retval;
}