//function overload
public List <UserInfo> GetUserList()
{
SqlDbAccess dbAccess = new SqlDbAccess();
SqlCommand cmd = dbAccess.GetCommand("SELECT * FROM UserInfo");
//SqlParameter param1 = new SqlParameter("@title", SqlDbType.VarChar, 5);
//param1.Value = str1;
//SqlParameter param2 = new SqlParameter("@title1", SqlDbType.VarChar, 20);
//param2.Value = str2;
//cmd.Parameters.Add(param1);
//cmd.Parameters.Add(param2);
cmd.Connection.Open();
int val = cmd.ExecuteNonQuery();
cmd.Connection.Close();
List <UserInfo> userList = GetData(cmd);
return(userList);
}
//Function to insert userinformation
public bool Insert(UserInfo userObj)
{
SqlDbAccess dbAccessObj = new SqlDbAccess();
SqlCommand cmd = dbAccessObj.GetCommand("INSERT INTO UserInfo VALUES(@title1, @title2, @title3, @title4, @title5, @title6, @title7, @title8, @title9, @title10)");
cmd.Connection.Open();
SqlParameter param1 = new SqlParameter("@title1", SqlDbType.VarChar, 20);
param1.Value = userObj.Name;
SqlParameter param2 = new SqlParameter("@title2", SqlDbType.VarChar, 50);
param2.Value = userObj.Contact;
SqlParameter param3 = new SqlParameter("@title3", SqlDbType.VarChar, 50);
param3.Value = userObj.Email;
SqlParameter param4 = new SqlParameter("@title4", SqlDbType.VarChar, 5);
param4.Value = userObj.BloodGroup;
SqlParameter param5 = new SqlParameter("@title5", SqlDbType.VarChar, 10);
param5.Value = userObj.Religion;
SqlParameter param6 = new SqlParameter("@title6", SqlDbType.VarChar, 10);
param6.Value = userObj.Gender;
SqlParameter param7 = new SqlParameter("@title7", SqlDbType.VarChar, 50);
param7.Value = userObj.LastDateOfBloodDonatin;
SqlParameter param8 = new SqlParameter("@title8", SqlDbType.VarChar, 20);
param8.Value = userObj.Division;
SqlParameter param9 = new SqlParameter("@title9", SqlDbType.VarChar, 10);
param9.Value = userObj.Area;
SqlParameter param10 = new SqlParameter("@title10", SqlDbType.VarChar, 50);
param10.Value = userObj.PassWord;
cmd.Parameters.Add(param1);
cmd.Parameters.Add(param2);
cmd.Parameters.Add(param3);
cmd.Parameters.Add(param4);
cmd.Parameters.Add(param5);
cmd.Parameters.Add(param6);
cmd.Parameters.Add(param7);
cmd.Parameters.Add(param8);
cmd.Parameters.Add(param9);
cmd.Parameters.Add(param10);
int val = cmd.ExecuteNonQuery();
cmd.Connection.Close();
return(val > 0);
}