public DataSet SignWithPassword(SignCls _ur)
{
DataSet dt = new DataSet();
try
{
SqlConnection con = new SqlConnection(conStr);
SqlCommand cmd = new SqlCommand("sp_check_LoginStatus", con);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@i_userid", _ur.emailid);
cmd.Parameters.AddWithValue("@i_pwd", _ur.password);
cmd.Parameters.AddWithValue("@i_type", _ur.usertype);
con.Open();
SqlDataAdapter da = new SqlDataAdapter(cmd);
da.Fill(dt);
con.Close();
}
catch (Exception ex)
{
dt = null;
}
return(dt);
}
public Response SignIn_with_Password(SignCls model)
{
try
{
var response = new Response();
DataSet ds = null;
ds = blObj.SignWithPassword(model);
List <PesrsonalUserRes> userdetails = new List <PesrsonalUserRes>();
if (ds.Tables[0].Rows[0][0].ToString() == "200")
{
if (ds.Tables[1].Rows.Count > 0)
{
foreach (DataRow dr in ds.Tables[1].Rows)
{
PesrsonalUserRes data = new PesrsonalUserRes();
data.FirstName = dr["FirstName"].ToString();
data.LastName = dr["LastName"].ToString();
data.Mobile = dr["Mobile"].ToString();
data.Email = dr["Email"].ToString();
data.UserType = dr["UserType"].ToString();
data.LastLoginDateTime = dr["LastLoginTime"].ToString();
userdetails.Add(data);
}
response = new Response
{
ResponseCode = ds.Tables[0].Rows[0]["Statuscode"].ToString(),
ResponseMessage = ds.Tables[0].Rows[0]["Message"].ToString(),
ResponseList = new
{
userdetails
}
};
}
else
{
response = new Response
{
ResponseCode = ds.Tables[0].Rows[0]["Statuscode"].ToString(),
ResponseMessage = ds.Tables[0].Rows[0]["Message"].ToString()
};
}
}
else
{
response = new Response
{
ResponseCode = ds.Tables[0].Rows[0]["Statuscode"].ToString(),
ResponseMessage = ds.Tables[0].Rows[0]["Message"].ToString()
};
}
return(response);
}
catch (Exception ex)
{
return(new Response
{
ResponseCode = Common.ReturnCode("ErrorCode"),
ResponseMessage = Common.ReturnCode("ErrorMessage")
});
}
}
