/// <summary> /// Removes teacherSubject from given yearClassSection /// </summary> /// <param name="teahcerId">Id of corresponding teacher</param> /// <param name="subjectId">Id of corresponding subject</param> /// <param name="yearClassSectionId">Id of corresponding yearClassSection entry</param> /// <returns>Number of entries removed</returns> public int RemoveTeacherSubject(object teahcerId, object subjectId, object yearClassSectionId) { return(db.Execute("removeTeacherSubject", new Dictionary <string, object>() { { "@TId", teahcerId }, { "@SId", subjectId }, { "@YCSId", yearClassSectionId } }, true)); }
/// <summary> /// Removes all term exist in given YearClassSection /// </summary> /// <param name="yearClassSectionId">Id of corresponding yearClassSection entry</param> /// <returns>Number of entries deleted</returns> public int RemoveTermByYearClassSection(int yearClassSectionId) { return(db.Execute("removeTermByYCSId", new Dictionary <string, object>() { { "@YCSId", yearClassSectionId } }, true)); }
/// <summary> /// Removes given class from given year /// </summary> /// <param name="yearId">Id of corresponding year entry</param> /// <param name="classId">Id of corresponding class entry</param> /// <returns>Number of entries removed</returns> public int RemoveClassFromYear(object yearId, object classId) { return(db.Execute("removeYCSByYIdCId", new Dictionary <string, object>() { { "@YId", yearId }, { "@CId", classId } }, true)); }
/// <summary> /// Deletes all branches from a user in the UserBranches table /// </summary> /// <param name="userId">The user's id</param> /// <returns></returns> public int Delete(string userId) { string commandText = "Delete from userbranches where UserId = @userId"; Dictionary <string, object> parameters = new Dictionary <string, object>(); parameters.Add("UserId", userId); return(_database.Execute(commandText, parameters)); }
/// <summary> /// Deltes a role from the Roles table /// </summary> /// <param name="roleId">The role Id</param> /// <returns></returns> public int Delete(string roleId) { string commandText = "Delete from roles where Id = @id"; Dictionary <string, object> parameters = new Dictionary <string, object>(); parameters.Add("@id", roleId); return(_database.Execute(commandText, parameters)); }
/// <summary> /// Sets the user's password hash /// </summary> /// <param name="userId"></param> /// <param name="passwordHash"></param> /// <returns></returns> public int SetPasswordHash(string userId, string passwordHash) { string commandText = "Update users set PasswordHash = @pwdHash where Id = @id"; Dictionary <string, object> parameters = new Dictionary <string, object>(); parameters.Add("@pwdHash", passwordHash); parameters.Add("@id", userId); return(_database.Execute(commandText, parameters)); }
/// <summary> /// Inserts a new Bank in the Bank table /// </summary> /// <param name="bank">The Bank's detail</param> /// <returns></returns> public int Insert(IdentityBank bank) { string commandText = "Insert into banks (Id, BankName, BankAcronym) values (@id, @name, @acronym)"; Dictionary <string, object> parameters = new Dictionary <string, object>(); parameters.Add("@name", bank.Name); parameters.Add("@id", bank.Id); parameters.Add("@acronym", bank.Acronym); return(_database.Execute(commandText, parameters)); }
/// <summary> /// Deletes a login from a user in the UserLogins table /// </summary> /// <param name="user">User to have login deleted</param> /// <param name="login">Login to be deleted from user</param> /// <returns></returns> public int Delete(IdentityUser user, UserLoginInfo login) { string commandText = "Delete from UserLogins where UserId = @userId and LoginProvider = @loginProvider and ProviderKey = @providerKey"; Dictionary <string, object> parameters = new Dictionary <string, object>(); parameters.Add("UserId", user.Id); parameters.Add("loginProvider", login.LoginProvider); parameters.Add("providerKey", login.ProviderKey); return(_database.Execute(commandText, parameters)); }
/// <summary> /// Inserts a new Account Number in the accountnumbers table /// </summary> /// <param name="AccountNumber">The account's detail</param> /// <returns></returns> public int Insert(IdentityAccountNumber accountno) { string commandText = "Insert into accountnumbers (Id, AccountNumber, AccountName, AccountBranch) values (@id, @accountNumber, @accountname, @accountbranch)"; Dictionary <string, object> parameters = new Dictionary <string, object>(); parameters.Add("@id", accountno.Id); parameters.Add("@accountNumber", accountno.AccountNumber); parameters.Add("@accountName", accountno.AccountName); parameters.Add("@accountbranch", accountno.AccountBranch); return(_database.Execute(commandText, parameters)); }
public int RemoveMarkPortionFromSubject(object markPortionId) { return(db.Execute("removeMarkPortionByMPId", new Dictionary <string, object>() { { "MPId", markPortionId } }, true)); }
public int RemoveSubject(object subjectId, object yearId) { return(db.Execute("removeSubjectYear", new Dictionary <string, object>() { { "@SId", subjectId }, { "@YId", yearId } }, true)); }
/// <summary> /// Inserts a upload data record in the UploadData table /// </summary> /// <param name="uploaddata">The upload data record</param> /// <returns></returns> public int Insert(UploadDataEntity uploaddata) { string commandText = "Insert into uploadsdata (Id, UploadId, Narration, Amount, AccountNumber, DebitOrCredit, PostingCode, TranDate, Status, TranID) values (@Id, @uploadId, @narration, @amount, @accountNo, @debitcredit, @postingCode, @tranDate, @status, @tranId)"; Dictionary <string, object> parameters = new Dictionary <string, object>(); parameters.Add("@Id", uploaddata.Id); parameters.Add("@uploadId", uploaddata.UploadId); parameters.Add("@narration", uploaddata.Narration); parameters.Add("@amount", uploaddata.Amount); parameters.Add("@accountNo", uploaddata.AccountNumber); parameters.Add("@debitcredit", uploaddata.Debit1Credit0); parameters.Add("@postingCode", uploaddata.PostingCode); parameters.Add("@tranDate", uploaddata.TranDate); parameters.Add("@status", uploaddata.Status); parameters.Add("@tranId", uploaddata.TranID); return(_database.Execute(commandText, parameters)); }
/// <summary> /// Inserts a new Bank GL Account in the BankGLAccounts table /// </summary> /// <param name="bank">The Bank GL Account detail</param> /// <returns></returns> public int Insert(IdentityBankGLAccount bankGL) { string commandText = "Insert into bankglaccounts (Id, BankId, GLAccount) values (@id, @bankId, @glAccount)"; Dictionary <string, object> parameters = new Dictionary <string, object>(); parameters.Add("@bankId", bankGL.BankId); parameters.Add("@id", bankGL.Id); parameters.Add("@glAccount", bankGL.GLAccount); return(_database.Execute(commandText, parameters)); }
/// <summary> /// Deletes all uploads linekd to branch in uploads table /// </summary> /// <param name="branchId">The branch Id</param> /// <returns></returns> public int DeleteBranchUploads(string branchId) { string commandText = "Delete from uploads where BranchId = @id"; Dictionary <string, object> parameters = new Dictionary <string, object>(); parameters.Add("@id", branchId); return(_database.Execute(commandText, parameters)); }
/// <summary> /// Inserts a upload record in the uploads table /// </summary> /// <param name="upload">The upload record</param> /// <returns></returns> public int Insert(UploadEntity upload) { string commandText = "Insert into uploads (Id, UploaderId, BankId, BranchId, Status) values (@id, @uploaderId, @bankId, @branchId, @status)"; Dictionary <string, object> parameters = new Dictionary <string, object>(); parameters.Add("@id", upload.Id); parameters.Add("@uploaderId", upload.UploaderId); parameters.Add("@bankId", upload.BankId); parameters.Add("@branchId", upload.BranchId); parameters.Add("@status", upload.Status); return(_database.Execute(commandText, parameters)); }