/// <summary> /// Insert data /// </summary> private void InsertData() { //Get and Insert Data UsedElectricRoomData data = new UsedElectricRoomData(); ITransaction tran = factory.GetInsertObject(data); data.RoomId = drpRoom.SelectedValue; data.OldIndex = txtOldIndex.Text.Trim(); data.NewIndex = txtNewIndex.Text.Trim(); data.MonthYear = drpYear.SelectedValue + drpMonth.SelectedValue; data.Comment = txtComment.Text.Trim(); data.ModifiedBy = Page.User.Identity.Name; data.CreatedBy = Page.User.Identity.Name; data.Created = DateTime.Now.ToString("yyyyMMddHHmmss"); data.Modified = DateTime.Now.ToString("yyyyMMddHHmmss"); data.DelFlag = "0"; Execute(tran); if (!HasError) { OperationLogger.WriteInfo(Constants.LogOperationAlbumId, Constants.LogActionInsertId, addSuccess, Page.User.Identity.Name); mvMessage.SetCompleteMessage(addSuccess); ScriptManager.RegisterClientScriptBlock(this.btnRegister, this.GetType(), key, postback, true); txtOldIndex.Text = ""; txtNewIndex.Text = ""; txtComment.Text = ""; } else { OperationLogger.WriteError(Constants.LogOperationAlbumId, Constants.LogActionInsertId, addUnSuccess, Page.User.Identity.Name); mvMessage.AddError(addUnSuccess); } }
/// <summary> /// Update /// </summary> private void UpdateData(int id) { UsedElectricRoomData data = new UsedElectricRoomData(); ITransaction tran = factory.GetLoadObject(data, hidId.Value); Execute(tran); if (!HasError) { //Get Data data = (UsedElectricRoomData)tran.Result; data.RoomId = drpRoom.SelectedValue; data.OldIndex = txtOldIndex.Text.Trim(); data.NewIndex = txtNewIndex.Text.Trim(); data.MonthYear = drpYear.SelectedValue + drpMonth.SelectedValue; data.Comment = txtComment.Text.Trim(); data.ModifiedBy = Page.User.Identity.Name; data.Modified = DateTime.Now.ToString("yyyyMMddHHmmss"); tran = factory.GetUpdateObject(data); Execute(tran); if (!HasError) { OperationLogger.WriteInfo(Constants.LogOperationAlbumId, Constants.LogActionUpdateId, updateSuccess, Page.User.Identity.Name); mvMessage.SetCompleteMessage(updateSuccess); ScriptManager.RegisterClientScriptBlock(this.btnRegister, this.GetType(), key, postback, true); } else { OperationLogger.WriteError(Constants.LogOperationAlbumId, Constants.LogActionUpdateId, updateUnSuccess, Page.User.Identity.Name); mvMessage.AddError(updateUnSuccess); } } }
/// </summary> /// <param name="source"></param> /// <param name="e"></param> protected void rptList_ItemCommand(object source, RepeaterCommandEventArgs e) { string command = e.CommandName; string colName = string.Empty; if (command.StartsWith("Sort")) { if (string.Compare(command, "SortID") == 0) { colName = "ID"; } else if (string.Compare(command, "SortName") == 0) { colName = "Name"; } else if (string.Compare(command, "SortModifiedBy") == 0) { colName = "ModifiedBy"; } else if (string.Compare(command, "SortModified") == 0) { colName = "Modified"; } if (colName == ListSortExpression) { ListSortDirection = (ListSortDirection == SortDirection.Ascending ? SortDirection.Descending : SortDirection.Ascending); } else { ListSortDirection = SortDirection.Descending; } ListSortExpression = colName; pager.CurrentPageIndex = 0; ShowData(); } else if (command.Equals("Delete")) { UsedElectricRoomData data = new UsedElectricRoomData(); ITransaction tran = factory.GetLoadObject(data, Func.ParseString(e.CommandArgument)); Execute(tran); if (!HasError) { //Get Data data = (UsedElectricRoomData)tran.Result; data.DelFlag = "1"; data.ModifiedBy = Page.User.Identity.Name; data.Modified = DateTime.Now.ToString("yyyyMMddHHmmss"); tran = factory.GetUpdateObject(data); Execute(tran); if (!HasError) { OperationLogger.WriteInfo(Constants.LogOperationAlbumId, Constants.LogActionUpdateId, updateSuccess, Page.User.Identity.Name); mvMessage.SetCompleteMessage(updateSuccess); ShowData(); } else { OperationLogger.WriteError(Constants.LogOperationAlbumId, Constants.LogActionUpdateId, updateUnSuccess, Page.User.Identity.Name); mvMessage.AddError(updateUnSuccess); } } } }