void DoView()
{
if (Utils.Company != "00")
{
RibbonSaveEnable = false;
}
if (!string.IsNullOrEmpty(_COMID))
{
var bl = new BlCommissionSetup();
var dt = bl.GetCommissionMast(_COMID);
foreach(Ledgers.COMMISIONMASTRow dr in dt.Rows)
{
txtdocno.Text = _COMID;
Frmdate.EditValue = dr.PRMOFRM;
Todate.EditValue = dr.PRMOTO;
Promoname.EditValue = dr.PROMONAME;
LookuptoStore.EditValue = null;
if(!dr.IsSTOREIDNull())
LookuptoStore.EditValue = dr.STOREID;
lookupsalesman.EditValue = dr.EMPNO;
RibbonSaveEnable =true;
labelControl1.Visible = false;
if (!dr.IsUPLOADNull())
{
if (dr.UPLOAD)
{
RibbonSaveEnable = false;
labelControl1.Visible = true;
}
}
}
if (ledgers1.COMMISIONDETAIL.Rows.Count > 0)
{
ledgers1.COMMISIONDETAIL.Clear();
}
ledgers1.Merge(bl.GetCommissionDetail(_COMID));
}
}
bool DoSave()
{
gridView1.PostEditor();
gridView1.UpdateCurrentRow();
bool retval = false;
if (Frmdate.EditValue == null)
{
XtraMessageBox.Show("Please select start date", "POS", MessageBoxButtons.OK, MessageBoxIcon.Information);
return false;
}
if(Todate.EditValue==null)
{
XtraMessageBox.Show("Please select End date", "POS", MessageBoxButtons.OK, MessageBoxIcon.Information);
return false;
}
if(ledgers1.COMMISIONDETAIL.Count==0)
{
XtraMessageBox.Show("Nothing to save", "POS", MessageBoxButtons.OK, MessageBoxIcon.Information);
return false;
}
//if (LookuptoStore.EditValue == null)
//{
// XtraMessageBox.Show("Please select store", "POS", MessageBoxButtons.OK, MessageBoxIcon.Information);
// return false;
//}
if (lookupsalesman.EditValue == null)
{
XtraMessageBox.Show("Please select salesman", "POS", MessageBoxButtons.OK, MessageBoxIcon.Information);
return false;
}
foreach(Ledgers.COMMISIONDETAILRow drd in ledgers1.COMMISIONDETAIL.Rows)
{
if(drd.RowState!=DataRowState.Deleted)
{
drd.SetColumnError("STDATE", drd.IsSTDATENull() ? "Please enter start date" : null);
drd.SetColumnError("TODATE", drd.IsTODATENull() ? "Please enter start date" : null);
}
}if (ledgers1.COMMISIONDETAIL.HasErrors)
{
XtraMessageBox.Show("Document not saved due to error, please check the errors", "POS",
MessageBoxButtons.OK, MessageBoxIcon.Error);
return false;
}
var dr = (Ledgers.COMMISIONMASTRow)ledgers1.COMMISIONMAST.NewRow();
if (!string.IsNullOrEmpty(_COMID))
dr.COMID = _COMID;
dr.PRMOFRM = Frmdate.DateTime;
dr.PRMOTO = Todate.DateTime;
dr.EMPNO = lookupsalesman.EditValue.ToString();
if (LookuptoStore.EditValue!=null)
dr.STOREID = LookuptoStore.EditValue.ToString();
dr.PROMONAME = Promoname.EditValue == null ? dr.PRMOFRM + " - " + dr.PRMOTO : Promoname.EditValue.ToString();
dr.STATUS = true;
var bhl = new BlCommissionSetup { CommisionmastRow = dr };
cOMMISIONDETAILBindingSource.EndEdit();
var changes = (Ledgers.COMMISIONDETAILDataTable)ledgers1.COMMISIONDETAIL.GetChanges(DataRowState.Modified | DataRowState.Added);
bhl.Commisiondetail = ledgers1.COMMISIONDETAIL;
try
{
var strstatus = bhl.DoSave();
if (strstatus == "1")
{
_COMID = bhl.tranid;
txtdocno.Text = _COMID ;
XtraMessageBox.Show("Data Saved Sucessfully", "POS", MessageBoxButtons.OK, MessageBoxIcon.Information);
foreach (DataRow d in ledgers1.COMMISIONDETAIL.Rows)
{
if (d.RowState != DataRowState.Deleted)
{
d["COMID"] = _COMID;
}
}
var addedRows = from row in ledgers1.COMMISIONDETAIL
where row.RowState == DataRowState.Added
select row;
foreach (var row in addedRows.ToArray())
{
row.Delete();
}
if (changes != null)
{
//ledgers1.Merge(changes);
ledgers1.COMMISIONDETAIL.Clear();
ledgers1.Merge(ClsGetData.GetCommissionDetail(_COMID));
}
// ledgers1.AcceptChanges();
retval = true;
}
else
{
XtraMessageBox.Show(strstatus);
}
}
catch (Exception ex)
{
XtraMessageBox.Show(ex.ToString());
}
return retval;
}
void DoDownLoadPromotions()
{
txtstatus.Caption = "Downloading Promotions";
Application.DoEvents();
try
{
var dm = new BlCommissionSetup();
var dt = dm.GetCommissonMastNotReceived();
var syc = new RemoteSync();
if (Utils.PingServer() )
{
if (dt.Rows.Count == 0)
{
var drd = _dsdownload.NewRow();
drd[0] = "";
drd[1] = DateTime.Now.Date;
drd[2] = "Commission Invoice";
drd[3] = "Nothing to Download";
_dsdownload.Rows.Add(drd);
}
}
else
{
XtraMessageBox.Show("Failed to connect server ", "POS", MessageBoxButtons.OK,MessageBoxIcon.Information);
}
foreach (Ledgers.COMMISIONMASTRow dr in dt.Rows)
{
if (Utils.PingServer())
{
var drd = _dsdownload.NewRow();
drd[0] = dr.COMID;
drd[1] = DateTime.Now.Date;
drd[2] = "Commission Invoice";
var ret = syc.DoUpLoadPromotions(dr, dm.GetCommissionDetail(dr.COMID, true), true);
if (ret == "1")
{
drd[3] = "Downloaded";
}
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);
}
}
