protected void gvApproval_RowCommand(object sender, GridViewCommandEventArgs e) { Business.Service.ServiceBook objServiceBook = new Business.Service.ServiceBook(); Entity.Service.ServiceBook serviceBook = new Entity.Service.ServiceBook(); int approvalId = int.Parse(e.CommandArgument.ToString()); int approvalResponse = 0; GridViewRow row = (GridViewRow)(((ImageButton)e.CommandSource).NamingContainer); string comment = ((TextBox)row.FindControl("txtComment")).Text.Trim(); using (DataTable dtApproval = new DataTable()) { dtApproval.Columns.Add("ApprovalId"); dtApproval.Columns.Add("ServiceBookId"); dtApproval.Columns.Add("ItemId"); dtApproval.Columns.Add("ApprovalStatus"); dtApproval.Columns.Add("IsLowYield"); dtApproval.Columns.Add("CallStatus"); dtApproval.Columns.Add("RespondBy"); dtApproval.Columns.Add("Comment"); dtApproval.Columns.Add("RequisiteQty"); DataRow drApprovalItem = dtApproval.NewRow(); drApprovalItem["ApprovalId"] = approvalId; drApprovalItem["ServiceBookId"] = 0; drApprovalItem["ItemId"] = 0; drApprovalItem["ApprovalStatus"] = (e.CommandName == "Approve") ? (int)ApprovalStatus.Approved : (int)ApprovalStatus.Rejected; drApprovalItem["RespondBy"] = Convert.ToInt32(HttpContext.Current.User.Identity.Name); drApprovalItem["Comment"] = comment; dtApproval.Rows.Add(drApprovalItem); dtApproval.AcceptChanges(); serviceBook.ApprovalItems = dtApproval; serviceBook.ApprovalItems.AcceptChanges(); approvalResponse = objServiceBook.Service_ServiceBookDetailsApproval_Save(serviceBook); if (approvalResponse > 0) { Service_ServiceBookDetailsApproval_GetAll(); Message.IsSuccess = true; Message.Text = "Toner response has been given."; } else { Message.IsSuccess = false; Message.Text = "Toner response failed."; } Message.Show = true; } }
private static int Approval_Save(Entity.Service.TonerRequest tonnerRequest, DataTable dtTonnerRequest, bool isLowYield) { int approvalResponse = 0; Business.Service.ServiceBook objServiceBook = new Business.Service.ServiceBook(); Entity.Service.ServiceBook serviceBook = new Entity.Service.ServiceBook(); using (DataTable dtApproval = new DataTable()) { dtApproval.Columns.Add("ApprovalId"); dtApproval.Columns.Add("ServiceBookId"); dtApproval.Columns.Add("ItemId"); dtApproval.Columns.Add("ApprovalStatus"); dtApproval.Columns.Add("IsLowYield"); dtApproval.Columns.Add("CallStatus"); dtApproval.Columns.Add("RespondBy"); dtApproval.Columns.Add("Comment"); dtApproval.Columns.Add("RequisiteQty"); foreach (TonerIdQuantity item in tonnerRequest.SpareIds) { DataRow drApprovalItem = dtApproval.NewRow(); drApprovalItem["ApprovalId"] = 0; drApprovalItem["ServiceBookId"] = dtTonnerRequest.Rows[0]["ServiceBookId"].ToString(); drApprovalItem["ItemId"] = item.TonerId; drApprovalItem["ApprovalStatus"] = (isLowYield) ? (int)ApprovalStatus.None : (int)ApprovalStatus.Approved; drApprovalItem["IsLowYield"] = isLowYield; drApprovalItem["CallStatus"] = (isLowYield) ? (int)CallStatusType.TonerOpenForApproval : (int)CallStatusType.TonerRequestInQueue; drApprovalItem["RespondBy"] = string.Empty; drApprovalItem["Comment"] = (isLowYield) ? "NEED TONER APPROVAL" : "AUTO APPROVED"; drApprovalItem["RequisiteQty"] = item.Quantity; dtApproval.Rows.Add(drApprovalItem); dtApproval.AcceptChanges(); } serviceBook.ApprovalItems = dtApproval; serviceBook.ApprovalItems.AcceptChanges(); approvalResponse = objServiceBook.Service_ServiceBookDetailsApproval_Save(serviceBook); return(approvalResponse); } }