protected void btnInsert_Click(object sender, EventArgs e)
{
IncomeDTO idto = new IncomeDTO();
int idgdv = int.Parse(drDSGDV.SelectedItem.Value.ToString());
idto.MaGDV = idgdv;
string thamchieu = drDSClaimInvoice.SelectedItem.ToString();
bool kttrung = idao.KiemTraTrung(thamchieu, idgdv);
int maInvoice = int.Parse(drDSClaimInvoice.SelectedItem.Value.ToString());
idto.MaInvoice = maInvoice;
idto.MaClaim = thamchieu;
float feeissue = float.Parse(txtPhiCG.Text);
idto.IssueFee = feeissue;
float feereal = float.Parse(txtPhiTT.Text);
idto.RealFee = feereal;
float percentage = feereal / feeissue;
idto.Percentage = percentage;
float magicincome = ts.CyberIncomeGDV(thamchieu, idgdv);
idto.CyberIncome = magicincome;
float realincome = percentage * magicincome / 4;
idto.RealIncome = realincome;
if (kttrung == false)
{
bool kq = idao.Insert(idto);
if (kq == true)
loadIncomeClaim(thamchieu);
lblThongBao.Text = "";
}
else
lblThongBao.Text = "It was exist!";
}
protected void btnLuu_Click(object sender, EventArgs e)
{
InvoiceDTO invdto = new InvoiceDTO();
invdto.MaClaim = txtId_claim.Text;
invdto.NoInvoice = txtInvoice.Text;
invdto.GrandTotal = float.Parse(txtTongTien.Text);
invdto.DateIssue = DateTime.Parse(txtIssueDate.Text);
bool kq = inv.Insert(invdto);
if (kq == true)
{
IncomeDTO idto = new IncomeDTO();
//int idgdv = int.Parse(drDSGDV.SelectedItem.Value.ToString());
int idgdv = 0;
//idto.MaGDV = 0;
string thamchieu = txtId_claim.Text;
//bool kttrung = idao.KiemTraTrung(thamchieu, idgdv);
DataTable dt = ts.ListIDGDV(thamchieu);
List<string> ListID = new List<string>();
if(dt.Rows.Count>0)
{
//foreach (DataRow dr in dt.Rows)
for(int t=0;t<dt.Rows.Count;t++)
{
ListID.Add(dt.Rows[t][0].ToString());
}
}
//int maLA = int.Parse(ListID[0].ToString());
//foreach (DataRow ID_GDV in ListID)
for(int i=0; i<ListID.Count; i++)
{
//Response.Write("<script>alert('" + ListID[i].ToString()+ "');</script>");
idgdv = int.Parse(ListID[i].ToString());
idto.MaGDV = idgdv;
int maInvoice = inv.SelectMaMax();
idto.MaInvoice = maInvoice;
idto.MaClaim = thamchieu;
float feeissue = float.Parse(txtIssueFee.Text);
idto.IssueFee = feeissue;
float feereal = float.Parse(txtRealfee.Text);
idto.RealFee = feereal;
float percentage = feereal / feeissue;
idto.Percentage = percentage;
float magicincome = ts.CyberIncomeGDV(thamchieu, idgdv);
idto.CyberIncome = magicincome;
float realincome = percentage * magicincome / 4;
idto.RealIncome = realincome;
bool them = ic.Insert(idto);
}
Session["ThamChieu"] = thamchieu;
Response.Redirect("~/Pages/detailincome.aspx");
}
}
public bool Insert(IncomeDTO i)
{
string sql = "sp_Income_Insert";
List<SqlParameter> ds = new List<SqlParameter>();
ds.Add(new SqlParameter("@id_invoice",i.MaInvoice));
ds.Add(new SqlParameter("@issuefee",i.IssueFee));
ds.Add(new SqlParameter("@realfee",i.RealFee));
ds.Add(new SqlParameter("@percentage",i.Percentage));
ds.Add(new SqlParameter("@cyberincome",i.CyberIncome));
ds.Add(new SqlParameter("@realincome",i.RealIncome));
ds.Add(new SqlParameter("@id_gdv",i.MaGDV));
bool kq = false;
kq= SqlDataAcessHelper.exNonStoreParas(sql, ds);
return kq;
}