protected void btnSave_ServerClick(object sender, EventArgs e)
{
try
{
string retvalstr = "";
if (ValidatePage() == true)
{
AdminViewModel _adminViewModel = new AdminViewModel();
AdminModel _AdminModel = new AdminModel();
_AdminModel.UserType = ddUserType.Text;
_AdminModel.AdminFullName = txtFullName.Value;
_AdminModel.AdminMobNo = txtMobileNo.Value;
_AdminModel.VenueID = ddVenueDetails.SelectedValue;
_AdminModel.AdminUserName = txtUserName.Value;
_AdminModel.AdminEmailID = txtEmailID.Value;
//SendEmailProcess _sendProcess = new SendEmailProcess();
//string body = string.Empty;
//using (StreamReader reader = new StreamReader(Server.MapPath("~/EmailFormat.html")))
//{
// body = reader.ReadToEnd();
//}
//string retval ="" ;
//string retvalEx = _sendProcess.SendEmail(txtEmailID.Value, body, out retval);
string pwd = GenerateRandomCode();
_AdminModel.AdminUserPassword = pwd;
retvalstr = _adminViewModel.InsertAdminDetails(_AdminModel);
if (retvalstr.Contains("Email ID"))
{
ScriptManager.RegisterClientScriptBlock(this, this.GetType(), "Error", "javascript:alert('Email ID already Registered.');", true);
}
else if (retvalstr.Contains("User Added"))
{
bool retval = SendEmail(txtEmailID.Value, pwd);
if (retval == false)
{
ScriptManager.RegisterClientScriptBlock(this, this.GetType(), "Error", "javascript:alert('Unexpected error occured.Plese refresh the page and try again!');", true);
}
else
{
ScriptManager.RegisterClientScriptBlock(this, this.GetType(), "Error", "javascript:alert('Data saved sucessfully');", true);
}
}
}
}
catch (Exception ex)
{
ErrHandler.WriteError(ex.Message);
ScriptManager.RegisterClientScriptBlock(this, this.GetType(), "Error", "javascript:alert('Server is busy.Please try after sometime.');", true);
}
}
protected void btnUpdate_ServerClick(object sender, EventArgs e)
{
try
{
if (ValidatePage() == true)
{
AdminViewModel _adminViewModel = new AdminViewModel();
AdminModel _AdminModel = new AdminModel();
_AdminModel.AdminUserID = Convert.ToInt32(hdAdminID.Value);
_AdminModel.UserType = ddUserType.Text;
_AdminModel.AdminFullName = txtFullName.Value;
_AdminModel.AdminMobNo = txtMobileNo.Value;
_AdminModel.VenueID = ddVenueDetails.SelectedValue;
_AdminModel.AdminUserName = txtUserName.Value;
_AdminModel.AdminEmailID = txtEmailID.Value;
bool retval;
retval = _adminViewModel.UpdateAdminDetails(_AdminModel);
if (retval == true)
{
ScriptManager.RegisterStartupScript(this.Page, this.GetType(), "Add User", "<script type='text/javascript'>ConfirmMsg('Data saved sucessfully.','Add User');</script>", false);
}
else
{
ScriptManager.RegisterStartupScript(this.Page, this.GetType(), "Add User", "<script type='text/javascript'>ConfirmMsg('Unexpected error occured.Plese refresh the page and try again!','Add User');</script>", false);
}
//Response.Redirect("/AdminList.aspx");//-kk redirect
Response.Redirect("/AdminList.aspx", false);
Context.ApplicationInstance.CompleteRequest();
}
}
catch (Exception ex)
{
ErrHandler.WriteError(ex.Message);
ScriptManager.RegisterClientScriptBlock(this, this.GetType(), "Error", "javascript:alert('Server is busy.Please try after sometime.');", true);
}
}
private void GetAdminDetailsByID(int ID)
{
try
{
AdminViewModel _adminViewModel = new AdminViewModel();
AdminModel _adminModel = new AdminModel();
_adminModel = _adminViewModel.GetAdminDetails(ID);
txtFullName.Value = _adminModel.AdminFullName;
txtMobileNo.Value = _adminModel.AdminMobNo;
ddVenueDetails.SelectedValue = _adminModel.VenueID;
txtUserName.Value = _adminModel.AdminUserName;
txtEmailID.Value = _adminModel.AdminEmailID;
ddUserType.SelectedValue = _adminModel.UserType;
}
catch (Exception ex)
{
ErrHandler.WriteError(ex.Message);
ScriptManager.RegisterClientScriptBlock(this, this.GetType(), "Error", "javascript:alert('Server is busy.Please try after sometime.');", true);
}
}
////update
public bool UpdateAdminDetails(AdminModel adminModel)
{
try
{
using (SqlConnection conn = new SqlConnection(ConnString))
{
using (SqlCommand cmd = new SqlCommand("SL_PROC_UPDATEADMINDETAILS", conn))
{
conn.Open();
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.Add("@AdminUserID", SqlDbType.Int).Value = adminModel.AdminUserID;
cmd.Parameters.Add("@AdminUserName", SqlDbType.VarChar, 50).Value = adminModel.AdminUserName;
cmd.Parameters.Add("@AdminFullName", SqlDbType.VarChar, 100).Value = adminModel.AdminFullName;
cmd.Parameters.Add("@AdminMobNo", SqlDbType.VarChar, 20).Value = adminModel.AdminMobNo;
cmd.Parameters.Add("@VenueID", SqlDbType.Int).Value = adminModel.VenueID;
cmd.Parameters.Add("@AdminEmailID", SqlDbType.VarChar, 100).Value = adminModel.AdminEmailID;
cmd.Parameters.Add("@UserType", SqlDbType.VarChar, 10).Value = adminModel.UserType;
cmd.ExecuteNonQuery();
return true;
}
}
}
catch (Exception ex)
{
ErrHandler.WriteError(ex.Message);
return false;
}
}
//insert
public string InsertAdminDetails(AdminModel adminModel)
{
try
{
using (SqlConnection conn = new SqlConnection(ConnString))
{
conn.Open();
//cmd.CommandText = "SELECT name FROM server WHERE code = @code";
//cmd.Parameters.AddWithValue("@code", TextBox1.Text);
using (SqlCommand cmdAuth = new SqlCommand("SELECT Count(*) FROM AdminUser where AdminEmailID= @USERID", conn))
{
cmdAuth.Parameters.AddWithValue("@USERID",adminModel.AdminEmailID);
object retval = cmdAuth.ExecuteScalar();
if (Convert.ToInt32(retval) >= 1)
{
return "Email ID already exits.";
}
else
{
using (SqlCommand cmd = new SqlCommand("SL_PROC_INSERTADMINDETAILS", conn))
{
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.Add("@AdminUserID", SqlDbType.Int).Value = adminModel.AdminUserID;
cmd.Parameters.Add("@AdminUserName", SqlDbType.VarChar, 50).Value = adminModel.AdminUserName;
cmd.Parameters.Add("@AdminFullName", SqlDbType.VarChar, 100).Value = adminModel.AdminFullName;
cmd.Parameters.Add("@AdminMobNo", SqlDbType.VarChar, 20).Value = adminModel.AdminMobNo;
cmd.Parameters.Add("@AdminUserPassword", SqlDbType.VarChar, 50).Value = adminModel.AdminUserPassword;
cmd.Parameters.Add("@VenueID", SqlDbType.Int).Value = adminModel.VenueID;
cmd.Parameters.Add("@AdminEmailID", SqlDbType.VarChar, 100).Value = adminModel.AdminEmailID;
cmd.Parameters.Add("@UserType", SqlDbType.VarChar, 10).Value = adminModel.UserType;
cmd.ExecuteNonQuery();
return "User Added sucessfully.";
}
}
}
}
}
catch (Exception ex)
{
ErrHandler.WriteError(ex.Message);
throw ex;
}
}
public AdminModel GetAdminDetails(int AdminID)
{
AdminModel _adminModel = new AdminModel();
try
{
using (SqlConnection conn = new SqlConnection(ConnString))
{
using (SqlCommand cmd = new SqlCommand("SL_PROC_GETADMINDETAILS_BYID", conn))
{
conn.Open();
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.Add("@ADMINID", SqlDbType.Int).Value = AdminID;
SqlDataReader dr = cmd.ExecuteReader();
while (dr.Read())
{
_adminModel.AdminUserID = Convert.ToInt32(dr["AdminUserID"]);
_adminModel.AdminUserName = dr["AdminUserName"].ToString();
_adminModel.AdminFullName = dr["AdminFullName"].ToString();
_adminModel.AdminMobNo = dr["AdminMobNo"].ToString();
_adminModel.VenueID = dr["VenueID"].ToString();
_adminModel.AdminEmailID = dr["AdminEmailID"].ToString();
_adminModel.UserType = dr["UserType"].ToString();
// _adminModel.VenueName = dr["VenueName"].ToString();
}
}
}
return _adminModel;
}
catch (Exception ex)
{
ErrHandler.WriteError(ex.Message);
return null;
}
}