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