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);
}
}
