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);
}
