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