private void tsmiPayEdit_Click(object sender, EventArgs e)
{
if (dgvAllPay.Rows.Count > 0)
{
Int16 PayID = Convert.ToInt16(dgvAllPay.CurrentRow.Cells[0].Value);
TransactionActivity.TransactionLog TL = new TransactionActivity.TransactionLog();
DataTable dtDFPP = TL.Select(PayID);///// DFPP= Delete From Person Pay
if (dtDFPP != null)
{
frmPay fp = new frmPay();
if (dtDFPP.Rows[0]["payMethod"].ToString() == "doc")
{
//frmCheck FC = new frmCheck();
//FC.PersonalId = Convert.ToInt16(CurrentPesonalID);
//FC.ShowDialog(this);
fp.Payis = "cheque";
}
else if (dtDFPP.Rows[0]["payMethod"].ToString() == "cash")
{
fp.Payis = "cash";
}
fp.CurrentPesonalID = Convert.ToDecimal(CurrentPesonalID);
fp.mode = "edit";
fp.PayId = Convert.ToDecimal(dgvAllPay.CurrentRow.Cells[0].Value);
fp.Text = "اصلاح پرداختی";
fp.ShowDialog(this);
}
}
}
private void btnOKEdit_Click(object sender, EventArgs e)
{
string query = " `id` ='" + Convert.ToInt16(strid) + "'";
string change = "`id` = '" + Convert.ToInt16(strid) + "'";
if (CustomerNo_change)
{
change += " , `CustumerNo` = '" + Convert.ToInt32(CustomerNo.Text) + "'";
}
if (dateTimeSaresid_change)
{
change += " , `t_saresid` = '" + txtChequeDate.Text + "'";
}
//if (dateTimeDaryaft_change)
//{
// change += " , `t_sodor` = '" + dateTimeDaryaft.Value.ToString() + "'";
//}
if (txtCHvajhe_change)
{
change += " , `dar_vajhe` = '" + txtCHvajhe.Text + "'";
}
if (txtCHcost_change)
{
change += " , `mablagh` = '" + Convert.ToDouble(txtCHcost.Text) + "'";
}
if (txtCHowner_change)
{
change += " , `saheb_hesab` = '" + txtCHowner.Text + "'";
}
if (txtCHnumber_change)
{
change += " , `serail_chek` = '" + txtCHnumber.Text + "'";
}
if (txtCHbank_change)
{
change += " , `bank` = '" + txtCHbank.Text + "'";
}
TransactionActivity.TransactionLog TL = new TransactionActivity.TransactionLog();
TL.Edit("پرداخت چک با شماره سریال:" + OldSN + " ", "پرداخت چک با شماره سریال:" + txtCHnumber.Text + " ", OldCustomerNo, Convert.ToDecimal(CustomerNo.Text), Convert.ToDouble(txtCHcost.Text));
//MessageBox.Show(change+"::::"+query);
change += " , `typeCheck` = '" + (Convert.ToInt16(rdbGet.Checked ? false : rdbPay.Checked)).ToString() + "'";
//change += ;
ch.edit_chek(query, change);
btnAddchek.Enabled = true;
btnReload.Enabled = true;
btnSearch.Enabled = true;
btnCancelEdit.Enabled = false;
btnOKEdit.Enabled = false;
refresh_page();
}
private void calcPesonalAccountStatus()
{
TransactionActivity.TransactionLog TL = new TransactionActivity.TransactionLog();
//string totDueQuery = "";
string totDueQuery = TL.GetAllSell(cSC.ID).ToString();// "SELECT SUM( `ItemPrice` * `itemCount` ) AS totBuy FROM `invoicedetails`WHERE `InvoiceNo`IN (SELECT `InvoiceId`FROM `invoice` WHERE `InvoiceUserId` = '" + cSC.ID + "')AND `itemCount` != '0'";
DataTable dtcpas = GS.db.Query(totDueQuery);
decimal CPI = Convert.ToDecimal(cSC.ID);
txtTotBuy.Text = GS.nf(TL.CalcPersonalPriceOfBuy(CPI).ToString());
txtTotPay.Text = GS.nf((TL.CalcPersonalPriceOfCashPay(CPI) + TL.CalcPersonalPriceOfChequePay(CPI)).ToString());
//txtOldDue.Text = GS.nf(TL.CalcPersonalPriceOfOldPay(CPI).ToString());
txtOldDue.Text = GS.nf(TL.CalcPersonalPriceOfOldRemainAccount(CPI).ToString());
dgvReaminAccountList.AutoGenerateColumns = false;
dgvReaminAccountList.DataSource = TL.GetOldRemainAccountList(CPI);
if (dtcpas != null || txtOldDue.Text == "0")
{
double TotBuy = Convert.ToDouble(txtTotBuy.Text.ToString());
double TotOldDue = Convert.ToDouble(txtOldDue.Text.ToString());
double TotPay = Convert.ToDouble(txtTotPay.Text.ToString());
double TotSell = Convert.ToDouble(TL.GetAllSell(cSC.ID));
double pas = (TotBuy + TotOldDue) - TotPay - TotSell;
if (pas < 0)
{
txtBestankar.Text = GS.nf(Convert.ToString(pas * (-1)));
txtDue.Text = "0";
}
else
{
txtBestankar.Text = "0";
txtDue.Text = GS.nf(Convert.ToString(pas));
}
dgvAllInvoiceList.AutoGenerateColumns = false;
dgvAllInvoiceList.DataSource = GS.db.Query("SELECT * FROM `invoice` WHERE `InvoiceUserId`='" + cSC.ID + "' AND `type`='" + Invoice.InvoiceType.sell + "'");
dgvAllInvoiceList.Refresh();
dgvPish.AutoGenerateColumns = false;
dgvPish.DataSource = GS.db.Query("SELECT * FROM `invoice` WHERE `InvoiceUserId`='" + cSC.ID + "' AND `type`='" + Invoice.InvoiceType.proforma + "'");
dgvPish.Refresh();
dgvAllPay.AutoGenerateColumns = false;
dgvAllPay.DataSource = GS.db.Query("SELECT * FROM `accounting` WHERE `personalId`='" + cSC.ID + "' AND `payType` ='pay'");
}
else
{
dgvAllInvoiceList.DataSource = null;
}
}
private void tsmiAddDue_Click(object sender, EventArgs e)
{
if (GS.dialog.InputBox("ثبت پرداخت نقدی", "مبلغ مانده حساب این شخص چقدر است؟", "") == DialogResult.OK)
{
if (GS.dialog.InputValue.Length > 3)
{
try
{
var tl = new TransactionActivity.TransactionLog();
//////////// NT= New Transaction
TransactionActivity.Transaction NT = new TransactionActivity.Transaction();
////////// TTO= Transaction Type Order
TransactionActivity.TransactionType TTO = TransactionActivity.TransactionType.RemainAccount;
///////// TMT= Transaction Method Type
TransactionActivity.TransactionMethod TMT = TransactionActivity.TransactionMethod.Old;
//////// set transaction Price
NT.Amount = Convert.ToDecimal(GS.dialog.InputValue);
/////// personal id for this transaction
NT.PersonalID = Convert.ToDecimal(CurrentPesonalID);
NT.Method = TMT;
NT.Description = "ثبت مانده حساب";
NT.Time = DateTime.Now.ToShortTimeString();
NT.Date = GS.dateManager.GetCurrentPersianDate();
NT.Type = TTO;
NT.RemainAccount = tl.RemainAccount(Convert.ToDecimal(CurrentPesonalID)) + Convert.ToDecimal(NT.Amount);
byte DFF = Convert.ToByte(TransactionActivity.TransactionStatus.Bedehkar);
NT.Status = DFF;
tl.NewTransaction(NT);
MessageBox.Show("ثبت مانده حساب با موفقیت انجام شد.");
}
catch
{
//PayAmount = 0;
MessageBox.Show("لطفا فقط عدد وارد کنید.");
}
}
}
}
private void tsmiOldRemainaccountDelete_Click(object sender, EventArgs e)
{
if (dgvReaminAccountList.Rows.Count > 0)
{
TransactionActivity.TransactionLog TL = new TransactionActivity.TransactionLog();
DataTable dtRemainAccount = TL.Select(Convert.ToDecimal(dgvReaminAccountList.CurrentRow.Cells[0].Value));
if (dtRemainAccount.Rows.Count == 1)
{
string QMessage = "مانده حساب با مبلغ" + GS.nf(dtRemainAccount.Rows[0]["payPrice"].ToString()) + " و با شرح ( " + dtRemainAccount.Rows[0]["payAbout"].ToString() + " ) حذف شود؟";
if (GS.dialog.Question("حذف مانده حساب", QMessage) == DialogResult.OK)
{
decimal TLId = Convert.ToDecimal(dtRemainAccount.Rows[0]["id"].ToString());
TL.delete(TLId);
SelectPersonal();
}
}
}
}
private void tsmiDeletePay_Click(object sender, EventArgs e)
{
try
{
Int16 PayID = Convert.ToInt16(dgvAllPay.CurrentRow.Cells[0].Value);
DataTable dtDFPP = new DataTable();///// DFPP= Delete From Person Pay
dtDFPP = GS.db.Query("SELECT * FROM `accounting` WHERE `id`='" + PayID.ToString() + "'");
if (dtDFPP != null)
{
string QMessage = "میخواهید پرداختی شخص با مبلغ " + GS.nf(dtDFPP.Rows[0]["payPrice"].ToString()) + " و با شرح ( " + dtDFPP.Rows[0]["payAbout"].ToString() + " )را حذف کنید؟";
if (GS.dialog.Question("حذف پرداختی ها", QMessage) == DialogResult.OK)
{
if (dtDFPP.Rows[0]["payMethod"].ToString() == "doc")
{
if (GS.dialog.Question("حذف چک پرداختی مشتری", "پرداخت از نوع چک می باشد آیا میخواهید آن را حذف کنید؟") == DialogResult.OK)
{
chek ZSMC = new chek();
// string CheckSerial = Regex.Match(dtDFPP.Rows[0]["payAbout"].ToString(), @"\d").Value.ToString();
string CheckSerial = dtDFPP.Rows[0]["payAbout"].ToString();
string CSN = Regex.Replace(CheckSerial, @"\D", "").ToString();
//MessageBox.Show(CSN);
ZSMC.delet_chek(CSN);
TransactionActivity.TransactionLog TL = new TransactionActivity.TransactionLog();
TL.delete(PayID);
SelectPersonal();
}
}
else
{
TransactionActivity.TransactionLog TL = new TransactionActivity.TransactionLog();
TL.delete(PayID);
SelectPersonal();
}
}
}//////// End Validate Result of selected row from pay list
}
catch { }
}
private void btnImportPersonalRemainAccount_Click(object sender, EventArgs e)
{
Clients m = new Clients();
List <Clients.Client> mm = m.getClients("");
foreach (Clients.Client c in mm)
{
}
return;
var myDataTable = new DataTable();
openFileDialog1.ShowDialog(this);
if (string.IsNullOrEmpty(openFileDialog1.FileName))
{
MessageBox.Show("هیچ فایلی انتخاب نشده است.");
return;
}
string dbFile = openFileDialog1.FileName;
using (var conection = new OleDbConnection("Provider=Microsoft.JET.OLEDB.4.0;" + "data source=" + dbFile + ";"))
using (DataTable dt = new DataTable())
{
string query = "Select * From `tblmembers`";
using (OleDbDataAdapter adapter = new OleDbDataAdapter(query, conection))
{
adapter.Fill(dt);
}
foreach (DataRow dr in dt.Rows)
{
string AllDue = dr["Alldue"].ToString();
string AllPay = dr["TotPayment"].ToString();
decimal Result = Convert.ToDecimal(AllDue) - Convert.ToDecimal(AllPay);
if (Result > 0)
{
MessageBox.Show(dr["mname"].ToString() + " | " + Result.ToString());
}
//}
// return;
var tl = new TransactionActivity.TransactionLog();
//////////// NT= New Transaction
TransactionActivity.Transaction NT = new TransactionActivity.Transaction();
////////// TTO= Transaction Type Order
TransactionActivity.TransactionType TTO = TransactionActivity.TransactionType.RemainAccount;
///////// TMT= Transaction Method Type
TransactionActivity.TransactionMethod TMT = TransactionActivity.TransactionMethod.Old;
//////// set transaction Price
NT.Amount = Convert.ToDecimal("");
/////// personal id for this transaction
NT.PersonalID = Convert.ToDecimal("");
NT.Method = TMT;
NT.Description = "مانده حساب از سال مالی گذشته";
NT.Time = DateTime.Now.ToShortTimeString();
NT.Date = GS.dateManager.GetCurrentPersianDate();
NT.Type = TTO;
NT.RemainAccount = tl.RemainAccount(Convert.ToDecimal("")) + Convert.ToDecimal(NT.Amount);
byte DFF = Convert.ToByte(TransactionActivity.TransactionStatus.Bedehkar);
NT.Status = DFF;
tl.NewTransaction(NT);
}
}
}
private void btnAddchek_Click(object sender, EventArgs e)
{
//if (CustomerNo.Text != "" && dateTimeSaresid.Value.ToString() != "" && dateTimeDaryaft.Value.ToString() != "" && txtCHvajhe.Text != "" && txtCHcost.Text != "" && txtCHowner.Text != "" && txtCHnumber.Text != "" && txtCHbank.Text != "")
if (CustomerNo.Text != "" && txtChequeDate.Text != "" && GS.dateManager.pdp.GetDate() != "" && txtCHvajhe.Text != "" && txtCHcost.Text != "" && txtCHowner.Text != "" && txtCHnumber.Text != "" && txtCHbank.Text != "")
{
if (check_int(CustomerNo.Text))
{
if (check_Double(txtCHcost.Text))
{
string payType = "";
////////// TTP= Transaction Type Pay
TransactionActivity.TransactionType TTP;
byte TS;
var tl = new TransactionActivity.TransactionLog();
//////////// NT= New Transaction
TransactionActivity.Transaction NT = new TransactionActivity.Transaction();
string Description = "";
byte Dff = 0;
//MessageBox.Show("BB: " + Dff);
if (rdbGet.Checked == true)
{
Dff = Convert.ToByte(TransactionActivity.TransactionStatus.Bestankar);
TTP = TransactionActivity.TransactionType.pay;
TS = Dff;//TransactionActivity.TransactionStatus.Bestankar;
payType = "get";
chType = false;
Description = "پرداخت چک با شماره:" + txtCHnumber.Text + "و تاریخ :" + txtChequeDate.Text;
NT.RemainAccount = tl.RemainAccount(Convert.ToDecimal(CustomerNo.Text)) - Convert.ToDecimal(txtCHcost.Text);
}
else
{
Dff = Convert.ToByte(TransactionActivity.TransactionStatus.Bedehkar);
TTP = TransactionActivity.TransactionType.get;
TS = Dff;//TransactionActivity.TransactionStatus.Bedehkar;
payType = "pay";
chType = true;
Description = "دریافت چک با شماره سریال:" + txtCHnumber.Text + " ";
NT.RemainAccount = tl.RemainAccount(Convert.ToDecimal(CustomerNo.Text)) + Convert.ToDecimal(txtCHcost.Text);
}
int AddCheck = ch.add_to_chek(Convert.ToInt32(CustomerNo.Text), txtChequeDate.Text, GS.dateManager.pdp.GetDate(), txtCHvajhe.Text, Convert.ToDouble(txtCHcost.Text), txtCHowner.Text, txtCHnumber.Text, txtCHbank.Text, chType);
switch (AddCheck)
{
case 1:
//if (PersonalId > 0)
// Description = "پرداخت چک با شماره سریال:"+txtCHnumber.Text;
//else
// Description = "";
//PayAmount = Convert.ToDecimal(GS.dialog.InputValue);
///////// TMT= Transaction Method Type
TransactionActivity.TransactionMethod TMT = TransactionActivity.TransactionMethod.doc;
NT.Amount = Convert.ToDecimal(txtCHcost.Text);
NT.PersonalID = Convert.ToDecimal(CustomerNo.Text);
NT.Method = TMT;
NT.Description = Description;
NT.Time = DateTime.Now.ToShortTimeString();
NT.Date = GS.dateManager.GetCurrentPersianDate();
NT.Type = TTP;
NT.Status = TS;
tl.NewTransaction(NT);
//string payQuery = "INSERT INTO `accounting` (`personalId`,`payPrice`,`payAbout`,`payMethod`,`payType`,`payTime`,`payDate`) " +
//"VALUES(" +
//"'" + CustomerNo.Text + "'" +
//",'" + txtCHcost.Text + "'" +
//",'"+Description+"'" +
//",'doc'" +
//",'"+payType+"'" +
//",'" + DateTime.Now.ToShortTimeString() + "'" +
//",'" + GS.GetCurrentDate() + "'" +
//")";
//GS.db.Query(payQuery);
refresh_page();
if (PersonalId > 0)
{
this.Close();
}
break;
case 2:
MessageBox.Show("شماره سریال چک تکراری می باشد. چکی با این شماره سریال در سیستم ثبت شده است.");
break;
case 0:
MessageBox.Show("ثبت چک با مشکل مواجه شده است! لطفا مجددا تلاش کنید.");
break;
}
}
else
{
MessageBox.Show("مبلغ صحیح وارد نشده");
}
}
else
{
MessageBox.Show("شماره مشتری صحیح وارد نشده");
}
}
else
{
MessageBox.Show("تمام فیلد ها را پر کنید");
}
}
