/// <summary> /// Check if level is exist /// </summary> /// <param name="lvl1">level you want to check</param> /// <returns>true if exist, false if not</returns> public static bool IsLevelExist(ch_levels lvl1)//use while insert { string strSql = "SELECT COUNT(lvl_id) FROM ch_levels WHERE lvl_id = " + lvl1.lvl_Id + " OR lvl_name = '" + lvl1.lvl_Name + "' OR lvl_desc = '" + lvl1.lvl_Desc + "'"; int num = Convert.ToInt32(Connect.MathAction(strSql, "ch_levels")); if (num > 0) { return(true); } return(false); }
/// <summary> /// Add new record of ch_levels in Database /// </summary> /// <param name="lvl1">the level you want to add</param> /// <returns>string of an error or a string.Empty if the action is completed</returns> public static string AddLevel(ch_levels lvl1) { if (IsLevelExist(lvl1)) { return("הדרגה כבר קיימת"); } string strSql = "INSERT INTO ch_levels(lvl_id, lvl_name, lvl_desc) VALUES(" + lvl1.lvl_Id + ",'" + lvl1.lvl_Name + "','" + lvl1.lvl_Desc + "')"; Connect.DoAction(strSql, "ch_levels"); return(""); }
/// <summary> /// Update lvl using its id /// </summary> /// <param name="id">lvl_id statement</param> /// <param name="newLevel1">ch_levels object</param> public static string UpdateLevelById(int id, string name, ch_levels newLevel1) { if (IsLevelExist(newLevel1, id, name)) { return("הדרגה כבר קיימת"); } string strSql = "UPDATE ch_levels SET lvl_id = " + newLevel1.lvl_Id + ", lvl_name = '" + newLevel1.lvl_Name + "', lvl_desc = '" + newLevel1.lvl_Desc + "' WHERE lvl_id=" + id; Connect.DoAction(strSql, "ch_levels"); return(""); }
protected void btn_update_lvl_Click(object sender, ImageClickEventArgs e) { ImageButton btn = (ImageButton)sender; GridViewRow gvr = (GridViewRow)btn.NamingContainer; int lvl_id = Convert.ToInt32(gvLevels.DataKeys[gvr.RowIndex].Values["lvl_id"].ToString()); string lvl_name = gvLevels.DataKeys[gvr.RowIndex].Values["lvl_name"].ToString(); TextBox txt_edit_lvl_id = (TextBox)gvr.FindControl("txt_edit_lvl_id"); TextBox txt_edit_lvl_name = (TextBox)gvr.FindControl("txt_edit_lvl_name"); TextBox txt_edit_lvl_desc = (TextBox)gvr.FindControl("txt_edit_lvl_desc"); if (lvl_id.ToString() != txt_edit_lvl_id.Text) { } if (txt_edit_lvl_id.Text.Trim() != "" && txt_edit_lvl_name.Text.Trim() != "") { //all vars to one object ch_levels lvl1 = new ch_levels(); lvl1.lvl_Id = Convert.ToInt32(txt_edit_lvl_id.Text.Trim()); lvl1.lvl_Name = txt_edit_lvl_name.Text.Trim(); lvl1.lvl_Desc = txt_edit_lvl_desc.Text.Trim(); string err = ch_levelsSvc.UpdateLevelById(lvl_id, lvl_name, lvl1); if (err == "")//אם העדכון התבצע { lblErrGV.Text = string.Empty; gvLevels.EditIndex = -1; //Bind data to GridView DataSet dsLevels = ch_levelsSvc.GetLevels(); GridViewSvc.GVBind(dsLevels, gvLevels); } else { lblErrGV.Text = err; //Bind data to GridView DataSet dsLevels = ch_levelsSvc.GetLevels(); GridViewSvc.GVBind(dsLevels, gvLevels); } } else { lblErrGV.Text = "הכנס דרגה"; } }
protected void btn_insert_lvl_Click(object sender, ImageClickEventArgs e) { ImageButton btn = (ImageButton)sender; GridViewRow gvr = (GridViewRow)btn.NamingContainer; TextBox txt_insert_lvl_id = (TextBox)gvr.FindControl("txt_insert_lvl_id"); TextBox txt_insert_lvl_name = (TextBox)gvr.FindControl("txt_insert_lvl_name"); TextBox txt_insert_lvl_desc = (TextBox)gvr.FindControl("txt_insert_lvl_desc"); if (txt_insert_lvl_id.Text.Trim() != "" && txt_insert_lvl_name.Text.Trim() != "") { //all vars to one object ch_levels lvl1 = new ch_levels(); lvl1.lvl_Id = Convert.ToInt32(txt_insert_lvl_id.Text.Trim()); lvl1.lvl_Name = txt_insert_lvl_name.Text.Trim(); lvl1.lvl_Desc = txt_insert_lvl_desc.Text.Trim(); string err = ch_levelsSvc.AddLevel(lvl1); if (err == "")//אם ההכנסה התבצע { lblErrGV.Text = ""; gvLevels.ShowFooter = false; btnInsert.Enabled = true; //Bind data to GridView DataSet dsLevels = ch_levelsSvc.GetLevels(); GridViewSvc.GVBind(dsLevels, gvLevels); } else { lblErrGV.Text = err; txt_insert_lvl_id.Text = ""; txt_insert_lvl_name.Text = ""; txt_insert_lvl_desc.Text = ""; //Bind data to GridView DataSet dsLevels = ch_levelsSvc.GetLevels(); GridViewSvc.GVBind(dsLevels, gvLevels); } } else { lblErrGV.Text = "הכנס דרגה"; } }