public static string SaveSMSON_GROUP(SMSON_GROUP objSMSON_GROUP) { string Message = ""; SqlConnection con = ConnectionClass.GetConnection(); SqlCommand objSqlCommand = new SqlCommand(); objSqlCommand.CommandText = "FSP_ADD_GROUP_I"; objSqlCommand.CommandType = CommandType.StoredProcedure; objSqlCommand.Connection = con; // objSqlCommand.Parameters.Add(new SqlParameter("@GROUP_ID", SqlDbType.Int)); // objSqlCommand.Parameters["@GROUP_ID"].Value = objSMSON_GROUP.GROUP_ID; objSqlCommand.Parameters.Add(new SqlParameter("@GROUP_NAME", SqlDbType.VarChar, 50)); objSqlCommand.Parameters["@GROUP_NAME"].Value = objSMSON_GROUP.GROUP_NAME; objSqlCommand.Parameters.Add(new SqlParameter("@USER_IDS", SqlDbType.VarChar, 50)); objSqlCommand.Parameters["@USER_IDS"].Value = objSMSON_GROUP.USER_IDS; objSqlCommand.Parameters.Add(new SqlParameter("@ERROR", SqlDbType.VarChar, 50)); objSqlCommand.Parameters["@ERROR"].Direction = ParameterDirection.Output; con.Open(); try { var data = objSqlCommand.ExecuteNonQuery(); Message = objSqlCommand.Parameters["@ERROR"].Value.ToString(); } catch//(Exception ex) { } finally { con.Close(); } return(Message); }
protected void btnAdd_Click(object sender, EventArgs e) { if (String.IsNullOrEmpty(txtName.Text)) { ScriptManager.RegisterStartupScript(this, this.GetType(), "ShowSuccess", "javascript:popup('Error','User name is empty','" + icon.CANCEL_ICON + "')", true); return; } SMSON_GROUP objSMSON_GROUP = new SMSON_GROUP(); objSMSON_GROUP.GROUP_NAME = txtName.Text; objSMSON_GROUP.USER_IDS = Session["USER_IDS"].ToString(); // objSMSON_GROUP.SMS_STATUS = 1; var data = save.SaveSMSON_GROUP(objSMSON_GROUP); try { if (!data.ToLower().Contains("already")) { //Show("Save Successfully"); ScriptManager.RegisterStartupScript(this, this.GetType(), "ShowSuccess", "javascript:popup('Success','" + data + "','" + icon.OK_ICON + "')", true); } else { //Show("Save Not Successfully"); ScriptManager.RegisterStartupScript(this, this.GetType(), "ShowSuccess", "javascript:popup('Error','" + data + "','" + icon.CANCEL_ICON + "')", true); } } catch { } finally { clear(); } }
public static List <SMSON_GROUP> Get_All_Group(string User_Ids) { var groupList = new List <SMSON_GROUP>(); var conn = ConnectionClass.GetConnection(); var cmd = new SqlCommand(); cmd.Connection = conn; cmd.CommandType = CommandType.StoredProcedure; cmd.CommandText = "FSP_GROUP_GK"; cmd.Parameters.Add(new SqlParameter("@USER_IDS", SqlDbType.VarChar, 50)); cmd.Parameters["@USER_IDS"].Value = User_Ids; conn.Open(); try { using (cmd) { var data = cmd.ExecuteReader(); while (data.Read()) { var group = new SMSON_GROUP(); group.GROUP_ID = int.Parse(data["GROUP_ID"].ToString()); group.GROUP_NAME = data["GROUP_NAME"].ToString(); group.USER_IDS = data["USER_IDS"].ToString(); groupList.Add(group); } } } catch { } finally { conn.Close(); } return(groupList); }