public bool IsAuthenticated(string username, string password)
{
bool result = false;
try
{
var a = pEntity.ref_user_Login(username, password).FirstOrDefault();
if (a.userid > 0)
{
_userId = a.userid.ToString();
_position = a.position;
result = true;
}
else
{
_err = "Username or passwod is incorrect.";
result = false;
}
}
catch (Exception e)
{
_err = e.ToString();
a.logModule = "User CS";
a.logError = e.ToString();
a.DateCreated = DateTime.Now;
lg.InsertLog(a);
result = false;
}
return(result);
}
public bool Create(trn_productDetail _ref)
{
bool rtval = false;
try
{
pEntity.trn_productdetail_Insert(_ref.product_detail_id,
_ref.product_id,
_ref.measurement,
_ref.measurevalue,
_ref.supplierprice,
_ref.retailprice,
_ref.QTY,
_ref.dateupdated,
_ref.datecreated,
_ref.updatedby,
_ref.isActive,
_ref.isDelete,
_ref.ExpiryDate
);
pEntity.SaveChanges();
rtval = true;
}
catch (Exception ex)
{
_err = ex.ToString();
a.logModule = "Product Detail CS";
a.logError = ex.ToString();
a.DateCreated = DateTime.Now;
lg.InsertLog(a);
rtval = false;
}
return(rtval);
}
public bool Create(TransactionDetails trx)
{
bool rtval = false;
try
{
pEntity.trn_transactionsales_detail_Insert(trx.productcode, trx.sales_id,
trx.product_id,
trx.RetailPrice,
trx.QTY,
trx.TotalAmount,
trx.isCheckedout
);
pEntity.SaveChanges();
rtval = true;
}
catch (Exception ex)
{
_err = ex.ToString();
a.logModule = "Sales Detail CS";
a.logError = ex.ToString();
a.DateCreated = DateTime.Now;
lg.InsertLog(a);
rtval = false;
}
return(rtval);
}
public bool Create(Transactions trx)
{
bool rtval = false;
try
{
pEntity.trn_transactionsales_Insert(trx.referenceNo,
trx.TotalAmount,
trx.Discounted,
trx.GrandTotal,
trx.AmountPaid,
trx.PayBalance,
trx.status,
trx.isPaid,
trx.isVoided,
trx.TransactionType,
trx.CustomerId,
trx.DateCreated,
trx.dateUpdated,
trx.processed_by
);
pEntity.SaveChanges();
rtval = true;
}
catch (Exception ex)
{
_err = ex.ToString();
a.logModule = "Sales CS";
a.logError = ex.ToString();
a.DateCreated = DateTime.Now;
lg.InsertLog(a);
rtval = false;
}
return(rtval);
}
public bool Create(trn_transaction_log trx)
{
bool rtval = false;
try
{
pEntity.trn_transaction_log_Insert(trx.sales_id,
trx.current_status,
trx.statusby,
trx.DateUpdated
);
pEntity.SaveChanges();
rtval = true;
}
catch (Exception ex)
{
_err = ex.ToString();
a.logModule = "Sales Logs CS";
a.logError = ex.ToString();
a.DateCreated = DateTime.Now;
lg.InsertLog(a);
rtval = false;
}
return(rtval);
}
public bool DeductStocks(int productId, int QTY, int updatedby)
{
bool result = false;
try
{
pEntity.trn_stock_qty_update(productId, QTY, updatedby, 2);
pEntity.SaveChanges();
result = true;
}
catch (Exception e)
{
_err = e.ToString();
a.logModule = "InventoryStocks CS";
a.logError = e.ToString();
a.DateCreated = DateTime.Now;
lg.InsertLog(a);
result = false;
}
return(result);
}
public bool Create(supplier _ref)
{
bool rtval = false;
try
{
pEntity.ref_supplier_Insert(_ref.Supplier_name, _ref.Supplier_address, _ref.Supplier_contact, _ref.isDelete, _ref.isActive);
pEntity.SaveChanges();
rtval = true;
}
catch (Exception ex)
{
_err = ex.ToString();
a.logModule = "Suppliers CS";
a.logError = ex.ToString();
a.DateCreated = DateTime.Now;
lg.InsertLog(a);
rtval = false;
}
return(rtval);
}
public bool Create(Category _ref)
{
bool rtval = false;
try
{
pEntity.ref_category_Insert(_ref.category_id, _ref.categoryname);
pEntity.SaveChanges();
rtval = true;
}
catch (Exception ex)
{
_err = ex.ToString();
a.logModule = "Category";
a.logError = ex.ToString();
a.DateCreated = DateTime.Now;
lg.InsertLog(a);
rtval = false;
}
return(rtval);
}
public bool Create(Truckers _ref)
{
bool rtval = false;
try
{
pEntity.ref_trucking_Insert(_ref.trucking_id, _ref.trucking_name, _ref.platenos);
pEntity.SaveChanges();
rtval = true;
}
catch (Exception ex)
{
_err = ex.ToString();
a.logModule = "Trucking CS";
a.logError = ex.ToString();
a.DateCreated = DateTime.Now;
lg.InsertLog(a);
rtval = false;
}
return(rtval);
}
public bool Create(PurchaseRequest _ref)
{
bool rtval = false;
try
{
pEntity.trn_porequest_Insert(_ref.poRef, _ref.TotalAmount, _ref.DateCreated, _ref.Createdby, false, _ref.status);
pEntity.SaveChanges();
rtval = true;
}
catch (Exception ex)
{
_err = ex.ToString();
a.logModule = "Purchase CS";
a.logError = ex.ToString();
a.DateCreated = DateTime.Now;
lg.InsertLog(a);
rtval = false;
}
return(rtval);
}
public bool Create(product _ref)
{
bool rtval = false;
try
{
pEntity.ref_product_Insert(_ref.product_id, _ref.category_id, _ref.ProductCode, _ref.ProductName, _ref.ProductDescription,
_ref.Barcode, _ref.measurement, _ref.supplierprice, _ref.retailprice, _ref.QTY, _ref.criticalQTY, _ref.unitWeight, _ref.Weight, _ref.Expirydate, _ref.isDelete, _ref.isActive, _ref.supplier_id, _ref.dateCreated,
_ref.updatedBy, _ref.dateUpdated);
pEntity.SaveChanges();
rtval = true;
}
catch (Exception ex)
{
_err = ex.ToString();
a.logModule = "Product CS";
a.logError = ex.ToString();
a.DateCreated = DateTime.Now;
lg.InsertLog(a);
rtval = false;
}
return(rtval);
}
public bool Create(measure _ref)
{
bool rtval = false;
try
{
pEntity.ref_measurement_Insert(_ref.measure_id,_ref.measurement);
pEntity.SaveChanges();
rtval = true;
}
catch (Exception ex)
{
_err = ex.ToString();
a.logModule = "Measures";
a.logError = ex.ToString();
a.DateCreated = DateTime.Now;
lg.InsertLog(a);
rtval = false;
}
return rtval;
}
private void toolStripButton5_Click(object sender, EventArgs e)
{
//TODO Void Order
try
{
if (MessageBox.Show("Item will be cancelled", "Warning", MessageBoxButtons.YesNo) == DialogResult.Yes)
{
CancelOrder();
}
}
catch (Exception ex)
{
a.logModule = "Cancel Order : " + lbltxnid.Text;
a.logError = ex.ToString();
a.DateCreated = DateTime.Now;
lg.InsertLog(a);
MessageBox.Show("Nothing to cancel");
this.Close();
}
}
private void button1_Click(object sender, EventArgs e)
{
try
{
if (lblcatid.Text != "")
{
UpdateRecord();
}
else
{
Insert();
}
MessageBox.Show("Record has been saved.");
}
catch (Exception ex)
{
a.logModule = "Supplier Entry";
a.logError = ex.ToString();
a.DateCreated = DateTime.Now;
lg.InsertLog(a);
MessageBox.Show("No Record created data must be wrong please try again.");
}
this.Close();
}
public bool ProductRelease(int sales_detail_id, int productid, int qty, bool ischeckout)
{
bool result = false;
try
{
pEntity.trn_transactionsales_detail_releasing_update(sales_detail_id, productid, qty, ischeckout);
pEntity.SaveChanges();
result = true;
}
catch (Exception ex)
{
_err = ex.ToString();
a.logModule = "ReleaseRepositories CS";
a.logError = ex.ToString();
a.DateCreated = DateTime.Now;
lg.InsertLog(a);
result = false;
}
return(result);
}
