public HttpResponseMessage DeleteUserInfo(string username)
{
ConsumerTable CT = db.ConsumerTables.Find(username);
if (CT == null)
{
return(Request.CreateResponse(HttpStatusCode.NotAcceptable));
//return NotFound();
}
else
{
var ad = (from admin in db.Admins
where admin.UserName == CT.UserName
select admin).ToList().FirstOrDefault();
try
{
db.Admins.Remove(ad);
db.Admins.Remove(ad);
db.ConsumerTables.Remove(CT);
db.SaveChanges();
return(Request.CreateResponse(HttpStatusCode.OK, "UserInfo Deleted"));
}
catch (Exception)
{
return(Request.CreateResponse(HttpStatusCode.OK, "You cannot delete Active user"));
}
}
}
private void BtnAdd_Click(object sender, RoutedEventArgs e)
{
if (Validate(textBoxName) && Validate(textBoxConsumption))
{
double result = 0;
bool uspelo = false;
uspelo = double.TryParse(textBoxConsumption.Text, out result);
if (uspelo && result >= 0)
{
ConsumerViewModel.consumers.Add(new ConsumerModel(textBoxName.Text, Double.Parse(textBoxConsumption.Text)));
using (dbSHESEntities entity = new dbSHESEntities())
{
ConsumerTable cmt = new ConsumerTable()
{
Name = textBoxName.Text,
Consumption = Double.Parse(textBoxConsumption.Text),
State = Enums.ConsumerEnum.OFF.ToString()
};
entity.ConsumerTables.Add(cmt);
entity.SaveChanges();
}
}
else
{
MessageBox.Show("Incorrect input", "Error", MessageBoxButton.OK, MessageBoxImage.Error);
}
}
else
{
MessageBox.Show("Incorrect input", "Error", MessageBoxButton.OK, MessageBoxImage.Error);
}
}
public void Execute()
{
ConsumerViewModel.consumers.Remove(consumerToDelete);
using (dbSHESEntities entity = new dbSHESEntities())
{
ConsumerTable cmt = entity.ConsumerTables.Where(x => x.Name == consumerToDelete.Name).SingleOrDefault();
if (cmt != null)
{
entity.ConsumerTables.Remove(cmt);
entity.SaveChanges();
}
};
}
public HttpResponseMessage updateuserinfo(string username, ConsumerTable consumer)
{
try
{
var userdata = (from con in db.ConsumerTables
where con.UserName == username
select con).FirstOrDefault();
userdata.Name = consumer.Name;
userdata.PhoneNo = consumer.PhoneNo;
userdata.Email = consumer.Email;
userdata.Address = consumer.Address;
db.SaveChanges();
return(Request.CreateResponse(HttpStatusCode.OK, "Record Updated"));
}
catch (Exception)
{
return(Request.CreateResponse(HttpStatusCode.OK, "Phone Number & Email should be Unique for Particular user"));
}
}
public HttpResponseMessage updateuserinfo(string username, ConsumerTable consumer)
{
var userdata = (from con in db.ConsumerTables
where con.UserName == username
select con).FirstOrDefault();
userdata.UserName = consumer.UserName;
userdata.Name = consumer.UserName;
userdata.PhoneNo = consumer.PhoneNo;
userdata.Email = consumer.Email;
userdata.Address = consumer.Address;
userdata.Password = consumer.Password;
userdata.CardType = consumer.CardType;
userdata.SelectBank = consumer.SelectBank;
userdata.IFSC_Code = consumer.IFSC_Code;
userdata.AccountNumber = consumer.AccountNumber;
db.SaveChanges();
return(Request.CreateResponse(HttpStatusCode.OK));
}
public HttpResponseMessage verifylogin(ConsumerTable logininfo)
{
try
{
var pas = (from consumer in db.ConsumerTables
where consumer.UserName == logininfo.UserName
select consumer.Password).FirstOrDefault();
System.Text.UTF8Encoding encoder = new System.Text.UTF8Encoding();
System.Text.Decoder decoder = encoder.GetDecoder();
byte[] todecode_byte = Convert.FromBase64String(pas);
int charCount = decoder.GetCharCount(todecode_byte, 0, todecode_byte.Length);
char[] decoded_char = new char[charCount];
decoder.GetChars(todecode_byte, 0, todecode_byte.Length, decoded_char, 0);
string pass = new String(decoded_char);
var user = (from consumer in db.ConsumerTables
where consumer.UserName == logininfo.UserName && pass == logininfo.Password
select consumer.UserName).FirstOrDefault();
var act = (from ad in db.Admins
where ad.UserName == logininfo.UserName
select ad.ActivationStatus).FirstOrDefault();
if (act == false)
{
return(Request.CreateResponse(HttpStatusCode.OK, "Not Activated by Admin"));
}
else if (user != null)
{
return(Request.CreateResponse(HttpStatusCode.OK, user));
}
else
{
return(Request.CreateResponse(HttpStatusCode.OK, "Invalid"));
}
}
catch (Exception e)
{
return(Request.CreateResponse(HttpStatusCode.OK, e.Message));
}
}
public IHttpActionResult PostRegister(ConsumerTable consumertable)
{
//if (!ModelState.IsValid)
//{
// return BadRequest(ModelState);
//}
//else
if (consumertable != null)
{
db.ConsumerTables.Add(consumertable);
try {
db.SaveChanges();
return(Ok("Registered successfully"));
}
catch (Exception)
{
return(BadRequest("Enter the data"));
}
}
else
{
return(BadRequest("Please enter the data"));
}
}
public HttpResponseMessage Adduser(ConsumerTable consumer)
{
var username = (from c in db.ConsumerTables
where c.UserName == consumer.UserName
select c.UserName).ToList();
if (username.Count > 0)
{
return(Request.CreateResponse(HttpStatusCode.OK, "This User Name is taken, Please Choose different username"));
}
else
{
var email = (from c in db.ConsumerTables
where c.Email == consumer.Email
select c.Email).ToList();
if (email.Count > 0)
{
return(Request.CreateResponse(HttpStatusCode.OK, "Userdata with given email already exists. Please choose different email or Login with current email"));
}
else
{
var phone = (from c in db.ConsumerTables
where c.PhoneNo == consumer.PhoneNo
select c.PhoneNo).ToList();
if (phone.Count > 0)
{
return(Request.CreateResponse(HttpStatusCode.OK, "Userdata with given Phone Number already exists. Please Login"));
}
else
{
DateTime currentdate = System.DateTime.Now;
TimeSpan time = currentdate.Subtract(consumer.DateofBirth);
if (time.Days < 3650)
{
return(Request.CreateResponse(HttpStatusCode.OK, "You are Not eligible. The user should be 10 years old or above"));
}
byte[] encData_byte = new byte[consumer.Password.Length];
encData_byte = System.Text.Encoding.UTF8.GetBytes(consumer.Password);
string encodedpassword = Convert.ToBase64String(encData_byte);
consumer.Password = encodedpassword;
ConsumerTable ct = new ConsumerTable();
ct.UserName = consumer.UserName;
ct.DateofBirth = consumer.DateofBirth;
ct.Name = consumer.Name;
ct.Email = consumer.Email;
ct.PhoneNo = consumer.PhoneNo;
ct.Password = consumer.Password;
ct.Address = consumer.Address;
ct.CardType = consumer.CardType;
ct.SelectBank = consumer.SelectBank;
ct.AccountNumber = consumer.AccountNumber;
ct.IFSC_Code = consumer.IFSC_Code;
try
{
db.ConsumerTables.Add(ct);
db.SaveChanges();
db.adduserinadmin(consumer.UserName);
db.SaveChanges();
return(Request.CreateResponse(HttpStatusCode.OK, "Registered Successfully!!!"));
}
catch (Exception)
{
return(Request.CreateResponse(HttpStatusCode.OK, "The mailid or the Name given is too large"));
}
}
}
}
}