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