private void btnSave_Click(object sender, EventArgs e)
{
try
{
string vMessage = string.Empty;
if (txtName.Text.Trim() == string.Empty)
{
vMessage = "Please Enter User Name.";
new Speak().SayIt(vMessage);
MessageBox.Show(vMessage, "Information Missing");
txtName.Focus();
return;
}
Objects.Users obj = new Objects.Users();
obj.UserID = int.Parse(txtID.Text);
obj.UserName = txtName.Text.Trim();
obj.Password = txtPass.Text.Trim();
obj.IsActive = chkActive.Checked;
obj.IsAdmin = chkAdmin.Checked;
if (!vOpenMode)
{
//Insert Activity
obj.UserID = int.Parse(objDAL.getNextID().ToString());
objDAL.InsertRecord(obj);
}
else
{
objDAL.UpdateRecord(obj);
}
vMessage = "Record Saved Successfully.";
new Speak().SayIt(vMessage);
MessageBox.Show(vMessage, "Confirmation");
LoadGrid();
btnClear_Click(sender, e);
}
catch (Exception exc)
{
MessageBox.Show(exc.Message.ToString(), "Error");
}
}
public void UpdateRecord(Objects.Users obj)
{
try
{
parameters.Clear();
parameters.Add(new SqlParameter("@UserID", SqlDbType.Int, 8), obj.UserID);
parameters.Add(new SqlParameter("@UserName", SqlDbType.VarChar, 50), obj.UserName);
parameters.Add(new SqlParameter("@Password", SqlDbType.VarChar, 50), obj.Password);
parameters.Add(new SqlParameter("@IsAdmin", SqlDbType.Bit, 1), obj.IsAdmin);
parameters.Add(new SqlParameter("@IsSuperAdmin", SqlDbType.Bit, 1), obj.IsSuperAdmin);
parameters.Add(new SqlParameter("@IsActive", SqlDbType.Bit, 1), obj.IsActive);
new Database(connectionstring).ExecuteNonQueryOnly("SP_UpdUsers", parameters);
}
catch (Exception exc)
{
throw exc;
}
}
