private string BL_CMSLoginCheck(EL_CMS.EL_UserDetails EEO)
{
string rtnString = "0";
SqlCommand cmd = new SqlCommand();
cmd.Connection = gc.cn;
if (cmd.Connection.State == ConnectionState.Closed)
{
cmd.Connection.Open();
}
cmd.CommandText = "checkUseLoginValid";
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@emailId", EEO.Username);
cmd.Parameters.AddWithValue("@passcode", EEO.Password);
SqlDataReader dr = cmd.ExecuteReader();
if (dr.HasRows)
{
while (dr.Read())
{
rtnString = dr.GetString(0);
}
}
dr.Close();
cmd.Connection.Close();
return(rtnString);
}
private string BL_GetUsrNmeRole(EL_CMS.EL_UserDetails EEO)
{
string rtnString = "0";
SqlCommand cmd = new SqlCommand();
cmd.Connection = gc.cn;
if (cmd.Connection.State == ConnectionState.Closed)
{
cmd.Connection.Open();
}
cmd.CommandText = "getUsrNmeDesgByEMailPasscode";
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@emailId", EEO.Username.Trim());
cmd.Parameters.AddWithValue("@passcode", EEO.Password.Trim());
SqlDataReader dr = cmd.ExecuteReader();
if (dr.HasRows)
{
while (dr.Read())
{
rtnString = dr["rtnMsg"].ToString();
}
}
dr.Close();
cmd.Connection.Close();
return(rtnString);
}
private string BL_Register_Client_Details(EL_CMS.EL_UserDetails ES)
{
string rtnmsg = "";
SqlCommand cmd = new SqlCommand();
cmd.Connection = gc.cn;
if (cmd.Connection.State == ConnectionState.Closed)
{
cmd.Connection.Open();
}
cmd.CommandText = "Registration_User_Details_SP";
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@name", ES.Username);
cmd.Parameters.AddWithValue("@password", ES.Password);
cmd.Parameters.AddWithValue("@address", ES.Address);
cmd.Parameters.AddWithValue("@email", ES.Emailadd);
cmd.Parameters.AddWithValue("@contact", ES.contactno);
SqlDataReader dr = cmd.ExecuteReader();
while (dr.Read())
{
rtnmsg = dr["rtnMsg"].ToString();
}
dr.Close();
cmd.Connection.Close();
return(rtnmsg);
}
public string CMSLoginCheck()
{
string chkvalidusr = "";
string G_xml = getRequestStreamData();
JavaScriptSerializer js = new JavaScriptSerializer();
var obj = js.Deserialize <Dictionary <string, string> >(G_xml);
EL_CMS.EL_UserDetails EEO = new EL_CMS.EL_UserDetails();
EEO.Username = obj["uname"];
EEO.Password = obj["pass"];
chkvalidusr = bl.BL_JSON_CMSLoginCheck(EEO);
if (chkvalidusr.Trim() == "1")
{
chkvalidusr = bl.BL_JSON_GetUsrNmeRole(EEO);
}
return(chkvalidusr);
}
public string Register_Client_Details()
{
string G_xml = getRequestStreamData();
JavaScriptSerializer js = new JavaScriptSerializer();
var obj = js.Deserialize <Dictionary <string, string> >(G_xml);
EL_CMS.EL_UserDetails ES = new EL_CMS.EL_UserDetails();
ES.Username = obj["username"];
ES.Emailadd = obj["emailAdd"];
ES.Password = obj["newpass"];
ES.Address = obj["address"];
ES.contactno = obj["contacNum"];
return(bl.BL_JSON_Register_Client_Details(ES));
}
public string BL_JSON_GetUsrNmeRole(EL_CMS.EL_UserDetails EEO)
{
string PNCL_Dt = this.BL_GetUsrNmeRole(EEO);
return(PNCL_Dt);
}
public string BL_JSON_CMSLoginCheck(EL_CMS.EL_UserDetails EEO)
{
string PNCL_Dt = this.BL_CMSLoginCheck(EEO);
return(PNCL_Dt);
}
public string BL_JSON_Register_Client_Details(EL_CMS.EL_UserDetails ES)
{
string PNCL_Dt = this.BL_Register_Client_Details(ES);
return(PNCL_Dt);
}
