public Userregistration Logincred(login dd)
{
Userregistration userreglst = new Userregistration();
try
{
SqlCommand cmd = new SqlCommand("USER_LOGIN", conn);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@USERID", dd.Username);
cmd.Parameters.AddWithValue("@PASSWORD", dd.Password);
Connection();
SqlDataReader dr = cmd.ExecuteReader();
// Userregistration ur;
while (dr.Read())
{
userreglst.STATUS = dr["STATUS"] != null ? dr["STATUS"].ToString() : "";
//userreglst.Add(ur);
}
return(userreglst);
}
catch (Exception ch)
{
return(userreglst);
}
finally
{
conn.Close();
}
}
public List <Userregistration> Login()
{
List <Userregistration> userreglist = new List <Userregistration>();
try
{
SqlCommand cmd = new SqlCommand("GET_USERDATA", conn);
cmd.CommandType = CommandType.StoredProcedure;
Connection();
SqlDataReader dr = cmd.ExecuteReader();
Userregistration userreglst1;
while (dr.Read())
{
userreglst1 = new Userregistration();
userreglst1.Userid = dr["USER_ID"] != null?Convert.ToInt32(dr["USER_ID"]) : 0;
userreglst1.FIRSTNAME = dr["Username"] != null ? dr["Username"].ToString() : "";
userreglst1.PASSWORD = dr["PASSWORD"] != null ? dr["PASSWORD"].ToString() : "";
userreglst1.CONFORMPASSWORD = dr["CONFIRMPASSWORD"] != null ? dr["CONFIRMPASSWORD"].ToString() : "";
userreglst1.EMAILID = dr["EMAIL_ID"] != null ? dr["EMAIL_ID"].ToString() : "";
userreglst1.MOBILENUMBER = dr["MOBILE_NUMBER"] != null ? dr["MOBILE_NUMBER"].ToString() : "";
userreglst1.AAdharnumber = dr["AADHARNUMBER"] != null ? dr["AADHARNUMBER"].ToString() : "";
userreglst1.LASTLOGINTIME = dr["LASTLOGINTIME"] != null ? dr["LASTLOGINTIME"].ToString() : "";
userreglst1.STATUS = dr["STATUS"] != null ? dr["STATUS"].ToString() : "";
userreglst1.uniqueid = dr["UNIQUEID"] != null ? dr["UNIQUEID"].ToString() : "";
userreglst1.Role = dr["ROLE"] != null ? dr["ROLE"].ToString() : "";
userreglst1.createdate = dr["CREATED_DATE"] != null ? dr["CREATED_DATE"].ToString() : "";
userreglist.Add(userreglst1);
}
return(userreglist);
}
catch (Exception ch)
{
return(userreglist);
}
finally
{
conn.Close();
}
}
public Userregistration Create_user(Userregistration userreg)
{
Userregistration dd = new Userregistration();
try
{
SqlCommand cmd = new SqlCommand("Insert_USERREGISTRATION", conn);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@FINAME", userreg.FIRSTNAME);
cmd.Parameters.AddWithValue("@LASTNAME ", userreg.LASTNAME);//it is related to aadharnumber property
cmd.Parameters.AddWithValue("@PASSWORD", userreg.PASSWORD);
cmd.Parameters.AddWithValue("@CONFORMPASSWORD", userreg.CONFORMPASSWORD);
cmd.Parameters.AddWithValue("@EMAILID", userreg.EMAILID);
cmd.Parameters.AddWithValue("@MOBILENUMBER", userreg.MOBILENUMBER);
//cmd.Parameters.AddWithValue("@LASTLOGINTIME", "fsf");
cmd.Parameters.AddWithValue("@STATUS", "ACTIVE");
Connection();
SqlDataReader dr = cmd.ExecuteReader();
while (dr.Read())
{
//var dd = new Userregistration();
dd.FIRSTNAME = dr["USER_ID"].ToString();
}
dr.Close();
return(dd);
}
catch (Exception ex)
{
dd.STATUS = ex.ToString();
return(dd);
}
finally
{
conn.Close();
}
}