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 SellerLogin(SellerCredential credential)
{
sellerService = Injector.Container.Resolve <ICredentialService <SellerCredential> >();
if (ModelState.IsValid)
{
SellerCredential credentialFromDb = sellerService.ValidateCredential(credential) as SellerCredential;
try
{
if (credentialFromDb.Status)
{
return(RedirectToAction("Index", "Seller", new { id = credentialFromDb.SellerId }));
}
else
{
return(View("Blocked"));
}
}
catch (Exception)
{
return(View("Error"));
}
}
else
{
return(View(credential));
}
}
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 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);
}
}
