private void Fill()
{
if (System.IO.File.Exists(Request.PhysicalApplicationPath
+ "Foto\\" + NoAgent.ToString().PadLeft(5, '0') + ".jpg"))
{
foto.ImageUrl = "Foto/" + NoAgent.ToString().PadLeft(5, '0') + ".jpg";
}
else
{
foto.Visible = false;
}
}
protected void delbtn_Click(object sender, System.EventArgs e)
{
DataTable rs = Db.Rs(
"SELECT * FROM MS_AGENT WHERE NoAgent = " + NoAgent);
if (rs.Rows.Count == 0)
{
Response.Redirect("/CustomError/Deleted.html");
}
else
{
string Ket = "***Alasan Delete :<br>" + Cf.Str(ket.Text)
+ "<br><br>***Data Sebelum Delete :<br>"
+ Cf.LogCapture(rs);
Db.Execute("EXEC spAgentDel " + NoAgent);
int c = Db.SingleInteger(
"SELECT COUNT(*) FROM MS_AGENT WHERE NoAgent = " + NoAgent);
if (c == 0)
{
//Log
Db.Execute("EXEC spLogAgent "
+ " 'DELETE'"
+ ",'" + Act.UserID + "'"
+ ",'" + Act.IP + "'"
+ ",'" + Ket + "'"
+ ",'" + NoAgent.PadLeft(5, '0') + "'"
);
decimal LogID = Db.SingleDecimal("SELECT TOP 1 LogID FROM MS_AGENT_LOG ORDER BY LogID DESC");
string Project = Db.SingleString("SELECT Project FROM MS_AGENT WHERE NoAgent = '" + NoAgent + "'");
Db.Execute("UPDATE MS_AGENT_LOG SET Project = '" + Project + "' WHERE LogID = " + LogID);
Js.Close(this);
}
else
{
//Tidak bisa dihapus
frm.Visible = false;
nodel.Visible = true;
}
}
}
protected void upload_Click(object sender, System.EventArgs e)
{
if (!file.PostedFile.FileName.EndsWith(".jpg"))
{
Js.Alert(
this
, "Proses Upload Gagal.\\n"
+ "File yang boleh di-upload adalah file dengan extension .jpg saja."
, ""
);
}
else
{
string path = Request.PhysicalApplicationPath
+ "Foto\\" + NoAgent.PadLeft(5, '0') + ".jpg";
Dfc.UploadFile(".jpg", path, file);
//Logfile
DataTable rs = Db.Rs("SELECT "
+ " NoAgent AS [No. Agent]"
+ ",Nama AS [Nama]"
+ " FROM MS_AGENT"
+ " WHERE NoAgent = " + NoAgent
);
string Ket = Cf.LogCapture(rs);
Db.Execute("EXEC spLogAgent"
+ " 'FOTO'"
+ ",'" + Act.UserID + "'"
+ ",'" + Act.IP + "'"
+ ",'" + Ket + "'"
+ ",'" + NoAgent.PadLeft(5, '0') + "'"
);
Response.Redirect("AgentFoto.aspx?done=1&NoAgent=" + NoAgent);
}
}
private bool Save()
{
if (valid())
{
decimal Target1 = Convert.ToDecimal(target1.Text);
decimal Target2 = Convert.ToDecimal(target2.Text);
decimal Target3 = Convert.ToDecimal(target3.Text);
decimal Target4 = Convert.ToDecimal(target4.Text);
decimal Target5 = Convert.ToDecimal(target5.Text);
int Skema0 = Convert.ToInt32(skema0.SelectedValue);
int Skema1 = Convert.ToInt32(skema1.SelectedValue);
int Skema2 = Convert.ToInt32(skema2.SelectedValue);
int Skema3 = Convert.ToInt32(skema3.SelectedValue);
int Skema4 = Convert.ToInt32(skema4.SelectedValue);
int Skema5 = Convert.ToInt32(skema5.SelectedValue);
DataTable rsBef = Db.Rs("SELECT "
+ " Target1 AS [Target #1]"
+ ",Target2 AS [Target #2]"
+ ",Target3 AS [Target #3]"
+ ",Target4 AS [Target #4]"
+ ",Target5 AS [Target #5]"
+ ",Skema0 AS [Skema Komisi Standard]"
+ ",Skema1 AS [Skema Komisi #1]"
+ ",Skema2 AS [Skema Komisi #2]"
+ ",Skema3 AS [Skema Komisi #3]"
+ ",Skema4 AS [Skema Komisi #4]"
+ ",Skema5 AS [Skema Komisi #5]"
+ " FROM MS_AGENT"
+ " WHERE NoAgent = " + NoAgent
);
Db.Execute("EXEC spAgentEditSSK"
+ " " + NoAgent
+ ", " + Target1
+ ", " + Target2
+ ", " + Target3
+ ", " + Target4
+ ", " + Target5
+ ", " + Skema0
+ ", " + Skema1
+ ", " + Skema2
+ ", " + Skema3
+ ", " + Skema4
+ ", " + Skema5
);
DataTable rsAft = Db.Rs("SELECT "
+ " Target1 AS [Target #1]"
+ ",Target2 AS [Target #2]"
+ ",Target3 AS [Target #3]"
+ ",Target4 AS [Target #4]"
+ ",Target5 AS [Target #5]"
+ ",Skema0 AS [Skema Komisi Standard]"
+ ",Skema1 AS [Skema Komisi #1]"
+ ",Skema2 AS [Skema Komisi #2]"
+ ",Skema3 AS [Skema Komisi #3]"
+ ",Skema4 AS [Skema Komisi #4]"
+ ",Skema5 AS [Skema Komisi #5]"
+ " FROM MS_AGENT"
+ " WHERE NoAgent = " + NoAgent
);
//Logfile
DataTable rs = Db.Rs("SELECT "
+ " NoAgent AS [No. Agent]"
+ ",Nama AS [Nama]"
+ " FROM MS_AGENT"
+ " WHERE NoAgent = " + NoAgent
);
string Ket = Cf.LogCapture(rs)
+ Cf.LogCompare(rsBef, rsAft);
Db.Execute("EXEC spLogAgent"
+ " 'SSK'"
+ ",'" + Act.UserID + "'"
+ ",'" + Act.IP + "'"
+ ",'" + Ket + "'"
+ ",'" + NoAgent.PadLeft(5, '0') + "'"
);
return(true);
}
else
{
return(false);
}
}
protected void save_Click(object sender, System.EventArgs e)
{
if (valid())
{
string KodeSales = kodesls.Text;
string Nama = Cf.Str(nama.Text);
int Tipe = Convert.ToInt32(tipe.SelectedValue);
int Level = Convert.ToInt32(level.SelectedValue);
int Atasan = 0;
if (atasan.SelectedValue != "")
{
Atasan = Convert.ToInt32(atasan.SelectedValue);
}
string Alamat = Cf.Str(alamat.Text);
string Handphone = Cf.Str(hp.Text);
string Whatsapp = Cf.Str(wa.Text);
string Telpon = Cf.Str(telp.Text);
string NPWP = Cf.Str(npwp.Text);
string Email = Cf.Str(email1.Text);
string RekBank = Cf.Str(rek.Text);
string Bank = Cf.Str(rekbank1.Text);
string AtasNama = Cf.Str(atasnama1.Text);
//string Jabatan = Cf.Str(jabatan.SelectedItem.Text);
Db.Execute("EXEC spAgentDaftar"
+ " '" + Nama + "'"
+ ",''"
+ ",''"
+ ",'" + Alamat + "'"
+ ",'" + Telpon + "'"
+ ",'" + NPWP + "'"
+ ",'" + Tipe + "'"
+ ",'" + Level + "'"
+ ",''"
+ ",'" + Atasan + "'"
+ ",''"
+ ",'" + RekBank + "'"
+ ",''"
+ ",'" + Bank + "'"
+ ",'" + AtasNama + "'"
+ ",''"
+ ",'" + Level + "'"
);
//get nomor agent terbaru
noagent.Text = Db.SingleInteger(
"SELECT TOP 1 NoAgent FROM MS_AGENT ORDER BY NoAgent DESC")
.ToString().PadLeft(5, '0');
int b = 0;
int LvlAtasan = 0;
if (Level > 1)
{
b = Db.SingleInteger("SELECT ParentID FROM REF_AGENT_LEVEL WHERE LevelID = '" + level.SelectedValue + "'");
if (b > 0)
{
LvlAtasan = Db.SingleInteger("SELECT SalesLevel FROM MS_AGENT WHERE SalesLevel ='" + b + "'");
}
}
//Response.Write(strSql);
Db.Execute("Update MS_AGENT SET KodeSales = '" + KodeSales.ToString().Replace(" ", "") + "',Whatsapp = '" + Whatsapp + "',Handphone = '" + Handphone + "',Email = '" + Email + "',LvlAtasan = '" + LvlAtasan + "',Project='" + project.SelectedValue + "' Where NoAgent = '" + noagent.Text + "'");
DataTable rs = Db.Rs("SELECT "
+ " NoAgent AS [No. Agent]"
+ ",KodeSales AS [Kode Sales]"
+ ",Nama AS [Nama Lengkap]"
//+ ",Principal AS [Nama Perusahaan]"
+ ",Alamat"
+ ",Kontak"
+ ",Handphone"
+ ",Whatsapp"
+ ",NPWP"
+ ",Email"
+ ",RekBank"
+ ",Rekening"
+ ",AtasNama"
+ ",Jabatan"
+ ",Project"
+ ",Skema0 AS [Skema Komisi Standard]"
+ " FROM MS_AGENT a"
+ " WHERE NoAgent = " + NoAgent
);
Db.Execute("EXEC spLogAgent"
+ " 'DAFTAR'"
+ ",'" + Act.UserID + "'"
+ ",'" + Act.IP + "'"
+ ",'" + Cf.LogCapture(rs) + "'"
+ ",'" + NoAgent.PadLeft(5, '0') + "'"
);
decimal LogID = Db.SingleDecimal("SELECT TOP 1 LogID FROM MS_AGENT_LOG ORDER BY LogID DESC");
Db.Execute("UPDATE MS_AGENT_LOG SET Project = '" + project.Text + "' WHERE LogID = " + LogID);
Response.Redirect("AgentDaftar.aspx?done=" + NoAgent + "&project=" + project.SelectedValue);
}
}
private void Fill()
{
btnlog.Attributes["onclick"] = "location.href='LogPk.aspx?Tb=MS_AGENT_LOG&Pk=" + NoAgent.PadLeft(5, '0') + "'";
btndel.Attributes["onclick"] = "location.href='AgentDel.aspx?NoAgent=" + NoAgent + "'";
string strSql = "SELECT * FROM MS_AGENT WHERE NoAgent = " + NoAgent;
DataTable rs = Db.Rs(strSql);
if (rs.Rows.Count == 0)
{
Response.Redirect("/CustomError/Deleted.html");
}
else
{
noagent.Text = rs.Rows[0]["NoAgent"].ToString().PadLeft(5, '0');
kodesls1.Text = rs.Rows[0]["KodeSales"].ToString();
kodesls.Text = rs.Rows[0]["KodeSales"].ToString();
nama.Text = rs.Rows[0]["Nama"].ToString();
principal.Text = rs.Rows[0]["Principal"].ToString();
alamat.Text = rs.Rows[0]["Alamat"].ToString();
telp.Text = rs.Rows[0]["Kontak"].ToString();
hp.Text = rs.Rows[0]["Handphone"].ToString();
wa.Text = rs.Rows[0]["Whatsapp"].ToString();
npwp.Text = rs.Rows[0]["NPWP"].ToString();
email1.Text = rs.Rows[0]["Email"].ToString();
rekbank1.Text = rs.Rows[0]["RekBank"].ToString();
//cabang1.Text = rs.Rows[0]["Cabang"].ToString();
norek1.Text = rs.Rows[0]["Rekening"].ToString();
atasnama1.Text = rs.Rows[0]["AtasNama"].ToString();
level.Items.Add(rs.Rows[0]["SalesLevel"].ToString());
level.SelectedValue = rs.Rows[0]["SalesLevel"].ToString();
tipe.SelectedValue = rs.Rows[0]["SalesTipe"].ToString();
project.SelectedValue = rs.Rows[0]["Project"].ToString();
atasan.Items.Clear();
if (rs.Rows[0]["LvlAtasan"].ToString() != "0")
{
int a = Db.SingleInteger("SELECT ParentID FROM REF_AGENT_LEVEL WHERE LevelID = '" + rs.Rows[0]["SalesLevel"] + "'");
string strSql2 = "SELECT * FROM MS_AGENT WHERE SalesLevel ='" + a + "' AND SalesTipe='" + rs.Rows[0]["SalesTipe"].ToString() + "'";
DataTable rs2 = Db.Rs(strSql2);
atasan.Items.Add(new ListItem {
Text = "Atasan :", Value = "0"
});
for (int i = 0; i < rs2.Rows.Count; i++)
{
string v = rs2.Rows[i]["NoAgent"].ToString();
string t = rs2.Rows[i]["Nama"].ToString();
atasan.Items.Add(new ListItem(t, v));
}
}
else
{
trAtasan.Visible = false;
}
//string strSql2 = "SELECT * FROM MS_AGENT WHERE SalesLevel ='" + rs.Rows[0]["LvlAtasan"] + "'";
//DataTable rs2 = Db.Rs(strSql2);
//atasan.Items.Add(new ListItem { Text = "Atasan :", Value = "0" });
//for (int i = 0; i < rs2.Rows.Count; i++)
//{
// string v = rs2.Rows[i]["NoAgent"].ToString();
// string t = rs2.Rows[i]["Nama"].ToString();
// atasan.Items.Add(new ListItem(t, v));
//}
atasan.SelectedValue = rs.Rows[0]["Atasan"].ToString();
jabatan.Items.Add(new ListItem(rs.Rows[0]["Jabatan"].ToString()));
jabatan.SelectedValue = rs.Rows[0]["Jabatan"].ToString();
if ((string)rs.Rows[0]["Status"] == "A")
{
aktif.Checked = true;
}
else
{
inaktif.Checked = true;
}
tglInput.Text = Cf.Date(rs.Rows[0]["TglInput"]);
tglEdit.Text = Cf.Date(rs.Rows[0]["TglEdit"]);
}
}
private bool Save()
{
if (valid())
{
string Kodesls = Cf.Str(kodesls.Text);
string Nama = Cf.Str(nama.Text);
string Alamat = Cf.Str(alamat.Text);
string Kontak = Cf.Str(telp.Text);
string Handphone = Cf.Str(hp.Text);
string Whatsapp = Cf.Str(wa.Text);
string NPWP = Cf.Str(npwp.Text);
string Email = Cf.Str(email1.Text);
string RekBank = Cf.Str(rekbank1.Text);
string NoRek = Cf.Str(norek1.Text);
string AtasNama = Cf.Str(atasnama1.Text);
string Status = "";
int Tipe = Convert.ToInt32(tipe.SelectedValue);
int Level = Convert.ToInt32(level.SelectedValue);
int Atasan = Convert.ToInt32(atasan.SelectedValue);
if (aktif.Checked)
{
Status = "A";
}
if (inaktif.Checked)
{
Status = "I";
}
string Jabatan = Cf.Str(jabatan.SelectedItem.Text);
DataTable rsBef = Db.Rs("SELECT "
+ " NoAgent AS [No. Agent]"
+ ",KodeSales AS [Kode Sales]"
+ ",Nama AS [Nama Lengkap]"
+ ",Alamat"
+ ",Kontak"
+ ",Handphone"
+ ",Whatsapp"
+ ",NPWP"
+ ",Email"
+ ",RekBank"
+ ",Rekening"
+ ",AtasNama"
+ ",Jabatan"
+ ",Status"
+ ",SalesTipe"
+ ",SalesLevel"
+ ",Atasan"
+ ",LvlAtasan"
+ ",Project"
+ ",Skema0 AS [Skema Komisi Standard]"
+ " FROM MS_AGENT a"
+ " WHERE NoAgent = " + NoAgent
);
Db.Execute("EXEC spAgentEdit"
+ " " + NoAgent
+ ",'" + Nama + "'"
+ ",'" + Alamat + "'"
+ ",'" + Kontak + "'"
+ ",'" + NPWP + "'"
+ ",'" + Tipe + "'"
+ ",'" + Level + "'"
+ ",'" + Atasan + "'"
+ ",'" + Email + "'"
+ ",'" + RekBank + "'"
+ ",'" + NoRek + "'"
+ ",'" + AtasNama + "'"
+ ",'" + Status + "'"
//+ ",''"
);
int b = Db.SingleInteger("SELECT ParentID FROM REF_AGENT_LEVEL WHERE LevelID = '" + level.SelectedValue + "'");
int LvlAtasan = 0;
if (b == 0)
{
LvlAtasan = 0;
Atasan = 0;
}
else
{
LvlAtasan = Db.SingleInteger("SELECT SalesLevel FROM MS_AGENT WHERE SalesLevel ='" + b + "'");
}
Db.Execute("UPDATE MS_AGENT SET KodeSales = '" + Kodesls.ToString().Replace(" ", "") + "' "
+ ", Handphone = '" + Handphone + "'"
+ ", Whatsapp = '" + Whatsapp + "'"
+ ",Project = '" + project.SelectedValue + "'"
+ ",LvlAtasan = '" + LvlAtasan + "'"
+ ",Atasan = '" + Atasan + "'"
+ "WHERE NoAgent = " + NoAgent
);
DataTable rsAft = Db.Rs("SELECT "
+ " NoAgent AS [No. Agent]"
+ ",KodeSales AS [Kode Sales]"
+ ",Nama AS [Nama Lengkap]"
+ ",Alamat"
+ ",Kontak"
+ ",Handphone"
+ ",Whatsapp"
+ ",NPWP"
+ ",Email"
+ ",RekBank"
+ ",Rekening"
+ ",AtasNama"
+ ",Jabatan"
+ ",Status"
+ ",SalesTipe"
+ ",SalesLevel"
+ ",Atasan"
+ ",LvlAtasan"
+ ",Project"
+ ",Skema0 AS [Skema Komisi Standard]"
+ " FROM MS_AGENT a"
+ " WHERE NoAgent = " + NoAgent
);
//Logfile
string Ket = "Nama Lengkap : " + Nama + "<br>"
+ Cf.LogCompare(rsBef, rsAft);
Db.Execute("EXEC spLogAgent"
+ " 'EDIT'"
+ ",'" + Act.UserID + "'"
+ ",'" + Act.IP + "'"
+ ",'" + Ket + "'"
+ ",'" + NoAgent.PadLeft(5, '0') + "'"
);
decimal LogID = Db.SingleDecimal("SELECT TOP 1 LogID FROM MS_AGENT_LOG ORDER BY LogID DESC");
Db.Execute("UPDATE MS_AGENT_LOG SET Project = '" + project.Text + "' WHERE LogID = " + LogID);
return(true);
}
else
{
return(false);
}
}
