public HttpResponseMessage Put(Register r)
{
ClaimsPrincipal p = RequestContext.Principal as ClaimsPrincipal;
RegistersDA.UpdateRegister(r, p.Claims);
return new HttpResponseMessage(HttpStatusCode.OK);
}
public HttpResponseMessage Post(Register r)
{
ClaimsPrincipal p = RequestContext.Principal as ClaimsPrincipal;
int id = RegistersDA.InsertRegister(r, p.Claims);
HttpResponseMessage message = new HttpResponseMessage(HttpStatusCode.OK);
message.Content = new StringContent(id.ToString());
return message;
}
public static Register GetRegisterByID(int id, IEnumerable<Claim> claims)
{
Register reg = new Register();
string sql = "SELECT * FROM Register WHERE ID=@ID";
DbParameter parID = Database.AddParameter(Database.ADMIN_DB, "@ID", id);
DbDataReader reader = Database.GetData(Database.GetConnection(CreateConnectionString(claims)), sql, parID);
reader.Read();
reg = CreateClient(reader);
reader.Close();
return reg;
}
public static Register GetRegisterByID(int id)
{
Register reg = new Register();
string sql = "SELECT * FROM Register WHERE ID=@ID";
DbParameter parID = Database.AddParameter(Database.ADMIN_DB, "@ID", id);
DbDataReader reader = Database.GetData(Database.GetConnection(Database.ADMIN_DB), sql, parID);
while (reader.Read())
{
reg = Create(reader);
}
reader.Close();
return reg;
}
public static List<Sale> GetSalesByCustRegProdID(Customer c, Register r, Product p, IEnumerable<Claim> claims)
{
List<Sale> list = new List<Sale>();
string sql = "SELECT * FROM Sale WHERE CustomerID=@CID And RegisterID=@RID And ProductID=@PID";
DbParameter parCID = Database.AddParameter(Database.ADMIN_DB, "@CID", c.ID);
DbParameter parRID = Database.AddParameter(Database.ADMIN_DB, "@RID", r.ID);
DbParameter parPID = Database.AddParameter(Database.ADMIN_DB, "@PID", p.ID);
DbDataReader reader = Database.GetData(Database.GetConnection(CreateConnectionString(claims)), sql, parCID, parRID, parPID);
while (reader.Read())
{
list.Add(Create(reader));
}
reader.Close();
return list;
}
public int Put(Register r)
{
return RegistersDA.UpdateRegister(r);
}
public int Post(Register r)
{
return RegistersDA.InsertRegister(r);
}
public static List<Sale> GetSalesByRegisterID(Register r, IEnumerable<Claim> claims)
{
List<Sale> list = new List<Sale>();
string sql = "SELECT * FROM Sale WHERE RegisterID=@ID";
DbParameter parID = Database.AddParameter(Database.ADMIN_DB, "@ID", r.ID);
DbDataReader reader = Database.GetData(Database.GetConnection(CreateConnectionString(claims)), sql,parID);
while (reader.Read())
{
list.Add(Create(reader));
}
reader.Close();
return list;
}
public static int InsertRegister(Register reg)
{
string sql = "INSERT INTO Register VALUES(@RegisterName,@Device,@PurchaseDate,@ExpiresDate)";
DbParameter par1 = Database.AddParameter(Database.ADMIN_DB, "@RegisterName", reg.RegisterName);
DbParameter par2 = Database.AddParameter(Database.ADMIN_DB, "@Device", reg.Device);
DbParameter par3 = Database.AddParameter(Database.ADMIN_DB, "@PurchaseDate", reg.PurchaseDate);
DbParameter par4 = Database.AddParameter(Database.ADMIN_DB, "@ExpiresDate", reg.ExpiresDate);
return Database.InsertData(Database.GetConnection(Database.ADMIN_DB), sql, par1, par2, par3, par4);
}
public static int InsertRegister(Register reg, IEnumerable<Claim> claims)
{
string sql = "INSERT INTO Register VALUES(@RegisterName,@Device,@PurchaseDate,@ExpiresDate)";
DbParameter par1 = Database.AddParameter(Database.ADMIN_DB, "@RegisterName", reg.RegisterName);
DbParameter par2 = Database.AddParameter(Database.ADMIN_DB, "@Device", reg.Device);
return Database.InsertData(Database.GetConnection(CreateConnectionString(claims)), sql, par1, par2);
}
public static int UpdateRegister(Register reg)
{
string sql = "UPDATE Register SET RegisterName=@RegisterName, Device=@Device, PurchaseDate=@PurchaseDate, ExpiresDate=@ExpiresDate WHERE ID=@ID";
DbParameter par1 = Database.AddParameter(Database.ADMIN_DB, "@RegisterName", reg.RegisterName);
DbParameter par2 = Database.AddParameter(Database.ADMIN_DB, "@Device", reg.Device);
DbParameter par3 = Database.AddParameter(Database.ADMIN_DB, "@PurchaseDate", reg.PurchaseDate);
DbParameter par4 = Database.AddParameter(Database.ADMIN_DB, "@ExpiresDate", reg.ExpiresDate);
DbParameter parID = Database.AddParameter(Database.ADMIN_DB, "@ID", reg.ID);
return Database.ModifyData(Database.GetConnection(Database.ADMIN_DB), sql, par1, par2, par3, par4, parID);
}
public static int UpdateRegister(Register reg, IEnumerable<Claim> claims)
{
string sql = "UPDATE Register SET RegisterName=@RegisterName, Device=@Device WHERE ID=@ID";
DbParameter par1 = Database.AddParameter(Database.ADMIN_DB, "@RegisterName", reg.RegisterName);
DbParameter par2 = Database.AddParameter(Database.ADMIN_DB, "@Device", reg.Device);
DbParameter parID = Database.AddParameter(Database.ADMIN_DB, "@ID", reg.ID);
return Database.ModifyData(Database.GetConnection(CreateConnectionString(claims)), sql, par1, par2, parID);
}
