protected void SubmitBtn_Click(object sender, EventArgs e)
{
// Insert ke table PencapaianProgram
const string sql = @"
INSERT INTO PencapaianProgram (KodProgram, TarikhProgram, BilanganHari, Lulus)
VALUES (@KodProgram, @TarikhProgram, @BilanganHari, @Lulus)";
// Get connection string from Web.config
var connection = ConfigurationManager.ConnectionStrings["Database"].ToString();
// Buka connection
using (var c = new SqlConnection(connection))
{
var pencapaianProgram = new Entities.PencapaianProgram
{
KodProgram = KodProgram.Text,
TarikhProgram = DateTime.Parse(TarikhProgram.Text),
BilanganHari = int.Parse(BilanganHari.Text),
Lulus = Lulus.Checked
};
c.Execute(sql, pencapaianProgram);
}
Response.Redirect("List.aspx");
}
protected void SubmitBtn_Click(object sender, EventArgs e)
{
var id = Request.QueryString["Id"];
const string sql = @"
UPDATE PencapaianProgram
SET KodProgram = @KodProgram,
TarikhProgram = @TarikhProgram,
Bilanganhari = @BilanganHari,
Lulus = @Lulus
WHERE Id = @Id";
using (var c = ConnectionManager.GetConnection())
{
var pencapaian = new Entities.PencapaianProgram
{
KodProgram = KodProgram.Text,
TarikhProgram = DateTime.Parse(TarikhProgram.Text),
BilanganHari = int.Parse(BilanganHari.Text),
Lulus = Lulus.Checked,
Id = int.Parse(id)
};
c.Execute(sql, pencapaian);
}
Response.Redirect("List.aspx");
}
protected void SubmitBtn_Click(object sender, EventArgs e)
{
// Logic insert ke table pencapaian program
const string sql = @"
INSERT INTO PencapaianProgram (KodProgram, TarikhProgram, BilanganHari, Lulus)
VALUES(@KodProgram, @TarikhProgram, @BilanganHari, @Lulus)";
// Get connection string from web.config
var connection = ConfigurationManager.ConnectionStrings["Database"].ToString();
// Buka connection
using (var c = new SqlConnection(connection))
{
var pencapaianProgram = new Entities.PencapaianProgram
{
KodProgram = KodProgram.Text,
// Casting datetime dan int
TarikhProgram = DateTime.Parse(TarikhProgram.Text),
BilanganHari = int.Parse(BilanganHari.Text),
Lulus = Lulus.Checked
};
// tempat nak anta
c.Execute(sql, pencapaianProgram);
}
// page kita nak pergi bila butang ditekan
Response.Redirect("List.aspx");
}
protected void btnSubmit_Click(object sender, EventArgs e)
{
//Insert ke table PencapaianProgram
const string sql = @"
INSERT INTO PencapaianProgram (KodProgram, TarikhProgram, BilanganHari, Lulus)
VALUES (@KodProgram, @TarikhProgram, @BilanganHari, @Lulus)"; //1. define sqlstatement
//2. get connection string from web.config
//note: utk on suggestion; CTRL + SPACE
var connection = ConfigurationManager.ConnectionStrings["DBTraining"].ToString();
// 3. Buka connection
using (var c = new SqlConnection(connection))
{
var PencapaianProgram = new Entities.PencapaianProgram
{
KodProgram = TxtKodProgram.Text,
TarikhProgram = DateTime.Parse(TxtTkhProgram.Text),
BilanganHari = int.Parse(TxtBilHari.Text),
Lulus = CheckBox1.Checked
};
c.Execute(sql, PencapaianProgram); // run sql then var pencapaian program
Response.Redirect("~/PencapaianProgram/frmList.aspx");
}
}
protected void btnSubmit_Click(object sender, EventArgs e) //new add method after 2x click button
{
const string sql = @"
UPDATE PencapaianProgram
SET KodProgram = @kodProgram,
TarikhProgram = @TarikhProgram,
BilanganHari = @BilanganHari,
Lulus = @Lulus
WHERE Id = @Id";
using (var c = connectionManager.GetConnection())
{
var id = Request.QueryString["Id"];
var pencapaian = new Entities.PencapaianProgram
{
KodProgram = TxtKodProgram.Text,
TarikhProgram = DateTime.Parse(TxtTkhProgram.Text),
BilanganHari = int.Parse(TxtBilHari.Text),
Lulus = CheckBox1.Checked,
Id = int.Parse(id)
};
c.Execute(sql, pencapaian); // run sql then var pencapaian
Response.Redirect("~/PencapaianProgram/frmList.aspx");
}
}
protected void ImportBtn_Click(object sender, EventArgs e)
{
var id = Request.QueryString["Id"];
// Dapatkan data dari PencapaianProgramExcel
const string sql = @"
SELECT * FROM PencapaianProgramExcel
WHERE IdMuatNaikExcel = @IdMuatNaikExcel
AND Ralat = ''";
using (var c = ConnectionFactory.GetConnection())
{
var pencapaian = c.Query <PencapaianProgramExcel>(sql, new { IdMuatNaikExcel = int.Parse(id) });
var pencapaianProgramExcels = pencapaian as IList <PencapaianProgramExcel> ?? pencapaian.ToList();
if (!pencapaianProgramExcels.Any())
{
return;
}
// Insert into PenilaianProgram
const string insert = @"
INSERT INTO PencapaianProgram (KodProgram, TarikhProgram, BilanganHari, Lulus, JenisKemasukan)
VALUES (@KodProgram, @TarikhProgram, @BilanganHari, @Lulus, 'Excel')";
foreach (var p in pencapaianProgramExcels)
{
var pencapaianProgram = new Entities.PencapaianProgram
{
KodProgram = p.KodProgram,
TarikhProgram = DateTime.Parse(p.TarikhProgram),
BilanganHari = int.Parse(p.BilanganHari),
Lulus = p.Lulus.Equals("1")
};
c.Execute(insert, pencapaianProgram);
// Set TarikhDiimpot
const string update = @"
UPDATE PencapaianProgramExcel
SET TarikhDiimpot = @TarikhDiimpot
WHERE Id = @Id";
c.Execute(update, new { TarikhDiimpot = DateTime.Now, p.Id });
}
}
}
