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(); }