Int64 IDMSFileTrackingDataAccess.Add(DMSFileTrackingEntity dMSFileTrackingEntity, DatabaseOperationType option, TransactionRequired reqTran) { try { long retValues = -99; switch (reqTran) { case TransactionRequired.No: { retValues = Add(dMSFileTrackingEntity, option); break; } case TransactionRequired.Yes: { retValues = AddTran(dMSFileTrackingEntity, option); break; } default: { retValues = -99; break; } } return(retValues); } catch (Exception ex) { throw ex; } }
private void SaveDMSFileTrackingEntity() { if (IsValid) { try { DMSFileTrackingEntity dMSFileTrackingEntity = BuildDMSFileTrackingEntity(); Int64 result = -1; if (dMSFileTrackingEntity.IsNew) { result = FCCDMSFileTracking.GetFacadeCreate().Add(dMSFileTrackingEntity, DatabaseOperationType.Add, TransactionRequired.No); } else { String filterExpression = SqlExpressionBuilder.PrepareFilterExpression(DMSFileTrackingEntity.FLD_NAME_FileTrackingID, dMSFileTrackingEntity.FileTrackingID.ToString(), SQLMatchType.Equal); result = FCCDMSFileTracking.GetFacadeCreate().Update(dMSFileTrackingEntity, filterExpression, DatabaseOperationType.Update, TransactionRequired.No); } if (result > 0) { _FileTrackingID = 0; _DMSFileTrackingEntity = new DMSFileTrackingEntity(); PrepareInitialView(); BindDMSFileTrackingList(); if (dMSFileTrackingEntity.IsNew) { MiscUtil.ShowMessage(lblMessage, "File Tracking Information has been added successfully.", false); } else { MiscUtil.ShowMessage(lblMessage, "File Tracking Information has been updated successfully.", false); } } else { if (dMSFileTrackingEntity.IsNew) { MiscUtil.ShowMessage(lblMessage, "Failed to add File Tracking Information.", false); } else { MiscUtil.ShowMessage(lblMessage, "Failed to update File Tracking Information.", false); } } } catch (Exception ex) { MiscUtil.ShowMessage(lblMessage, ex.Message, true); } } }
private Int64 Update(DMSFileTrackingEntity dMSFileTrackingEntity, String filterExpression, DatabaseOperationType option) { long returnCode = -99; const string SP = "dbo.DMSFileTracking_SET"; using (DbCommand cmd = Database.GetStoredProcCommand(SP)) { AddOptionParameter(cmd, option); AddOutputParameter(cmd); AddFilterExpressionParameter(cmd, filterExpression); Database.AddInParameter(cmd, "@FileTrackingID", DbType.Int64, dMSFileTrackingEntity.FileTrackingID); Database.AddInParameter(cmd, "@FileNo", DbType.String, dMSFileTrackingEntity.FileNo); Database.AddInParameter(cmd, "@FileName", DbType.String, dMSFileTrackingEntity.FileName); Database.AddInParameter(cmd, "@DepartmentID", DbType.Int64, dMSFileTrackingEntity.DepartmentID); Database.AddInParameter(cmd, "@CreatedByEmployeeID", DbType.Int64, dMSFileTrackingEntity.CreatedByEmployeeID); Database.AddInParameter(cmd, "@CreatedDateTime", DbType.DateTime, dMSFileTrackingEntity.CreatedDateTime); Database.AddInParameter(cmd, "@FileParmanentPlace", DbType.String, dMSFileTrackingEntity.FileParmanentPlace); Database.AddInParameter(cmd, "@FileCurrentPlace", DbType.String, dMSFileTrackingEntity.FileCurrentPlace); Database.AddInParameter(cmd, "@FileType", DbType.String, dMSFileTrackingEntity.FileType); Database.AddInParameter(cmd, "@SoftFileName", DbType.String, dMSFileTrackingEntity.SoftFileName); Database.AddInParameter(cmd, "@Extension", DbType.String, dMSFileTrackingEntity.Extension); Database.AddInParameter(cmd, "@Path", DbType.String, dMSFileTrackingEntity.Path); Database.AddInParameter(cmd, "@OriginalFileName", DbType.String, dMSFileTrackingEntity.OriginalFileName); Database.AddInParameter(cmd, "@CurrentFileName", DbType.String, dMSFileTrackingEntity.CurrentFileName); using (IDataReader reader = Database.ExecuteReader(cmd)) { returnCode = GetReturnCodeFromParameter(cmd); switch (returnCode) { case SqlConstants.DB_STATUS_CODE_DATAALREADYEXIST: { throw new ArgumentException("DMSFileTrackingEntity already exists. Please specify another DMSFileTrackingEntity."); } case SqlConstants.DB_STATUS_CODE_DATAUPDATEDFROMOTHERSESSION: { throw new ArgumentException("DMSFileTrackingEntity data already updated from different session."); } case SqlConstants.DB_STATUS_CODE_FAIL_OPERATION: { throw new ArgumentException("DMSFileTrackingEntity already exists. Please specify another DMSFileTrackingEntity."); } } } } return(returnCode); }
protected void lvDMSFileTracking_ItemCommand(object sender, ListViewCommandEventArgs e) { Int64 FileTrackingID; Int64.TryParse(e.CommandArgument.ToString(), out FileTrackingID); if (FileTrackingID > 0) { if (string.Equals(e.CommandName, "EditItem")) { _FileTrackingID = FileTrackingID; PrepareEditView(); cpeEditor.Collapsed = false; cpeEditor.ClientState = "false"; } else if (string.Equals(e.CommandName, "DeleteItem")) { try { Int64 result = -1; String fe = SqlExpressionBuilder.PrepareFilterExpression(DMSFileTrackingEntity.FLD_NAME_FileTrackingID, FileTrackingID.ToString(), SQLMatchType.Equal); DMSFileTrackingEntity dMSFileTrackingEntity = new DMSFileTrackingEntity(); result = FCCDMSFileTracking.GetFacadeCreate().Delete(dMSFileTrackingEntity, fe, DatabaseOperationType.Delete, TransactionRequired.No); if (result == 0) { _FileTrackingID = 0; _DMSFileTrackingEntity = new DMSFileTrackingEntity(); PrepareInitialView(); BindDMSFileTrackingList(); MiscUtil.ShowMessage(lblMessage, "File Tracking has been successfully deleted.", true); } else { MiscUtil.ShowMessage(lblMessage, "Failed to delete File Tracking.", true); } } catch (Exception ex) { MiscUtil.ShowMessage(lblMessage, ex.Message, true); } } } }
private Int64 DeleteTran(DMSFileTrackingEntity dMSFileTrackingEntity, String filterExpression, DatabaseOperationType option) { long returnCode = -99; const string SP = "dbo.DMSFileTracking_SET"; Database db = DatabaseFactory.CreateDatabase(); using (DbCommand cmd = db.GetStoredProcCommand(SP)) { AddOptionParameter(cmd, option); AddOutputParameter(cmd, db); AddFilterExpressionParameter(cmd, filterExpression, db); DbConnection connection = db.CreateConnection(); connection.Open(); DbTransaction transaction = connection.BeginTransaction(); try { using (IDataReader reader = db.ExecuteReader(cmd, transaction)) { returnCode = GetReturnCodeFromParameter(cmd); } if (returnCode >= 0) { transaction.Commit(); } else { throw new ArgumentException("Error Code." + returnCode.ToString()); } } catch (Exception ex) { transaction.Rollback(); throw ex; } finally { transaction.Dispose(); connection.Close(); connection = null; } } return(returnCode); }
private void PrepareEditView() { DMSFileTrackingEntity dMSFileTrackingEntity = CurrentDMSFileTrackingEntity; if (!dMSFileTrackingEntity.IsNew) { txtFileNo.Text = dMSFileTrackingEntity.FileNo.ToString(); txtFileName.Text = dMSFileTrackingEntity.FileName.ToString(); if (ddlDepartmentID.Items.Count > 0 && dMSFileTrackingEntity.DepartmentID != null) { ddlDepartmentID.SelectedValue = dMSFileTrackingEntity.DepartmentID.ToString(); } txtCreatedDateTime.Text = dMSFileTrackingEntity.CreatedDateTime.ToStringDefault(); txtFileParmanentPlace.Text = dMSFileTrackingEntity.FileParmanentPlace.ToString(); txtFileCurrentPlace.Text = dMSFileTrackingEntity.FileCurrentPlace.ToString(); btnSubmit.Text = "Update"; btnAddNew.Visible = true; } }
private Int64 Delete(DMSFileTrackingEntity dMSFileTrackingEntity, String filterExpression, DatabaseOperationType option) { long returnCode = -99; const string SP = "dbo.DMSFileTracking_SET"; using (DbCommand cmd = Database.GetStoredProcCommand(SP)) { AddOptionParameter(cmd, option); AddOutputParameter(cmd); AddFilterExpressionParameter(cmd, filterExpression); using (IDataReader reader = Database.ExecuteReader(cmd)) { returnCode = GetReturnCodeFromParameter(cmd); switch (returnCode) { case SqlConstants.DB_STATUS_CODE_DATAALREADYEXIST: { throw new ArgumentException("DMSFileTrackingEntity already exists. Please specify another DMSFileTrackingEntity."); } case SqlConstants.DB_STATUS_CODE_DATAUPDATEDFROMOTHERSESSION: { throw new ArgumentException("DMSFileTrackingEntity data already updated from different session."); } case SqlConstants.DB_STATUS_CODE_FAIL_OPERATION: { throw new ArgumentException("DMSFileTrackingEntity already exists. Please specify another DMSFileTrackingEntity."); } } } } return(returnCode); }
Int64 IDMSFileTrackingFacade.Delete(DMSFileTrackingEntity dMSFileTrackingEntity, String filterExpression, DatabaseOperationType option, TransactionRequired reqTran) { return(DataAccessFactory.CreateDMSFileTrackingDataAccess().Delete(dMSFileTrackingEntity, filterExpression, option, reqTran)); }
Int64 IDMSFileTrackingFacade.Add(DMSFileTrackingEntity dMSFileTrackingEntity, DatabaseOperationType option, TransactionRequired reqTran) { return(DataAccessFactory.CreateDMSFileTrackingDataAccess().Add(dMSFileTrackingEntity, option, reqTran)); }
protected void btnAddNew_Click(object sender, EventArgs e) { _FileTrackingID = 0; _DMSFileTrackingEntity = new DMSFileTrackingEntity(); PrepareInitialView(); }
private DMSFileTrackingEntity BuildDMSFileTrackingEntity() { DMSFileTrackingEntity dMSFileTrackingEntity = CurrentDMSFileTrackingEntity; dMSFileTrackingEntity.FileNo = txtFileNo.Text.Trim(); dMSFileTrackingEntity.FileName = txtFileName.Text.Trim(); if (ddlDepartmentID.Items.Count > 0) { if (ddlDepartmentID.SelectedValue == "0") { } else { dMSFileTrackingEntity.DepartmentID = Int64.Parse(ddlDepartmentID.SelectedValue); } } String fe = SqlExpressionBuilder.PrepareFilterExpression(HREmployeeEntity.FLD_NAME_MemberID, this.CurrentMember.MemberID.ToString(), SQLMatchType.Equal); IList <HREmployeeEntity> lstEmployee = FCCHREmployee.GetFacadeCreate().GetIL(null, null, String.Empty, fe, DatabaseOperationType.LoadWithFilterExpression); if (lstEmployee != null && lstEmployee.Count > 0) { dMSFileTrackingEntity.CreatedByEmployeeID = lstEmployee[0].EmployeeID; } if (txtCreatedDateTime.Text.Trim().IsNotNullOrEmpty()) { dMSFileTrackingEntity.CreatedDateTime = MiscUtil.ParseToDateTime(txtCreatedDateTime.Text); } dMSFileTrackingEntity.FileParmanentPlace = txtFileParmanentPlace.Text.Trim(); dMSFileTrackingEntity.FileCurrentPlace = txtFileCurrentPlace.Text.Trim(); #region File Upload String HoverImageUrlpath; if (fuImageUrl.HasFile == true && dMSFileTrackingEntity.SoftFileName.IsNotNullOrEmpty()) { if (File.Exists(Server.MapPath(dMSFileTrackingEntity.SoftFileName))) { File.Delete(Server.MapPath(dMSFileTrackingEntity.SoftFileName)); } HoverImageUrlpath = FileUploadConstants.DMS.FILE + Guid.NewGuid() + fuImageUrl.FileName; fuImageUrl.SaveAs(Server.MapPath(HoverImageUrlpath)); dMSFileTrackingEntity.SoftFileName = HoverImageUrlpath; } if (dMSFileTrackingEntity.SoftFileName.IsNotNullOrEmpty() && fuImageUrl.HasFile == false) { dMSFileTrackingEntity.SoftFileName = dMSFileTrackingEntity.SoftFileName; } if (fuImageUrl.HasFile == false && dMSFileTrackingEntity.SoftFileName.IsNullOrEmpty()) { dMSFileTrackingEntity.SoftFileName = null; } if (fuImageUrl.HasFile == true && dMSFileTrackingEntity.SoftFileName.IsNullOrEmpty()) { HoverImageUrlpath = FileUploadConstants.DMS.FILE + Guid.NewGuid() + fuImageUrl.FileName; fuImageUrl.SaveAs(Server.MapPath(HoverImageUrlpath)); dMSFileTrackingEntity.SoftFileName = HoverImageUrlpath; } #endregion dMSFileTrackingEntity.Extension = Path.GetExtension(fuImageUrl.FileName); if (dMSFileTrackingEntity.CurrentFileName != null) { dMSFileTrackingEntity.Path = FileUploadConstants.DMS.FILE + dMSFileTrackingEntity.CurrentFileName; } else { dMSFileTrackingEntity.Path = null; } dMSFileTrackingEntity.OriginalFileName = Path.GetFileName(fuImageUrl.FileName); dMSFileTrackingEntity.CurrentFileName = Guid.NewGuid().ToString() + Path.GetExtension(fuImageUrl.FileName); dMSFileTrackingEntity.FileType = ""; return(dMSFileTrackingEntity); }
private Int64 UpdateTran(DMSFileTrackingEntity dMSFileTrackingEntity, String filterExpression, DatabaseOperationType option) { long returnCode = -99; const string SP = "dbo.DMSFileTracking_SET"; Database db = DatabaseFactory.CreateDatabase(); using (DbCommand cmd = db.GetStoredProcCommand(SP)) { AddOptionParameter(cmd, option, db); AddOutputParameter(cmd, db); AddFilterExpressionParameter(cmd, filterExpression, db); db.AddInParameter(cmd, "@FileTrackingID", DbType.Int64, dMSFileTrackingEntity.FileTrackingID); db.AddInParameter(cmd, "@FileNo", DbType.String, dMSFileTrackingEntity.FileNo); db.AddInParameter(cmd, "@FileName", DbType.String, dMSFileTrackingEntity.FileName); db.AddInParameter(cmd, "@DepartmentID", DbType.Int64, dMSFileTrackingEntity.DepartmentID); db.AddInParameter(cmd, "@CreatedByEmployeeID", DbType.Int64, dMSFileTrackingEntity.CreatedByEmployeeID); db.AddInParameter(cmd, "@CreatedDateTime", DbType.DateTime, dMSFileTrackingEntity.CreatedDateTime); db.AddInParameter(cmd, "@FileParmanentPlace", DbType.String, dMSFileTrackingEntity.FileParmanentPlace); db.AddInParameter(cmd, "@FileCurrentPlace", DbType.String, dMSFileTrackingEntity.FileCurrentPlace); db.AddInParameter(cmd, "@FileType", DbType.String, dMSFileTrackingEntity.FileType); db.AddInParameter(cmd, "@SoftFileName", DbType.String, dMSFileTrackingEntity.SoftFileName); db.AddInParameter(cmd, "@Extension", DbType.String, dMSFileTrackingEntity.Extension); db.AddInParameter(cmd, "@Path", DbType.String, dMSFileTrackingEntity.Path); db.AddInParameter(cmd, "@OriginalFileName", DbType.String, dMSFileTrackingEntity.OriginalFileName); db.AddInParameter(cmd, "@CurrentFileName", DbType.String, dMSFileTrackingEntity.CurrentFileName); DbConnection connection = db.CreateConnection(); connection.Open(); DbTransaction transaction = connection.BeginTransaction(); try { using (IDataReader reader = db.ExecuteReader(cmd, transaction)) { returnCode = GetReturnCodeFromParameter(cmd); } if (returnCode > 0) { transaction.Commit(); } else { throw new ArgumentException("Error Code." + returnCode.ToString()); } } catch (Exception ex) { transaction.Rollback(); throw ex; } finally { transaction.Dispose(); connection.Close(); connection = null; } } return(returnCode); }