public int insert_data(tbl_disaster_master_DAL objdal) { SqlCommand cm = new SqlCommand("insert_tbl_disaster_master", cn); cm.CommandType = CommandType.StoredProcedure; cm.Parameters.AddWithValue("@str_disaster_name", objdal.str_disaster_name); cm.Parameters.AddWithValue("@date_active_date", objdal.date_active_date); cm.Parameters.AddWithValue("@date_end_date", objdal.date_end_date); cm.Parameters.AddWithValue("@bit_status", objdal.bit_status); cm.Parameters.AddWithValue("@str_place", objdal.str_place); cm.Parameters.AddWithValue("@str_latitude", objdal.str_latitude); cm.Parameters.AddWithValue("@str_longitude", objdal.str_longitude); cm.Parameters.AddWithValue("@int_disaster_type_id", objdal.int_disaster_type_id); cm.Parameters.AddWithValue("@str_img", objdal.str_img); cn.Open(); int val = Convert.ToInt16(cm.ExecuteNonQuery()); cn.Close(); return(val); }
protected void btn_add_Click1(object sender, EventArgs e) { try { tbl_disaster_master_BAL objbal = new tbl_disaster_master_BAL(); tbl_disaster_master_DAL objdal = new tbl_disaster_master_DAL(); objdal.str_disaster_name = txt_disaster_master_name.Text; objdal.date_active_date = Convert.ToDateTime(txt_active_date.Text); objdal.date_end_date = Convert.ToDateTime(txt_end_date.Text); objdal.bit_status = chk_active.Checked; objdal.str_place = txt_place.Text; objdal.str_longitude = txt_longitude.Text; objdal.str_latitude = txt_latitude.Text; objdal.int_disaster_type_id = Convert.ToInt16(ddl_disaster_type.SelectedItem.Value); objdal.str_img = fu_img.FileName; if (fu_img.HasFile) { //if (fu_img.PostedFile.ContentLength <= 250000) //{ string path = Server.MapPath("~/upload/disaster/"); fu_img.SaveAs(path + fu_img.FileName); //} } lblmsg.Visible = true; int val = objbal.insert_data(objdal); if (val > 0) { binddata(""); lblmsg.Text = "successfully inserted"; lblmsg.ForeColor = System.Drawing.Color.Green; } else if (val == -1) { lblmsg.Text = "name duplicate is dot allowed"; lblmsg.ForeColor = System.Drawing.Color.Red; } changepanel(1, 0); } catch (Exception ex) { } }
public int delete_data(tbl_disaster_master_DAL objdal) { SqlCommand cm = new SqlCommand("delete_tbl_disaster_master", cn); cm.CommandType = CommandType.StoredProcedure; cm.Parameters.AddWithValue("@int_disaster_id", objdal.int_disaster_id); cn.Open(); int val = Convert.ToInt16(cm.ExecuteScalar()); cn.Close(); return(val); }
protected void btn_select_delete_Click(object sender, EventArgs e) { try { tbl_disaster_master_BAL objbal = new tbl_disaster_master_BAL(); tbl_disaster_master_DAL objdal = new tbl_disaster_master_DAL(); foreach (GridViewRow row in gvlist.Rows) { var check = row.FindControl("chkselect") as CheckBox; if (check.Checked) { var id = row.FindControl("Hiddenid") as HiddenField; objdal.int_disaster_id = Convert.ToInt16(id.Value); objbal.delete_data(objdal); binddata(""); } } } catch (Exception ex) { } }