public void DeleteSalesCategory() { try { string _read = "DELETE FROM TBL_SALESCATEGORY WHERE ZREPORT='True'"; CeDataCon.ConString = ConfigurationManager.ConnectionStrings["ConnectionString"].ToString(); CeDataCon.CmdType = CommandType.Text; CeDataCon.CmdString = _read; CeDataCon.DeleteRecord(); } catch (Exception ex) { if (!EventLog.SourceExists("POSErrorLog")) { EventLog.CreateEventSource("EasyPos", "POSErrorLog"); } EventLog myLog = new EventLog(); myLog.Source = "Pync Error"; myLog.WriteEntry("DeleteSalesCategory : " + ex.StackTrace); } }
public void DeleteEOD() { try { string s = "DELETE FROM TBL_EOD WHERE EODID=@EODID"; SqlCeParameter spEodid = new SqlCeParameter(); spEodid.ParameterName = "@EODID"; spEodid.SqlDbType = System.Data.SqlDbType.NVarChar; spEodid.Value = EodId; objDB.ConString = Dcon; objDB.CmdType = CommandType.Text; objDB.CmdString = s; objDB.DeleteRecord(spEodid); } catch (Exception ex) { } }
public void DeleteTenderDtls() { try { string s = "DELETE FROM TBL_TENDER_DETAIL WHERE DOCUMENTID=@DOCUMENTID"; SqlCeParameter spDocumentid = new SqlCeParameter(); spDocumentid.ParameterName = "@DocumentID"; spDocumentid.SqlDbType = System.Data.SqlDbType.NVarChar; spDocumentid.Value = this.InvoiceId; objDB.ConString = Dcon; objDB.CmdType = CommandType.Text; objDB.CmdString = s; objDB.DeleteRecord(spDocumentid); } catch (Exception ex) { } }