public int Insert(TCredential obj)
{
con.Open();
OracleCommand cmd = con.CreateCommand();
if (typeof(TCredential) == typeof(BuyerCredential))
{
BuyerCredential b = obj as BuyerCredential;
cmd.CommandText = "insert into buyercredentials values(DEFAULT," + b.BuyerId + ",'" + b.Username + "','" + b.Password + "','active')";
}
else if (typeof(TCredential) == typeof(SellerCredential))
{
SellerCredential c = obj as SellerCredential;
cmd.CommandText = "insert into sellercredentials values(DEFAULT," + c.SellerId + ",'" + c.Username + "','" + c.Password + "','active')";
}
int result = cmd.ExecuteNonQuery();
con.Close();
return(result);
}
public ActionResult BuyerLogin(BuyerCredential credential)
{
buyerService = Injector.Container.Resolve <ICredentialService <BuyerCredential> >();
BuyerCredential credentialFromDb = buyerService.ValidateCredential(credential) as BuyerCredential;
try
{
if (credentialFromDb.Status)
{
Session["USERID"] = credentialFromDb.BuyerId;
Session["USER"] = "******";
return(RedirectToAction("Index", "Buyer", new { id = credentialFromDb.BuyerId }));
}
else
{
return(View("Blocked"));
}
}
catch (Exception)
{
return(View("Error"));
}
}
public Credential GetById(int id)
{
con.Open();
OracleCommand cmd = con.CreateCommand();
if (typeof(TCredential) == typeof(BuyerCredential))
{
BuyerCredential bc = null;
cmd.CommandText = "select * from buyercredentials where buyerid=" + id;
OracleDataReader reader = cmd.ExecuteReader();
if (reader.Read())
{
bc = new BuyerCredential()
{
Id = reader.GetInt32(0), BuyerId = reader.GetInt32(1), Username = reader.GetString(2), Password = reader.GetString(3)
};
}
con.Close();
return(bc);
}
else if (typeof(TCredential) == typeof(SellerCredential))
{
SellerCredential sc = null;
cmd.CommandText = "select * from sellercredentials where sellerid=" + id;
OracleDataReader reader = cmd.ExecuteReader();
if (reader.Read())
{
sc = new SellerCredential()
{
Id = reader.GetInt32(0), SellerId = reader.GetInt32(1), Username = reader.GetString(2), Password = reader.GetString(3)
};
}
con.Close();
return(sc);
}
else
{
return(null);
}
}
public ActionResult BuyerRegistration(BuyerRegistrationViewModel buyerModel)
{
if (ModelState.IsValid)
{
Buyer buyer = new Buyer()
{
FirstName = buyerModel.FirstName, LastName = buyerModel.LastName, Gender = buyerModel.Gender, Email = buyerModel.Email, Phone = buyerModel.Phone, Address = buyerModel.Address, AreaId = Convert.ToInt32(buyerModel.AreaId)
};
if (buyerService.Insert(buyer) == 1)
{
buyer.Id = buyerService.GetLastBuyerId(buyer);
BuyerCredential credential = new BuyerCredential()
{
Username = buyerModel.Username, Password = buyerModel.Password, BuyerId = buyer.Id, Status = true
};
if (buyerCredentialService.Insert(credential) == 1)
{
return(RedirectToAction("Index", "Login", new { id = 1 }));
}
else
{
return(View("Error"));
}
}
else
{
return(View("Error"));
}
}
else
{
return(View(buyerModel));
}
}
public int UpdatePassword(TCredential obj)
{
con.Open();
OracleCommand cmd = con.CreateCommand();
if (typeof(TCredential) == typeof(BuyerCredential))
{
BuyerCredential bc = obj as BuyerCredential;
cmd.CommandText = "update buyercredentials set password='******' where id=" + bc.Id;
int result = cmd.ExecuteNonQuery();
con.Close();
return(result);
}
else if (typeof(TCredential) == typeof(SellerCredential))
{
SellerCredential sc = obj as SellerCredential;
cmd.CommandText = "update sellercredentials set password='******' where id=" + sc.Id;
int result = cmd.ExecuteNonQuery();
con.Close();
return(result);
}
else
{
return(0);
}
}
