public void Dispose()
{
if (UserDetails1 != null)
{
UserDetails1.Clear();
}
}
public static string ManageUserDetail(UserDetails1 UReg)
{
string msg = string.Empty;
SqlConnection conn = new SqlConnection(ConfigurationManager.ConnectionStrings["UserDetails"].ConnectionString);
conn.Open();
try
{
var Mac = GetMACAddress();
var ip = GetIPAddress();
var proce = GetProcessorId();
SqlCommand cmd = new SqlCommand("InsertUserRegistration", conn);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.Add("@UserTypeID", SqlDbType.BigInt).Value = UReg.UserType;
cmd.Parameters.Add("@UserName", SqlDbType.VarChar).Value = UReg.UserName;
cmd.Parameters.Add("@FirstName", SqlDbType.VarChar).Value = UReg.FirstName;
cmd.Parameters.Add("@LastName", SqlDbType.VarChar).Value = UReg.LastName;
cmd.Parameters.Add("@Address", SqlDbType.VarChar).Value = UReg.Address;
cmd.Parameters.Add("@CountryID", SqlDbType.BigInt).Value = UReg.Country;
cmd.Parameters.Add("@StateID", SqlDbType.BigInt).Value = UReg.State;
cmd.Parameters.Add("@CityID", SqlDbType.BigInt).Value = UReg.City;
cmd.Parameters.Add("@PinCode", SqlDbType.VarChar).Value = UReg.Pincode;
cmd.Parameters.Add("@Email", SqlDbType.VarChar).Value = UReg.Email;
cmd.Parameters.Add("@MobileNo", SqlDbType.VarChar).Value = UReg.MobileNo;
cmd.Parameters.Add("@noofuser", SqlDbType.VarChar).Value = UReg.UserSeletetion;
cmd.Parameters.Add("@CompanyName", SqlDbType.VarChar).Value = UReg.Comname;
cmd.Parameters.Add("@ApplicationName", SqlDbType.VarChar).Value = UReg.Application;
cmd.Parameters.Add("@Password", SqlDbType.VarChar).Value = UReg.Pwd;
cmd.Parameters.Add("@MacAddress", SqlDbType.VarChar).Value = Mac;
cmd.Parameters.Add("@IPAddress", SqlDbType.VarChar).Value = ip;
cmd.Parameters.Add("@MachineName", SqlDbType.NVarChar).Value = MachineName;
cmd.Parameters.Add("@ProcessorID", SqlDbType.VarChar).Value = proce;
cmd.Parameters.Add("@YearID", SqlDbType.BigInt).Value = HttpContext.Current.Session["FinancialYear"];
int i = Convert.ToInt16(cmd.ExecuteScalar().ToString());
cmd.Dispose();
conn.Close();
conn.Open();
SqlCommand cmd1 = new SqlCommand("CreateNodeNo", conn);
cmd1.CommandType = CommandType.StoredProcedure;
cmd1.Parameters.Add("@YearID", SqlDbType.BigInt).Value = HttpContext.Current.Session["FinancialYear"];
cmd1.Parameters.Add("@RegistrationID", SqlDbType.VarChar).Value = i;
cmd1.Parameters.Add("@NoofUser", SqlDbType.VarChar).Value = UReg.UserSeletetion;
cmd1.ExecuteScalar();
cmd.Dispose();
conn.Close();
#region Send Email to User including Verify Link
string strStatus = "";
XmlDocument XMLdoc = new XmlDocument();
XMLdoc.Load(HttpContext.Current.Server.MapPath("Email/AuthorRegistration.xml"));
XmlElement root = XMLdoc.DocumentElement;
XmlNodeList nodes = root.SelectNodes("/email");
string strSubject = "";
string strBody = "";
foreach (XmlNode node in nodes)
{
strSubject = node["subject"].InnerText;
strBody = node["messgae"].InnerText;
}
strBody = strBody.Replace("##USERNAME##", UReg.UserName);
strBody = strBody.Replace("##PASSWORD##", UReg.Pwd);
strBody = strBody.Replace("##VERIFYPAGEURL##", ConfigurationSettings.AppSettings["AdminSiteURL"].ToString() + "?RegNo=" + i);
strStatus = Mail.SendHTMLMail(ConfigurationManager.AppSettings["smtphost"].ToString(), "Jaimini Software Pvt. Ltd.", ConfigurationManager.AppSettings["From"].ToString(), UReg.Email.ToString(), Convert.ToInt32(ConfigurationSettings.AppSettings["port"].ToString()), strSubject, "", "", "", "", strBody);
#endregion
// }
}
catch (Exception ex)
{
// Global.ErrorInsert(ex.Message, formname, "UserManage");
msg = "Error" + ex.Message;
}
finally
{
if (conn.State == ConnectionState.Open)
{
conn.Close();
}
}
return(msg);
}
