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