public static int Save(Entity.HR.RoleMaster Role)
{
int retValue = 0;
using (SqlConnection con = new SqlConnection(ConfigurationManager.ConnectionStrings["constr"].ToString()))
{
using (SqlCommand cmd = new SqlCommand())
{
cmd.Connection = con;
cmd.CommandType = CommandType.StoredProcedure;
cmd.CommandText = "RoleMaster_Save";
cmd.Parameters.AddWithValue("@RoleId", Role.RoleId);
cmd.Parameters.AddWithValue("@RoleName", Role.RoleName);
if (con.State == ConnectionState.Closed)
{
con.Open();
}
retValue = cmd.ExecuteNonQuery();
con.Close();
}
}
return(retValue);
}
protected void btnSave_Click(object sender, EventArgs e)
{
try
{
Business.HR.RoleMaster objRoleMaster = new Business.HR.RoleMaster();
Entity.HR.RoleMaster Role = new Entity.HR.RoleMaster();
Role.RoleId = RoleId;
Role.RoleName = txtRole.Text;
int RowsAffected = objRoleMaster.Save(Role);
if (RowsAffected > 0)
{
ClearControls();
LoadRoleList();
Message.IsSuccess = true;
Message.Text = "Saved Successfully";
}
else
{
Message.IsSuccess = false;
Message.Text = "Role Name Exists";
}
Message.Show = true;
}
catch (Exception ex)
{
ex.WriteException();
Message.IsSuccess = false;
Message.Text = ex.Message;
Message.Show = true;
}
}
public int Save(Entity.HR.RoleMaster Role)
{
return(DataAccess.HR.RoleMaster.Save(Role));
}
