public bool Savegenaralreceipt(RdReceiptDTO ObjRdReceiptDTO, NpgsqlTransaction trans, out string Receiptid)
{
bool IsSaved = false;
StringBuilder sbQuery = new StringBuilder();
AccountingTransactionsDAL Accontstrans = new AccountingTransactionsDAL();
try
{
GeneralreceiptDTO Objgeneralreceipt = new GeneralreceiptDTO();
Objgeneralreceipt.preceiptid = "";
Objgeneralreceipt.ppartyid = ObjRdReceiptDTO.pConid;
Objgeneralreceipt.ppartyreferenceid = ObjRdReceiptDTO.pContactid;
Objgeneralreceipt.ppartyreftype = "Recurring Deposit";
Objgeneralreceipt.ppartyname = ObjRdReceiptDTO.pMembername;
Objgeneralreceipt.preceiptdate = ObjRdReceiptDTO.pReceiptdate.ToString();
Objgeneralreceipt.pmodofreceipt = ObjRdReceiptDTO.pModeofreceipt;
Objgeneralreceipt.ptotalreceivedamount = Convert.ToDecimal(ObjRdReceiptDTO.pReceivedamount);
Objgeneralreceipt.pnarration = ObjRdReceiptDTO.pNarration;
Objgeneralreceipt.pbankname = ObjRdReceiptDTO.pBank;
Objgeneralreceipt.pBankId = ObjRdReceiptDTO.pBankid;
Objgeneralreceipt.pdepositbankid = ObjRdReceiptDTO.pdepositbankid;
Objgeneralreceipt.pbranchname = ObjRdReceiptDTO.pBranch;
Objgeneralreceipt.ptranstype = ObjRdReceiptDTO.pTranstype;
Objgeneralreceipt.ptypeofpayment = ObjRdReceiptDTO.ptypeofpayment;
Objgeneralreceipt.pChequenumber = ObjRdReceiptDTO.pChequenumber;
if (ObjRdReceiptDTO.ptypeofpayment == "Debit Card")
{
Objgeneralreceipt.pchequedate = ObjRdReceiptDTO.pReceiptdate.ToString();
}
else if (ObjRdReceiptDTO.ptypeofpayment == "Credit Card")
{
Objgeneralreceipt.pchequedate = ObjRdReceiptDTO.pReceiptdate.ToString();
}
else
{
Objgeneralreceipt.pchequedate = ObjRdReceiptDTO.pchequedate;
}
Objgeneralreceipt.pCardNumber = ObjRdReceiptDTO.pCardnumber;
Objgeneralreceipt.pUpiid = ObjRdReceiptDTO.pUpiid;
Objgeneralreceipt.pCreatedby = ObjRdReceiptDTO.pCreatedby;
List <ReceiptsDTO> preceiptslist = new List <ReceiptsDTO>();
ReceiptsDTO objpreceipts = new ReceiptsDTO();
objpreceipts.psubledgerid = ObjRdReceiptDTO.pSubledgerid;
objpreceipts.pledgername = "Recurring Deposit";
objpreceipts.ptdsamountindividual = Convert.ToDecimal(ObjRdReceiptDTO.pReceivedamount);
objpreceipts.pamount = Convert.ToDecimal(ObjRdReceiptDTO.pReceivedamount);
preceiptslist.Add(objpreceipts);
Objgeneralreceipt.preceiptslist = preceiptslist;
if (Accontstrans.CallsaveGeneralReceipt(Objgeneralreceipt, trans, out Receiptid))
{
IsSaved = true;
}
}
catch (Exception ex)
{
throw ex;
}
return(IsSaved);
}
protected void function_insert_Click(object sender, EventArgs e)
{
ReceiptsDTO RTO = new ReceiptsDTO();
RTO.ID_TYPE = input_Id_Type.Text;
RTO.ID_AGENCY = input_Id_Agency.Text;
string[] date_ind = input_Date_Ind.Text.Split('/');
string[] date_receipts = input_Date_Receipts.Text.Split('/');
RTO.DATE_IND = date_ind[1] + "/" + date_ind[0] + "/" + date_ind[2];
RTO.DATE_RECEIPTS = date_receipts[1] + "/" + date_receipts[0] + "/" + date_receipts[2];
RTO.PAYMENT = float.Parse(input_Payment.Text);
if (RBL.Insert(RTO) == true)
{
MessageBox("Thêm thành công", "Receipts.aspx");
uploadData();
}
else
{
MessageBox("Lỗi hệ thống", "Receipts.aspx");
uploadData();
}
}
public ReceiptsEditFm(Utils.Operation operation, ReceiptsDTO receipt)
{
InitializeComponent();
LoadOrdersData();
this.operation = operation;
receiptsBS.DataSource = Item = receipt;
quantityTBox.DataBindings.Add("EditValue", receiptsBS, "Quantity", true, DataSourceUpdateMode.OnPropertyChanged);
unitPriceTBox.DataBindings.Add("EditValue", receiptsBS, "UnitPrice", true, DataSourceUpdateMode.OnPropertyChanged);
totalPriceTBox.DataBindings.Add("EditValue", receiptsBS, "TotalPrice", true, DataSourceUpdateMode.OnPropertyChanged);
dateProductionEdit.DataBindings.Add("EditValue", receiptsBS, "DateProduction", true, DataSourceUpdateMode.OnPropertyChanged);
dateExpirationEdit.DataBindings.Add("EditValue", receiptsBS, "DateExpiration", true, DataSourceUpdateMode.OnPropertyChanged);
materialsGridEdit.DataBindings.Add("EditValue", receiptsBS, "MaterialId", true, DataSourceUpdateMode.OnPropertyChanged);
materialsGridEdit.Properties.DataSource = materialsService.GetMaterials();
materialsGridEdit.Properties.ValueMember = "MaterialId";
materialsGridEdit.Properties.DisplayMember = "Name";
unitEdit.DataBindings.Add("EditValue", receiptsBS, "UnitId", true, DataSourceUpdateMode.OnPropertyChanged);
unitEdit.Properties.DataSource = unitsService.GetUnits();
unitEdit.Properties.ValueMember = "UnitId";
unitEdit.Properties.DisplayMember = "UnitLocalName";
if (this.operation == Utils.Operation.Add)
{
materialsGridEdit.EditValue = 0;
unitEdit.EditValue = 0;
materialsGridEdit.Text = "[нет данных]";
((ReceiptsDTO)Item).DateProduction = null;
((ReceiptsDTO)Item).DateExpiration = null;
}
}
public bool Delete(ReceiptsDTO ROP)
{
try
{
R_DAL.Delete(ROP);
}
catch (Exception ex)
{
return(false);
}
return(true);
}
// function CRUD
public bool Insert(ReceiptsDTO RTO)
{
try
{
R_DAL.Insert(RTO);
}
catch (Exception ex)
{
return(false);
}
return(true);
}
public bool Savegenaralreceipt(SaveEmireceiptsDTO SaveEmireceiptslist, NpgsqlTransaction trans, out string Receiptid)
{
bool IsSaved = false;
StringBuilder sbQuery = new StringBuilder();
AccountingTransactionsDAL Accontstrans = new AccountingTransactionsDAL();
try
{
GeneralreceiptDTO Objgeneralreceipt = new GeneralreceiptDTO();
Objgeneralreceipt.preceiptid = "";
Objgeneralreceipt.ppartyid = SaveEmireceiptslist.pConid;
Objgeneralreceipt.ppartyreftype = "APPLICANT";
Objgeneralreceipt.ppartyreferenceid = SaveEmireceiptslist.pContactid;
Objgeneralreceipt.ppartyname = SaveEmireceiptslist.pApplicantname;
Objgeneralreceipt.preceiptdate = SaveEmireceiptslist.pReceiptdate.ToString();
Objgeneralreceipt.pmodofreceipt = SaveEmireceiptslist.pModeofreceipt;
Objgeneralreceipt.ptotalreceivedamount = Convert.ToDecimal(SaveEmireceiptslist.pTotalreceived);
Objgeneralreceipt.pnarration = SaveEmireceiptslist.pNarration;
Objgeneralreceipt.pbankname = SaveEmireceiptslist.pBank;
Objgeneralreceipt.pBankId = SaveEmireceiptslist.pBankid;
Objgeneralreceipt.pdepositbankid = SaveEmireceiptslist.pDeposibankid;
Objgeneralreceipt.pbranchname = SaveEmireceiptslist.pBranch;
Objgeneralreceipt.ptranstype = SaveEmireceiptslist.pTranstype;
Objgeneralreceipt.ptypeofpayment = SaveEmireceiptslist.pTypeofpaymentonline;
Objgeneralreceipt.pChequenumber = SaveEmireceiptslist.pChequeno;
Objgeneralreceipt.pchequedate = SaveEmireceiptslist.pTransdate;
Objgeneralreceipt.pCardNumber = SaveEmireceiptslist.pVchcardnumber;
Objgeneralreceipt.pUpiid = SaveEmireceiptslist.pUpiid;
Objgeneralreceipt.pCreatedby = SaveEmireceiptslist.pCreatedby;
List <ReceiptsDTO> preceiptslist = new List <ReceiptsDTO>();
ReceiptsDTO objpreceipts = new ReceiptsDTO();
objpreceipts.psubledgerid = SaveEmireceiptslist.pSubledgerid;
objpreceipts.pledgername = "SUNDRY DEBITORS" + "_" + SaveEmireceiptslist.pLoanname;
objpreceipts.ptdsamountindividual = Convert.ToDecimal(SaveEmireceiptslist.pTotalreceived);
objpreceipts.pamount = Convert.ToDecimal(SaveEmireceiptslist.pTotalreceived);
preceiptslist.Add(objpreceipts);
Objgeneralreceipt.preceiptslist = preceiptslist;
if (Accontstrans.CallsaveGeneralReceipt(Objgeneralreceipt, trans, out Receiptid))
{
IsSaved = true;
}
}
catch (Exception ex)
{
throw ex;
}
return(IsSaved);
}
protected void btn_delete_Click(object sender, EventArgs e)
{
ReceiptsDTO RTO = new ReceiptsDTO();
RTO.ID_TYPE = id_delete;
if (RBL.Delete(RTO) == true)
{
MessageBox("Xóa thành công", "Receipts.aspx");
}
else
{
MessageBox("Xóa không thành công", "Receipts.aspx");
}
}
public KitsFm(ReceiptsDTO receipt)
{
InitializeComponent();
receiptBS.DataSource = receipt;
receiptDTO = receipt;
receiptAcceptancesService = Program.kernel.Get <IReceiptAcceptancesService>();
orderNumberTBox.DataBindings.Add("EditValue", receiptBS, "OrderNumber");
orderDateEdit.DataBindings.Add("EditValue", receiptBS, "OrderDate");
articleTBox.DataBindings.Add("EditValue", receiptBS, "Article");
nameTBox.DataBindings.Add("EditValue", receiptBS, "Name");
quantityTBox.DataBindings.Add("EditValue", receiptBS, "Quantity");
quantityInKitTBox.EditValue = receipt.Quantity;
kitsControl.Controls["quantityInKitTBox"].Focus();
saveBtn.Enabled = false;
}
public void Delete(ReceiptsDTO ROP)
{
ConnectDB.con.Open();
try
{
SqlCommand cmd = new SqlCommand("delete_RECEIPTS", ConnectDB.con);
cmd.Parameters.Add("@ID_RECEIPTS", SqlDbType.VarChar).Value = ROP.ID_RECEIPTS;
cmd.CommandType = CommandType.StoredProcedure;
cmd.ExecuteNonQuery();
}
catch
{
throw;
}
finally
{
ConnectDB.con.Close();
}
}
private void addReceipt_()
{
using (ReceiptsEditFm receiptEditFm = new ReceiptsEditFm(Utils.Operation.Add, new ReceiptsDTO()))
{
if (receiptEditFm.ShowDialog() == System.Windows.Forms.DialogResult.OK)
{
resultDTO = receiptEditFm.Return();
receiptsGridView.BeginUpdate();
resultDTO.Changes = 1;
resultDTO.OrderId = ((OrdersDTO)Item).OrderId;
receiptsBS.Add(resultDTO);
receiptsBS.EndEdit();
receiptsGridView.EndUpdate();
}
}
receiptsGridView.BeginSummaryUpdate();
receiptsGridView.EndSummaryUpdate();
receiptsGrid.Refresh();
}
public Error.ErrorCRUD ReceiptDelete(ReceiptsDTO receipt)
{
try
{
Error.ErrorCRUD result = CanDelete(receipt.ReceiptId);
if (result == Error.ErrorCRUD.CanDelete)
{
Receipts.Delete(Receipts.GetAll().FirstOrDefault(c => c.ReceiptId == receipt.ReceiptId));
return(Error.ErrorCRUD.NoError);
}
else
{
return(result);
}
}
catch (Exception ex)
{
return(Error.ErrorCRUD.DatabaseError);
}
}
public void Insert(ReceiptsDTO RTO)
{
ConnectDB.con.Open();
try
{
SqlCommand cmd = new SqlCommand("insert_RECEIPTS", ConnectDB.con);
cmd.Parameters.Add("@ID_TYPE", SqlDbType.VarChar).Value = RTO.ID_TYPE;
cmd.Parameters.Add("@ID_AGENCY", SqlDbType.VarChar).Value = RTO.ID_AGENCY;
cmd.Parameters.Add("@DATE_IND", SqlDbType.VarChar).Value = RTO.DATE_IND;
cmd.Parameters.Add("@DATE_RECEIPTS", SqlDbType.VarChar).Value = RTO.DATE_RECEIPTS;
cmd.Parameters.Add("@PAYMENT", SqlDbType.Float).Value = RTO.PAYMENT;
cmd.CommandType = CommandType.StoredProcedure;
cmd.ExecuteNonQuery();
}
catch
{
throw;
}
finally
{
ConnectDB.con.Close();
}
}
private void editReceipt_()
{
if ((ReceiptsDTO)receiptsBS.Current != null)
{
using (ReceiptsEditFm receiptEditFm = new ReceiptsEditFm(Utils.Operation.Update, (ReceiptsDTO)receiptsBS.Current))
{
if (receiptEditFm.ShowDialog() == System.Windows.Forms.DialogResult.OK)
{
resultDTO = receiptEditFm.Return();
receiptsGridView.BeginUpdate();
if (resultDTO.Changes == null)
{
resultDTO.Changes = 2;
}
resultDTO.OrderId = ((OrdersDTO)Item).OrderId;
((ReceiptsDTO)receiptsBS.Current).OrderId = resultDTO.OrderId;
((ReceiptsDTO)receiptsBS.Current).UnitPrice = resultDTO.UnitPrice;
((ReceiptsDTO)receiptsBS.Current).TotalPrice = resultDTO.TotalPrice;
((ReceiptsDTO)receiptsBS.Current).Quantity = resultDTO.Quantity;
((ReceiptsDTO)receiptsBS.Current).MaterialId = resultDTO.MaterialId;
((ReceiptsDTO)receiptsBS.Current).Name = resultDTO.Name;
((ReceiptsDTO)receiptsBS.Current).Article = resultDTO.Article;
((ReceiptsDTO)receiptsBS.Current).UnitId = resultDTO.UnitId;
((ReceiptsDTO)receiptsBS.Current).UnitLocalName = resultDTO.UnitLocalName;
receiptsBS.EndEdit();
receiptsBS.ResetCurrentItem();
receiptsGridView.EndUpdate();
}
}
receiptsGridView.Focus();
receiptsGrid.Refresh();
receiptsGridView.BeginSummaryUpdate();
receiptsGridView.EndSummaryUpdate();
}
}
private void createKitsBtn_ItemClick(object sender, DevExpress.XtraBars.ItemClickEventArgs e)
{
if (receiptAcceptancesBS.List.Count == 0)
{
int currReceiptId = ((ReceiptsForAcceptanceDTO)receiptsBS.Current).ReceiptId;
ReceiptsDTO model = new ReceiptsDTO()
{
ReceiptId = ((ReceiptsForAcceptanceDTO)receiptsBS.Current).ReceiptId,
OrderId = ((ReceiptsForAcceptanceDTO)receiptsBS.Current).OrderId,
Article = ((ReceiptsForAcceptanceDTO)receiptsBS.Current).Article,
Name = ((ReceiptsForAcceptanceDTO)receiptsBS.Current).Name,
OrderNumber = ((ReceiptsForAcceptanceDTO)receiptsBS.Current).OrderNumber,
OrderDate = ((ReceiptsForAcceptanceDTO)receiptsBS.Current).OrderDate,
Quantity = ((ReceiptsForAcceptanceDTO)receiptsBS.Current).Quantity
};
using (KitsFm kitsFm = new KitsFm(model))
{
if (kitsFm.ShowDialog() == System.Windows.Forms.DialogResult.OK)
{
receiptsGridView.BeginDataUpdate();
LoadReceiptsData((int)statusItem.EditValue);
receiptsGridView.EndDataUpdate();
int handle = receiptsGridView.LocateByValue("ReceiptId", currReceiptId);
receiptsGridView.FocusedRowHandle = handle;
}
}
}
else
{
MessageBox.Show("Комплектация уже существует! Для создания новой комплектации удалите текущую!", "Создание комплектов", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
}
public void ReceiptUpdate(ReceiptsDTO receipt)
{
var eGroup = Receipts.GetAll().SingleOrDefault(c => c.ReceiptId == receipt.ReceiptId);
Receipts.Update((mapper.Map <ReceiptsDTO, Receipts>(receipt, eGroup)));
}
public bool Savegenaralreceipt(MemberReceiptDTO ObjMemberReceiptDTO, NpgsqlTransaction trans, out string Receiptid)
{
bool IsSaved = false;
StringBuilder sbQuery = new StringBuilder();
AccountingTransactionsDAL Accontstrans = new AccountingTransactionsDAL();
try
{
GeneralreceiptDTO Objgeneralreceipt = new GeneralreceiptDTO();
Objgeneralreceipt.preceiptid = "";
Objgeneralreceipt.ppartyid = ObjMemberReceiptDTO.pConid;
Objgeneralreceipt.ppartyreferenceid = ObjMemberReceiptDTO.pContactid;
Objgeneralreceipt.ppartyreftype = "Member Receipt";
Objgeneralreceipt.ppartyname = ObjMemberReceiptDTO.pMembername;
Objgeneralreceipt.preceiptdate = ObjMemberReceiptDTO.pReceiptdate.ToString();
Objgeneralreceipt.pmodofreceipt = ObjMemberReceiptDTO.pModeofreceipt;
Objgeneralreceipt.ptotalreceivedamount = Convert.ToDecimal(ObjMemberReceiptDTO.pReceivedamount);
Objgeneralreceipt.pnarration = ObjMemberReceiptDTO.pNarration;
Objgeneralreceipt.pbankname = ObjMemberReceiptDTO.pBank;
Objgeneralreceipt.pBankId = ObjMemberReceiptDTO.pBankid;
Objgeneralreceipt.pdepositbankid = ObjMemberReceiptDTO.pdepositbankid;
Objgeneralreceipt.pbranchname = ObjMemberReceiptDTO.pBranch;
Objgeneralreceipt.ptranstype = ObjMemberReceiptDTO.pTranstype;
Objgeneralreceipt.ptypeofpayment = ObjMemberReceiptDTO.ptypeofpayment;
Objgeneralreceipt.pChequenumber = ObjMemberReceiptDTO.pChequenumber;
if (ObjMemberReceiptDTO.ptypeofpayment == "Debit Card")
{
Objgeneralreceipt.pchequedate = ObjMemberReceiptDTO.pReceiptdate.ToString();
}
else if (ObjMemberReceiptDTO.ptypeofpayment == "Credit Card")
{
Objgeneralreceipt.pchequedate = ObjMemberReceiptDTO.pReceiptdate.ToString();
}
else
{
Objgeneralreceipt.pchequedate = ObjMemberReceiptDTO.pchequedate;
}
Objgeneralreceipt.pCardNumber = ObjMemberReceiptDTO.pCardnumber;
Objgeneralreceipt.pUpiid = ObjMemberReceiptDTO.pUpiid;
Objgeneralreceipt.pCreatedby = ObjMemberReceiptDTO.pCreatedby;
string membername = ObjMemberReceiptDTO.pMembername;
string membercode = ObjMemberReceiptDTO.pMembercode;
string membernamecode = membercode + "_" + membername;
List <ReceiptsDTO> preceiptslist = new List <ReceiptsDTO>();
ReceiptsDTO objpreceipts = new ReceiptsDTO();
Int64 membershipaccountid = Convert.ToInt64(NPGSqlHelper.ExecuteScalar(trans, CommandType.Text, "select accountid from tblmstaccounts where accountname in('MEMBERSHIP FEE') AND chracctype='2' and statusid=" + Convert.ToInt32(Status.Active) + ";"));
int subledgerid = Convert.ToInt32(NPGSqlHelper.ExecuteScalar(trans, CommandType.Text, "select insertaccounts('" + membernamecode + "', " + membershipaccountid + ", '3'," + ObjMemberReceiptDTO.pCreatedby + ")"));
objpreceipts.psubledgerid = subledgerid;
objpreceipts.pledgername = membernamecode;
objpreceipts.ptdsamountindividual = Convert.ToDecimal(ObjMemberReceiptDTO.pReceivedamount);
objpreceipts.pamount = Convert.ToDecimal(ObjMemberReceiptDTO.pReceivedamount);
preceiptslist.Add(objpreceipts);
Objgeneralreceipt.preceiptslist = preceiptslist;
if (Accontstrans.CallsaveGeneralReceipt(Objgeneralreceipt, trans, out Receiptid))
{
IsSaved = true;
}
}
catch (Exception ex)
{
throw ex;
}
return(IsSaved);
}
public int ReceiptCreate(ReceiptsDTO receipt)
{
var createrecord = Receipts.Create(mapper.Map <Receipts>(receipt));
return((int)createrecord.ReceiptId);
}
