public List<InvoiceHeaderBO> GetAllInvoicesForCurrentDate() { DBEgine objDbAccess = new DBEgine(); var list = new List<InvoiceHeaderBO>(); try { objDbAccess.DBOpen(); SqlDataReader dr = objDbAccess.ExecuteReader("Sales.GetCurrentDayInvoices", null); while (dr.Read()) { var invoice = new InvoiceHeaderBO(); invoice.InvoiceID = int.Parse(dr["InvoiceID"].ToString()); invoice.InvoiceNumber = dr["InvoiceNumber"].ToString(); list.Add(invoice); } return list; } catch (Exception ex) { throw ex; } finally { objDbAccess.DBClose(); } }
public bool DeleteInvoice(InvoiceHeaderBO invoiceHeader) { DBEgine objDbAccess = new DBEgine(); bool result = false; SqlTransaction tran = null; try { SqlParameter[] parms = new SqlParameter[1]; SqlParameter parmInvoiceID = new SqlParameter(); parmInvoiceID.Value = invoiceHeader.InvoiceID; parmInvoiceID.SqlDbType = SqlDbType.Int; parmInvoiceID.Direction = ParameterDirection.Input; parmInvoiceID.ParameterName = "@InvoiceID"; parms[0] = parmInvoiceID; objDbAccess.DBOpen(tran); if (objDbAccess.ExecNonQueryStoredProc("Sales.DeleteInvoices", parms) > 0) { result = true; } objDbAccess.DBTransAction.Commit(); return result; } catch { objDbAccess.DBTransAction.Rollback(); throw; } finally { objDbAccess.DBClose(); } }
public bool SaveInvoice(InvoiceHeaderBO invoiceHeader, List<InvoiceDetailBO> invoiceDetail,ref string invoiceNumber,ref int invoiceID) { DBEgine objDbAccess = new DBEgine(); bool result = false; SqlTransaction tran = null; try { SqlParameter[] parms = new SqlParameter[8]; SqlParameter parmInvoiceID = new SqlParameter(); parmInvoiceID.Value = invoiceHeader.InvoiceID; parmInvoiceID.SqlDbType = SqlDbType.Int; parmInvoiceID.Direction = ParameterDirection.InputOutput; parmInvoiceID.ParameterName = "@InvoiceID"; parms[0] = parmInvoiceID; SqlParameter parmInvoiceNumber = new SqlParameter(); parmInvoiceNumber.Value = invoiceHeader.InvoiceNumber; parmInvoiceNumber.SqlDbType = SqlDbType.VarChar; parmInvoiceNumber.Direction = ParameterDirection.InputOutput; parmInvoiceNumber.ParameterName = "@InvoiceNumber"; parms[1] = parmInvoiceNumber; SqlParameter parmIsInvalied = new SqlParameter(); parmIsInvalied.Value = invoiceHeader.StatusID; parmIsInvalied.SqlDbType = SqlDbType.Int; parmIsInvalied.Direction = ParameterDirection.Input; parmIsInvalied.ParameterName = "@StatusID"; parms[2] = parmIsInvalied; SqlParameter parmTotal = new SqlParameter(); parmTotal.Value = invoiceHeader.Total; parmTotal.SqlDbType = SqlDbType.Decimal; parmTotal.Direction = ParameterDirection.Input; parmTotal.ParameterName = "@Total"; parms[3] = parmTotal; SqlParameter parmCreatedUser = new SqlParameter(); parmCreatedUser.Value = invoiceHeader.CreatedUser; parmCreatedUser.SqlDbType = SqlDbType.Int; parmCreatedUser.Direction = ParameterDirection.Input; parmCreatedUser.ParameterName = "@CreatedUser"; parms[4] = parmCreatedUser; SqlParameter parmCustomerID = new SqlParameter(); parmCustomerID.Value = invoiceHeader.CustomerID; parmCustomerID.SqlDbType = SqlDbType.Int; parmCustomerID.Direction = ParameterDirection.Input; parmCustomerID.ParameterName = "@CustomerID"; parms[5] = parmCustomerID; SqlParameter parmReceivedAmount = new SqlParameter(); parmReceivedAmount.Value = invoiceHeader.ReceivedAmount; parmReceivedAmount.SqlDbType = SqlDbType.Decimal; parmReceivedAmount.Direction = ParameterDirection.Input; parmReceivedAmount.ParameterName = "@ReceivedAmount"; parms[6] = parmReceivedAmount; SqlParameter parmBalance = new SqlParameter(); parmBalance.Value = invoiceHeader.Balance; parmBalance.SqlDbType = SqlDbType.Int; parmBalance.Direction = ParameterDirection.Input; parmBalance.ParameterName = "@Balance"; parms[7] = parmBalance; objDbAccess.DBOpen(tran); if (objDbAccess.ExecNonQueryStoredProc("Sales.SaveInvoice", parms) > 0) { foreach (InvoiceDetailBO obj in invoiceDetail) { obj.InvoiceId = int.Parse(parms[0].Value.ToString()); bool success = SaveInvoiceDetail(objDbAccess, obj); if (!success) { objDbAccess.DBTransAction.Rollback(); return false; } } invoiceNumber = parms[1].Value.ToString(); invoiceID = int.Parse(parms[0].Value.ToString()); result = true; } objDbAccess.DBTransAction.Commit(); return result; } catch (SqlException ex) { throw ex; } catch (Exception ex) { throw ex; } finally { objDbAccess.DBClose(); } }
private void SaveInvoice(decimal balance) { try { if (InvoiceID > 0 && !ScreenFunctions.Update) { MessageBoxClass.ShowMessage(CommonMethods.GetError("INV_020"), false); return; } if (InvoiceID == -1 || InvoiceDetailBOList != null) { var invoiceHeaderBO = new InvoiceHeaderBO(); string invoiceNumber = string.Empty; if (textBoxInvoiceNumber.Text == "New") { invoiceNumber="INV00000000000000"; } else { invoiceNumber = textBoxInvoiceNumber.Text.Trim(); } invoiceHeaderBO.InvoiceID = InvoiceID; invoiceHeaderBO.InvoiceNumber = invoiceNumber; invoiceHeaderBO.CustomerID = 1; invoiceHeaderBO.ReceivedAmount = numericUpDownAmount.Value; invoiceHeaderBO.Balance = balance; invoiceHeaderBO.StatusID = (int)CommonEnums.InvoiceStatus.Saved; invoiceHeaderBO.CreatedUser = Common.User.UserId; invoiceHeaderBO.Total = 0; int invID = -1; bool result = new InvoiceDAL().SaveInvoice(invoiceHeaderBO, InvoiceDetailBOList, ref invoiceNumber, ref invID); InvoiceID = invID; if (result) { textBoxInvoiceNumber.Text = invoiceNumber; MessageBoxClass.ShowMessage(CommonMethods.GetError("SAL_001"), false); PrintReceipt(); ChangeStatus(); } else { MessageBoxClass.ShowMessage(CommonMethods.GetError("SAL_002"), false); } } else { MessageBoxClass.ShowMessage(CommonMethods.GetError("SAL_007"), false); } } catch (SqlException ex) { MessageBoxClass.ShowMessage(ex.Message, true); } catch { MessageBoxClass.ShowMessage(CommonMethods.GetError("SAL_002"), true); } }
private void ChangeStatus() { try { var invoiceHeaderBO = new InvoiceHeaderBO(); invoiceHeaderBO.InvoiceID = InvoiceID; invoiceHeaderBO.InvoiceNumber = textBoxInvoiceNumber.Text.Trim(); invoiceHeaderBO.CustomerID = 1; invoiceHeaderBO.StatusID = (int)CommonEnums.InvoiceStatus.Printed; invoiceHeaderBO.CreatedUser = Common.User.UserId; invoiceHeaderBO.Total = 0; new InvoiceDAL().SaveInvoiceStatus(invoiceHeaderBO); } catch { MessageBoxClass.ShowMessage(CommonMethods.GetError("U_007"), true); } }
private void buttonRefund_Click(object sender, EventArgs e) { try { if ((int)CommonEnums.InvoiceStatus.Refunded != InvoiceStatusID) { var invoiceHeaderBO = new InvoiceHeaderBO(); invoiceHeaderBO.InvoiceID = InvoiceID; invoiceHeaderBO.InvoiceNumber = textBoxInvoiceNumber.Text.Trim(); invoiceHeaderBO.CustomerID = 1; invoiceHeaderBO.StatusID = (int)CommonEnums.InvoiceStatus.Refunded; invoiceHeaderBO.CreatedUser = Common.User.UserId; invoiceHeaderBO.Total = 0; bool result = new InvoiceDAL().SaveInvoiceStatus(invoiceHeaderBO); if (result) { MessageBoxClass.ShowMessage(CommonMethods.GetError("SAL_005"), false); IsRefunded = true; PrintReceipt(); IsRefunded = false; buttonNew_Click(null, null); } else { MessageBoxClass.ShowMessage(CommonMethods.GetError("SAL_006"), false); } } else { MessageBoxClass.ShowMessage(CommonMethods.GetError("SAL_009"), false); } } catch { MessageBoxClass.ShowMessage(CommonMethods.GetError("SAL_006"), true); } }