protected void save_Click(object sender, EventArgs e) { DateTime Tgl = DateTime.Today; int index = 0; foreach (Control tr in list.Controls) { TableCell nokontrak = (TableCell)list.FindControl("nokontrak_" + index); TableCell skema_agent = (TableCell)list.FindControl("skema_agent_" + index); TableCell nounit = (TableCell)list.FindControl("nounit_" + index); TableCell cust = (TableCell)list.FindControl("cust_" + index); TableCell nilaikomisi = (TableCell)list.FindControl("nilaikomisi_" + index); TableCell potongkomisi = (TableCell)list.FindControl("potongkomisi_" + index); string[] aa = skema_agent.Attributes["title"].Split(';'); if (cust.Attributes["title"] != "-") { string[] bb = cust.Attributes["title"].Split(';'); string KomisiID = LibKom.KomisiID(Tgl.Month, Tgl.Year, Project); Db.Execute("EXEC spKomisiDaftar" + " '" + KomisiID + "'" + ",'" + Tgl + "'" + ", " + Convert.ToInt32(aa[2]) + ",'" + aa[3] + "'" + ",'" + aa[5] + "'" + ",'" + aa[6] + "'" + ",'" + aa[7] + "'" + ",'" + nokontrak.Text + "'" + ",'" + aa[0] + "'" + ",'" + aa[1] + "'" + ",'" + bb[0] + "'" + ",'" + bb[1] + "'" + ",'" + nounit.Text + "'" ); xx = KomisiID; Db.Execute("UPDATE MS_KOMISI SET " + " Project = '" + Project + "'" + " WHERE NoKontrak = '" + nokontrak.Text + "'"); string strSql = "UPDATE MS_KONTRAK SET KomisiID = '" + KomisiID + "' WHERE NoKontrak = '" + nokontrak.Text + "'"; Db.Execute(strSql); } SaveDetil(xx, aa[0], aa[1], Convert.ToDecimal(nilaikomisi.Text), Convert.ToBoolean(aa[4]), aa[5], aa[8]); index++; } Response.Redirect("CFRegis1.aspx"); }
protected void save_Click(object sender, EventArgs e) { DateTime Tgl = DateTime.Today; if (skema.Items.Count > 0) { DataTable sk = Db.Rs("SELECT * FROM REF_SKOM_REWARD WHERE NoSkema = " + Convert.ToInt32(skema.SelectedValue)); if (sk.Rows.Count > 0) { int index = 0; foreach (Control tr in list.Controls) { TableCell pk = (TableCell)list.FindControl("pk_" + index); TableCell reward = (TableCell)list.FindControl("reward_" + index); TableCell nokontrak = (TableCell)list.FindControl("nokontrak_" + index); string[] aa = pk.Attributes["title"].Split(';'); string RewardID = LibKom.RewardID(Tgl.Month, Tgl.Year); if (Convert.ToBoolean(aa[1])) { Db.Execute("EXEC spKomisiRewardDaftar" + " '" + RewardID + "'" + ",'" + Tgl + "'" + ", " + Convert.ToInt32(aa[0]) + ",'" + pk.Text + "'" + ", " + Convert.ToInt32(sk.Rows[0]["NoSkema"]) + ",'" + sk.Rows[0]["Nama"].ToString() + "'" + ",'" + sk.Rows[0]["Rumus"].ToString() + "'" + ",'" + Convert.ToDateTime(sk.Rows[0]["Dari"]) + "'" + ",'" + Convert.ToDateTime(sk.Rows[0]["Sampai"]) + "'" + ",'" + reward.Text + "'" ); Db.Execute("UPDATE MS_KOMISI_REWARD SET " + " Project = '" + project.SelectedValue + "'" + " WHERE NoReward = '" + RewardID + "'"); SaveDetil(RewardID, aa[0], sk.Rows[0]["Rumus"].ToString(), Convert.ToDateTime(sk.Rows[0]["Dari"]), Convert.ToDateTime(sk.Rows[0]["Sampai"]), nokontrak.Attributes["title"]); } index++; } } } Response.Redirect("RewardRegis1.aspx"); }
protected void save_Click(object sender, EventArgs e) { if (valid()) { DateTime Tgl = Convert.ToDateTime(tgl.Text); string KRID = LibKom.KRID(Tgl.Month, Tgl.Year); Db.Execute("EXEC spKomisiRDaftar" + " '" + KRID + "'" + ",'" + Tgl + "'" + ",'" + Request.QueryString["id"] + "'" + ",'" + Cf.Str(ket.Text) + "'" ); Db.Execute("UPDATE MS_KOMISIR SET Project = '" + Project + "'" + " WHERE NoKomisiR = '" + KRID + "'"); int index = 0; foreach (Control tr in list.Controls) { CheckBox cb = (CheckBox)list.FindControl("cb_" + index); string[] aa = cb.Attributes["title"].Split(';'); if (cb.Checked) { DataTable dd = Db.Rs("SELECT * FROM MS_KOMISIP_DETAIL WHERE NoKomisi = '" + aa[0] + "' AND SN_KomisiTermin = " + Convert.ToInt32(aa[1])); if (dd != null) { Db.Execute("EXEC spKomisiRDetil" + " '" + KRID + "'" + ",'" + dd.Rows[0]["NoKomisi"].ToString() + "'" + ", " + Convert.ToInt32(dd.Rows[0]["SN_KomisiTermin"]) + ", " + Convert.ToDecimal(dd.Rows[0]["Nilai"]) ); Db.Execute("UPDATE MS_KOMISIR_DETAIL SET NoAgent = '" + Convert.ToInt32(aa[2]) + "' WHERE NoKomisiR = '" + KRID + "' AND SN_KomisiTermin = " + Convert.ToInt32(dd.Rows[0]["SN_KomisiTermin"])); } } index++; } DataTable rs = Db.Rs("SELECT * FROM MS_KOMISIP_DETAIL a" + " INNER JOIN MS_KOMISI b ON a.NoKomisi = b.NoKomisi" + " WHERE (SELECT COUNT(*) FROM MS_KOMISIR_DETAIL WHERE NoKomisi = a.NoKomisi AND SN_KomisiTermin = a.SN_KomisiTermin) = 0" + " AND a.NoKomisiP = '" + Request.QueryString["id"] + "'" ); if (rs.Rows.Count == 0) { Db.Execute("UPDATE MS_KOMISIP SET Realisasi = 1 WHERE NoKomisiP = '" + Request.QueryString["id"] + "'"); } DataTable rsHeader = Db.Rs("SELECT " + " NoKomisiR" + ",CONVERT(varchar,Tgl,106) AS [Tgl. Realisasi]" + ",Ket AS [Keterangan]" + ",NoKomisiP AS [Kode Pengajuan]" + " FROM " + Mi.DbPrefix + "MARKETINGJUAL..MS_KOMISIR " + " WHERE NoKomisiR = '" + KRID + "'"); DataTable rsDetail = Db.Rs("SELECT " + " CONVERT(VARCHAR, SN) " + " + '. ' + (SELECT NamaAgent FROM MS_KOMISI_DETAIL WHERE NoKomisi = a.NoKomisi AND SN = a.SN_KomisiTermin)" + " + ' ' + CONVERT(VARCHAR, Nilai, 1) " + " FROM " + Mi.DbPrefix + "MARKETINGJUAL..MS_KOMISIR_DETAIL a WHERE NoKomisiR = '" + KRID + "'"); string Ket = Cf.LogCapture(rsHeader) + Cf.LogList(rsDetail, "DETAIL"); Db.Execute("EXEC spLogKomisiR" + " 'DAFTAR'" + ",'" + Act.UserID + "'" + ",'" + Act.IP + "'" + ",'" + Ket + "'" + ",'" + KRID + "'" ); decimal LogID = Db.SingleDecimal("SELECT TOP 1 LogID FROM MS_KOMISIR_LOG ORDER BY LogID DESC"); Db.Execute("UPDATE MS_KOMISIR_LOG SET Project = '" + Project + "' WHERE LogID = " + LogID); Response.Redirect("KomisiRRegis1.aspx?id=" + KRID); } }
protected void save_Click(object sender, EventArgs e) { if (valid()) { DateTime Tgl = Convert.ToDateTime(tgl.Text); string RRID = LibKom.RRID(Tgl.Month, Tgl.Year); Db.Execute("EXEC spKomisiRewardRDaftar" + " '" + RRID + "'" + ",'" + Tgl + "'" + ",'" + Request.QueryString["id"] + "'" + ",'" + Cf.Str(ket.Text) + "'" ); Db.Execute("UPDATE MS_KOMISI_REWARD_R SET " + " Project = '" + Project + "'" + " WHERE NoRR = '" + RRID + "'"); int index = 0; foreach (Control tr in list.Controls) { CheckBox cb = (CheckBox)list.FindControl("cb_" + index); if (cb.Checked) { DataTable dd = Db.Rs("SELECT * FROM MS_KOMISI_REWARD_P_DETAIL WHERE NoReward = '" + cb.Attributes["title"] + "'"); if (dd != null) { Db.Execute("EXEC spKomisiRewardRDetil" + " '" + RRID + "'" + ",'" + dd.Rows[0]["NoReward"].ToString() + "'" + ",'" + dd.Rows[0]["Reward"].ToString() + "'" ); } } index++; } DataTable rsHeader = Db.Rs("SELECT " + " NoRR" + ",CONVERT(varchar,Tgl,106) AS [Tgl. Realisasi]" + ",Ket AS [Keterangan]" + ",NoRP AS [Kode Pengajuan]" + " FROM " + Mi.DbPrefix + "MARKETINGJUAL..MS_KOMISI_REWARD_R " + " WHERE NoRR = '" + RRID + "'"); DataTable rsDetail = Db.Rs("SELECT " + " CONVERT(VARCHAR, SN) " + " + '. ' + NoReward" + " + ' ' + Reward " + " FROM " + Mi.DbPrefix + "MARKETINGJUAL..MS_KOMISI_REWARD_R_DETAIL a WHERE NoRR = '" + RRID + "'"); string Ket = Cf.LogCapture(rsHeader) + Cf.LogList(rsDetail, "DETAIL"); Db.Execute("EXEC spLogKomisiRewardR" + " 'DAFTAR'" + ",'" + Act.UserID + "'" + ",'" + Act.IP + "'" + ",'" + Ket + "'" + ",'" + RRID + "'" ); decimal LogID = Db.SingleDecimal("SELECT TOP 1 LogID FROM MS_KOMISI_REWARD_R_LOG ORDER BY LogID DESC"); Db.Execute("UPDATE MS_KOMISI_REWARD_R_LOG SET Project = '" + Project + "' WHERE LogID = " + LogID); Response.Redirect("RewardRRegis1.aspx?id=" + RRID); } }
protected void save_Click(object sender, EventArgs e) { if (valid()) { DateTime Tgl = Convert.ToDateTime(tgl.Text); string CFPID = LibKom.CFPID(Tgl.Month, Tgl.Year, project.SelectedValue); string Project = Cf.Str(project.SelectedValue); Db.Execute("EXEC spKomisiCFPDaftar" + " '" + CFPID + "'" + ",'" + Tgl + "'" + ",'" + Cf.Str(ket.Text) + "'" ); Db.Execute("UPDATE MS_KOMISI_CFP SET Project = '" + Project + "', SalesTipe = '" + tipesales.SelectedValue + "'" + " WHERE NoCFP = '" + CFPID + "'"); int index = 0; foreach (Control tr in list.Controls) { CheckBox cb = (CheckBox)list.FindControl("cb_" + index); string[] aa = cb.Attributes["title"].Split(';'); if (cb.Checked) { DataTable dd = Db.Rs("SELECT * FROM MS_KOMISI_CF_DETAIL WHERE NoCF = '" + aa[0] + "' AND SN = " + Convert.ToInt32(aa[1])); if (dd != null) { Db.Execute("EXEC spKomisiCFPDetil" + " '" + CFPID + "'" + ",'" + dd.Rows[0]["NoCF"].ToString() + "'" + ", " + Convert.ToInt32(dd.Rows[0]["SN"]) + ", " + Convert.ToDecimal(dd.Rows[0]["Nilai"]) + ", " + Convert.ToInt32(dd.Rows[0]["NoAgent"]) + ", '" + dd.Rows[0]["NamaAgent"].ToString() + "'" ); } } index++; } DataTable rsHeader = Db.Rs("SELECT " + " NoCFP" + ",CONVERT(varchar,Tgl,106) AS [Tgl. Pengajuan]" + ",Ket AS [Keterangan]" + ",(select Tipe from ref_agent_tipe where ref_agent_tipe.ID = MS_KOMISI_CFP.SalesTipe) AS [Tipe]" + " FROM " + Mi.DbPrefix + "MARKETINGJUAL..MS_KOMISI_CFP " + " WHERE NoCFP = '" + CFPID + "'"); DataTable rsDetail = Db.Rs("SELECT " + " CONVERT(VARCHAR, SN) " + " + '. ' + (SELECT NamaAgent FROM MS_KOMISI_CF WHERE NoCF = a.NoCF AND SN = a.SN_NoCF)" + " + ' ' + CONVERT(VARCHAR, Nilai, 1) " + " FROM " + Mi.DbPrefix + "MARKETINGJUAL..MS_KOMISI_CFP_DETAIL a WHERE NoCFP = '" + CFPID + "'"); string Ket = Cf.LogCapture(rsHeader) + Cf.LogList(rsDetail, "DETAIL"); Db.Execute("EXEC spLogKomisiCFP" + " 'DAFTAR'" + ",'" + Act.UserID + "'" + ",'" + Act.IP + "'" + ",'" + Ket + "'" + ",'" + CFPID + "'" ); decimal LogID = Db.SingleDecimal("SELECT TOP 1 LogID FROM MS_KOMISI_CFP_LOG ORDER BY LogID DESC"); Db.Execute("UPDATE MS_KOMISI_CFP_LOG SET Project = '" + Project + "' WHERE LogID = " + LogID); Response.Redirect("CFPRegis1.aspx?done=" + CFPID); } }
protected void save_Click(object sender, EventArgs e) { if (valid()) { string NoCFP = Request.QueryString["id"].ToString(); //No. Pengajuan DateTime Tgl = Convert.ToDateTime(tgl.Text); string CFRID = LibKom.CFRID(Tgl.Month, Tgl.Year, Project); int SalesTipe = Db.SingleInteger("select SalesTipe from MS_KOMISI_CFP where NoCFP = '" + NoCFP + "'"); Db.Execute("EXEC spKomisiCFRDaftar" + " '" + CFRID + "'" + ",'" + Tgl + "'" + ",'" + Request.QueryString["id"] + "'" + ",'" + Cf.Str(ket.Text) + "'" ); Db.Execute("UPDATE MS_KOMISI_CFR SET Project = '" + Project + "', SalesTipe = '" + SalesTipe + "'" + " WHERE NoCFR = '" + CFRID + "'"); int index = 0; foreach (Control tr in list.Controls) { CheckBox cb = (CheckBox)list.FindControl("cb_" + index); string[] aa = cb.Attributes["title"].Split(';'); if (cb.Checked) { DataTable dd = Db.Rs("SELECT * FROM MS_KOMISI_CFP_DETAIL WHERE NoCF = '" + aa[0] + "' AND SN_NoCF = " + Convert.ToInt32(aa[1])); if (dd != null) { TextBox pph = (TextBox)list.FindControl("pph_" + index); string NilaiPPH = Cf.Str(pph.Text); Db.Execute("EXEC spKomisiCFRDetil" + " '" + CFRID + "'" + ",'" + dd.Rows[0]["NoCF"].ToString() + "'" + ", " + Convert.ToInt32(dd.Rows[0]["SN_NoCF"]) + ", " + Convert.ToDecimal(dd.Rows[0]["Nilai"]) + ", '" + Convert.ToInt32(dd.Rows[0]["NoAgent"]) + "'" + ", '" + Convert.ToString(dd.Rows[0]["NamaAgent"]) + "'" + ", '" + NoCFP + "'" + ", '" + Convert.ToDecimal(NilaiPPH) + "'" ); Db.Execute("UPDATE MS_KOMISI_CFR_DETAIL SET NoAgent = '" + Convert.ToInt32(aa[2]) + "' WHERE NoCFR = '" + CFRID + "' AND SN_NoCF = " + Convert.ToInt32(dd.Rows[0]["SN_NoCF"])); } } index++; } //ini untuk update ke Pengajuannya. int countCFP = Db.SingleInteger("select count(*) from MS_KOMISI_CFP_DETAIL where NoCFP = '" + NoCFP + "'"); int countCFR = Db.SingleInteger("select count(*) from MS_KOMISI_CFR_DETAIL where NoCFP = '" + NoCFP + "'"); if (countCFR == countCFP) { Db.Execute("UPDATE MS_KOMISI_CFP SET Realisasi = 1 WHERE NoCFP = '" + NoCFP + "'"); } DataTable rsHeader = Db.Rs("SELECT " + " NoCFR" + ",CONVERT(varchar,Tgl,106) AS [Tgl. Realisasi]" + ",(select Tipe from REF_AGENT_TIPE where REF_AGENT_TIPE.ID = MS_KOMISI_CFR.SalesTipe) AS [Tipe]" + ",Ket AS [Keterangan]" + ",NoCFP AS [Kode Pengajuan]" + " FROM " + Mi.DbPrefix + "MARKETINGJUAL..MS_KOMISI_CFR " + " WHERE NoCFR = '" + CFRID + "'"); DataTable rsDetail = Db.Rs("SELECT " + " CONVERT(VARCHAR, SN) " + " + '. ' + (SELECT NamaAgent FROM MS_KOMISI_CF_DETAIL WHERE NoCF = a.NoCF AND SN = a.SN_NoCF)" + " + ' ' + CONVERT(VARCHAR, Nilai, 1) " + " FROM " + Mi.DbPrefix + "MARKETINGJUAL..MS_KOMISI_CFR_DETAIL a WHERE NoCFR = '" + CFRID + "'"); string Ket = Cf.LogCapture(rsHeader) + Cf.LogList(rsDetail, "DETAIL"); Db.Execute("EXEC spLogKomisiCFR" + " 'DAFTAR'" + ",'" + Act.UserID + "'" + ",'" + Act.IP + "'" + ",'" + Ket + "'" + ",'" + CFRID + "'" ); decimal LogID = Db.SingleDecimal("SELECT TOP 1 LogID FROM MS_KOMISI_CFR_LOG ORDER BY LogID DESC"); Db.Execute("UPDATE MS_KOMISI_CFR_LOG SET Project = '" + Project + "' WHERE LogID = " + LogID); Response.Redirect("CFRRegis1.aspx?id=" + CFRID); } }