public static int CreateKassa(ItRegister reg)
{
string sql = "INSERT INTO Registers (RegisterName,Device,purchaseDate,ExpiresDate)VALUES (@Register,@Device,@purchase, @expire)";
DbParameter par1 = Database.addParameter("AdminConnection", "@Register", reg.RegisterName);
DbParameter par2 = Database.addParameter("AdminConnection", "@Device", reg.Device);
DbParameter par3 = Database.addParameter("AdminConnection", "@purchase", reg.PurchaseDate);
DbParameter par4 = Database.addParameter("AdminConnection", "@expire", reg.ExpireDate);
return(Database.InsertData("AdminConnection", sql, par1, par2, par3, par4));
}
public static int ChangeKassa(ItRegister reg)
{
string sql = "Update Registers set RegisterName = @Register,Device = @Device,purchaseDate= @purchase,ExpiresDate= @expire where Id = @id";
DbParameter par1 = Database.addParameter("AdminConnection", "@Register", reg.RegisterName);
DbParameter par2 = Database.addParameter("AdminConnection", "@Device", reg.Device);
DbParameter par3 = Database.addParameter("AdminConnection", "@purchase", reg.PurchaseDate);
DbParameter par4 = Database.addParameter("AdminConnection", "@expire", reg.ExpireDate);
DbParameter par5 = Database.addParameter("AdminConnection", "@id", reg.Id);
return(Database.ModifyData("AdminConnection", sql, par1, par2, par3, par4, par5));
}
private static PMKassa CreateKassa(IDataRecord reader)
{
ItRegister nieuw = new ItRegister()
{
Id = Convert.ToInt32(reader["Id"].ToString()),
RegisterName = reader["RegisterName"].ToString(),
Device = reader["Device"].ToString(),
PurchaseDate = Convert.ToInt32(reader["PurchaseDate"].ToString()),
ExpireDate = Convert.ToInt32(reader["ExpiresDate"].ToString()),
};
PMKassa kassa = new PMKassa();
kassa.Kassa = nieuw;
string org;
if (reader["OrganisationName"].ToString() == "")
{
org = "/";
}
else
{
org = reader["OrganisationName"].ToString();
}
kassa.OrganisationName = org;
if (reader["FromDate"].ToString() != "")
{
kassa.Fromdate = Convert.ToInt32(reader["FromDate"].ToString());
}
if (reader["UntilDate"].ToString() != "")
{
kassa.UntilDate = Convert.ToInt32(reader["UntilDate"].ToString());
}
if (reader["IdOrg"].ToString() != "")
{
kassa.IdOrganisation = Convert.ToInt32(reader["Idorg"].ToString());
}
return(kassa);
}
public PMKassa()
{
Kassa = new ItRegister();
}
