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); } }