not passing values

i was trying to create a simple service for login. but the value is not getting in respository class. i think i miss some code..can anyone help me ..? thanks in advance.

here is my code for controller

static LoginRespository repository = new LoginRespository();
public string AddEmployees(Login Emp)
{
var response = repository.AddEmployees(Emp);
return response;
}

and respository class here

public string AddEmployees(Login Emp)
{
SqlCommand com;
SqlConnection con = new SqlConnection(@"Data Source=DOTNET;Initial Catalog=edin;Integrated Security=True;Pooling=False");
try
{
com = new SqlCommand("select * from data where name='" + Emp.username + "'", con);
con.Open();
SqlDataReader dr = com.ExecuteReader();
if (dr.HasRows)
{
return "success";
}
else
{
return "error";
}
con.Close();
}
catch (Exception aa)
{
return aa.ToString();
}
}

and my model class

public string username { get; set; }
public string password { get; set; }

can anyone tell what mistake i have made..

2 Replies

Know the answer? Post it — somebody with the same question will find it here.

Bikesh Srivastava10y ago
Hi,
You are doing good.
But i think you need to use break point to debug your code on each function and then check where value is not coming.
Manas Mohapatra10y ago
First debug it and then when it shows the null value.
As per your code-base it looks ok...