public RegisterOrganisation Post(RegisterOrganisation r) { int id = RegistersOrganisation.Insert(Claims.GetConnectionString(User), r); r.ID = id; return(r); }
public static void EditRegistersOrganisation(RegistersOrganisation or) { string sql = "UPDATE Organisation_Register SET OrganisationID=@OrganisationID, RegisterID=@RegisterID, FromDate=@FromDate, UntilDate=@UntilDate WHERE OrganisationID=@OrganisationID"; DbParameter par1 = Database.addParameter(ConnectionString, "@OrganisationID", or.Organisationid); DbParameter par2 = Database.addParameter(ConnectionString, "@RegisterID", or.RegisterId); DbParameter par3 = Database.addParameter(ConnectionString, "@FromDate", or.From); DbParameter par4 = Database.addParameter(ConnectionString, "@UntilDate", or.Untill); Database.ModifyData(Database.GetConnection(ConnectionString), sql, par1, par2, par3, par4); }
public static RegistersOrganisation GetRegisters_Organisation(int ID) { RegistersOrganisation or = new RegistersOrganisation(); string sql = "SELECT OrganisationID, RegisterID, FromDate, UntilDate FROM Organisation_Register WHERE RegisterID=@RegisterID"; DbParameter par1 = Database.addParameter(ConnectionString, "@RegisterID", ID); DbDataReader reader = Database.GetData(Database.GetConnection(ConnectionString), sql, par1); while (reader.Read()) { or = Create(reader); } reader.Close(); return(or); }
public static int InsertOrganisation_Register(RegistersOrganisation or) { try { string sql = "INSERT INTO Organisation_Register VALUES(@OrganisationID, @RegisterID, @FromDate, @UntilDate)"; DbParameter par1 = Database.addParameter(ConnectionString, "@OrganisationID", or.Organisationid); DbParameter par2 = Database.addParameter(ConnectionString, "@RegisterID", or.RegisterId); DbParameter par3 = Database.addParameter(ConnectionString, "@FromDate", or.From.ToString("yyyy-MM-dd")); DbParameter par4 = Database.addParameter(ConnectionString, "@UntilDate", or.Untill.ToString("yyyy-MM-dd")); return(Database.InsertData(Database.GetConnection(ConnectionString), sql, par1, par2, par3, par4)); } catch (Exception) { return(0); } }
public ActionResult AssignToOrganisation(int regid, int orgid) { RegistersOrganisation ro = new RegistersOrganisation() { RegisterId = regid, Organisationid = orgid, From = DateTime.Now.Date, Untill = DateTime.Now.Date.AddYears(10) }; Register_OrganisationDA.InsertOrganisation_Register(ro); Register_OrganisationDA.ModifyRegisterAssignValue(regid); Organisation o = OrganisationDA.GetOrganisations(orgid); Register r = RegisterDA.GetRegisters(regid); RegisterClientDAcs.ChangeConnectionString("System.Data.SqlClient", "MCT-NIELS" + @"\DATAMANAGEMENT", Cryptography.Decrypt(o.DbName), Cryptography.Decrypt(o.DbLogin), Cryptography.Decrypt(o.DbPassword)); RegisterClientDAcs.InsertRegister(r); return(View("Succeeded")); }
public HttpStatusCode Delete(long id) { RegistersOrganisation.Delete(Claims.GetConnectionString(User), id); return(HttpStatusCode.OK); }
public HttpStatusCode Put(long id, RegisterOrganisation r) { RegistersOrganisation.Update(Claims.GetConnectionString(User), id, r); return(HttpStatusCode.OK); }
public List <RegisterOrganisation> Get() { return(RegistersOrganisation.Get(Claims.GetConnectionString(User))); }