public List <tblLogin> SearchUserDAL(string Name) { string sql = @"select * from tblLogin where FullName like '" + Name + "%'"; SqlDataReader reader = ReadData(sql); List <tblLogin> user = new List <tblLogin>(); while (reader.Read()) { string ID = reader.GetString(0); string FullName = reader.GetString(1); string Age = reader.GetString(2); string Address = reader.GetString(3); string Contact = reader.GetString(4); string Username = reader.GetString(5); string Password = reader.GetString(6); tblLogin tblLogin = new tblLogin(); tblLogin.ID = ID; tblLogin.FullName = FullName; tblLogin.Age = Age; tblLogin.Address = Address; tblLogin.Contact = Contact; tblLogin.Username = Username; tblLogin.Password = Password; user.Add(tblLogin); } reader.Close(); return(user); }
public bool AddUserDAL(tblLogin user) { string sql = "insert into tblLogin values(@ID, @FullName, @Age, @Address, @Contact, @Username, @Password)"; SqlParameter parameterID = new SqlParameter("@ID", SqlDbType.NVarChar); parameterID.Value = user.ID; SqlParameter parameterFullName = new SqlParameter("@FullName", SqlDbType.NVarChar); parameterFullName.Value = user.FullName; SqlParameter parameterAge = new SqlParameter("@Age", SqlDbType.NVarChar); parameterAge.Value = user.Age; SqlParameter parameterAddress = new SqlParameter("@Address", SqlDbType.NVarChar); parameterAddress.Value = user.Address; SqlParameter parameterContact = new SqlParameter("@Contact", SqlDbType.NVarChar); parameterContact.Value = user.Contact; SqlParameter parameterUsername = new SqlParameter("@Username", SqlDbType.NVarChar); parameterUsername.Value = user.Username; SqlParameter parameterPassword = new SqlParameter("@Password", SqlDbType.NVarChar); parameterPassword.Value = user.Password; bool result = WriteData(sql, new[] { parameterID, parameterFullName, parameterAge, parameterAddress, parameterContact, parameterUsername, parameterPassword }); return(result); }
public bool UpUserDAL(tblLogin user) { string up = "UPDATE tblLogin SET FullName = @fullname ,Age= @age,Address= @address,Contact= @contact,Username= @username,Password= @pass where ID = @id"; SqlParameter parID = new SqlParameter("@id", SqlDbType.VarChar); parID.Value = user.ID; SqlParameter parFullname = new SqlParameter("@fullname", SqlDbType.VarChar); parFullname.Value = user.FullName; SqlParameter parAge = new SqlParameter("@age", SqlDbType.VarChar); parAge.Value = user.Age; SqlParameter parAddress = new SqlParameter("@address", SqlDbType.VarChar); parAddress.Value = user.Address; SqlParameter parContact = new SqlParameter("@contact", SqlDbType.VarChar); parContact.Value = user.Contact; SqlParameter parUser = new SqlParameter("@username", SqlDbType.VarChar); parUser.Value = user.Username; SqlParameter parPass = new SqlParameter("@pass", SqlDbType.VarChar); parPass.Value = user.Password; bool kq = WriteData(up, new[] { parFullname, parID, parAge, parAddress, parContact, parUser, parPass }); return(kq); }
public int SaveProfile([FromBody] Profile obj) { if (obj != null) { if (obj.ID > 0) { var loginObj = db.tblLogins.Where(x => x.ID == obj.ID).ToList(); if (loginObj != null && loginObj.Count > 0) { loginObj[0].Password = obj.NewPassword; loginObj[0].EmailId = !string.IsNullOrEmpty(obj.Email) ? obj.Email : string.Empty; loginObj[0].Address = !string.IsNullOrEmpty(obj.Address) ? obj.Address : string.Empty; loginObj[0].City = !string.IsNullOrEmpty(obj.City) ? obj.City : string.Empty; loginObj[0].ZipCode = obj.ZipCode; loginObj[0].ProfilePicture = ConvertBase64StringToByteArray(obj.ProfilePicture); loginObj[0].State = obj.State; db.Entry(loginObj[0]).State = EntityState.Modified; db.SaveChanges(); } } else { tblLogin loginObj = new tblLogin() { UserName = obj.UserName, Password = obj.NewPassword, EmailId = !string.IsNullOrEmpty(obj.Email) ? obj.Email : string.Empty, Address = !string.IsNullOrEmpty(obj.Address) ? obj.Address : string.Empty, City = !string.IsNullOrEmpty(obj.City) ? obj.City : string.Empty, State = obj.State, ZipCode = obj.ZipCode, IsAdmin = obj.IsAdmin, ProfilePicture = ConvertBase64StringToByteArray(obj.ProfilePicture) }; db.tblLogins.Add(loginObj); int loginID = db.SaveChanges(); if (loginID > 0) { tblConsumer consumerObj = new tblConsumer() { ConsumerNo = obj.ConsumerNo, ConsumerName = obj.UserName, RegionCode = obj.RegionCode, Login_ID = loginObj.ID }; db.tblConsumers.Add(consumerObj); db.SaveChanges(); } return(loginObj.ID); } } return(obj.ID); }
public SqlDataReader getLogin(tblLogin login) { string sql = @"select * from tblLogin where Username like @Username and Password like @Password "; SqlParameter parameterUserName = new SqlParameter("@Username", SqlDbType.VarChar); parameterUserName.Value = login.Username; SqlParameter parameterPassword = new SqlParameter("@Password", SqlDbType.VarChar); parameterPassword.Value = login.Password; SqlDataReader reader = ReadData(sql, new[] { parameterUserName, parameterPassword }); return(reader); }