public static string WMSaveApproval(long RequestID, string ApprovalStatus, long APL, string ApprovalRemark, string InvoiceNo) { iPartRequestClient objService = new iPartRequestClient(); string result = ""; try { CustomProfile profile = CustomProfile.GetProfile(); if (ApprovalStatus == "3") { objService.UpdatetApprovalTransAfterApproval(APL, RequestID, 3, ApprovalRemark, profile.Personal.UserID, InvoiceNo, profile.DBConnection._constr); result = "true"; } else if (ApprovalStatus == "4") { objService.UpdatetApprovalTransAfterReject(APL, RequestID, 4, ApprovalRemark, profile.Personal.UserID, profile.DBConnection._constr); result = "true"; } else if (ApprovalStatus == "24") { objService.UpdatetApprovalTransAfterApproval(0, RequestID, 24, ApprovalRemark, profile.Personal.UserID, "0", profile.DBConnection._constr); result = "truerev"; } } catch { } finally { objService.Close(); } return(result); }
public void ProcessRequest(HttpContext context) { SqlConnection conn = new SqlConnection(strcon); long aprId = Convert.ToInt64(context.Request.Form["aprId"]); string OdrID = context.Request.Form["reqId"]; String reqAct = context.Request.Form["reqAct"]; SqlCommand cmd3 = new SqlCommand(); SqlDataAdapter da3 = new SqlDataAdapter(); DataTable dt3 = new DataTable(); DataSet ds3 = new DataSet(); cmd3.CommandType = CommandType.Text; cmd3.CommandText = "select Id from tOrderHead where OrderNo='" + OdrID + "'"; cmd3.Connection = conn; cmd3.Parameters.Clear(); //cmd.Parameters.AddWithValue("param1", ResourceId); da3.SelectCommand = cmd3; da3.Fill(ds3, "tbl4"); dt3 = ds3.Tables[0]; long reqId = Convert.ToInt32(dt3.Rows[0]["Id"].ToString()); long statusId = 0; if (reqAct == "Approved") { statusId = 3; } else if (reqAct == "Rejected") { statusId = 4; } string reqRemark = context.Request.Form["reqRemark"]; string aprUserName = context.Request.Form["aprUserName"]; string InvNo = ""; InvNo = context.Request.Form["reqInvoiceNo"]; CustomProfile profile = CustomProfile.GetProfile(aprUserName); String xmlString = String.Empty; context.Response.ContentType = "text/xml"; xmlString = xmlString + "<?xml version=\"1.0\" encoding=\"UTF-8\"?>"; xmlString = xmlString + "<gwcInfo>"; xmlString = xmlString + "<approvalAction>"; iPartRequestClient objService = new iPartRequestClient(); try { SqlCommand cmd1 = new SqlCommand(); SqlDataAdapter da1 = new SqlDataAdapter(); DataTable dt1 = new DataTable(); DataSet ds1 = new DataSet(); cmd1.Connection = conn; cmd1.CommandType = CommandType.Text; cmd1.CommandText = "select * from VW_ApprovalTransDetails where OrderID=" + reqId + " and approverID=" + aprId + " and Status !=3"; da1.SelectCommand = cmd1; da1.Fill(ds1, "dtl"); dt1 = ds1.Tables[0]; if (dt1.Rows.Count > 0) { long aprovalid = Convert.ToInt64(dt1.Rows[0]["ApprovalID"].ToString()); if (statusId == 3) { objService.UpdatetApprovalTransAfterApproval(aprovalid, reqId, statusId, CheckString(reqRemark), aprId, InvNo, profile.DBConnection._constr); } else if (statusId == 4) { objService.UpdatetApprovalTransAfterReject(aprovalid, reqId, statusId, CheckString(reqRemark), aprId, profile.DBConnection._constr); } xmlString = xmlString + "<authmsg>success</authmsg>"; } } catch { xmlString = xmlString + "<authmsg>failed</authmsg>"; } xmlString = xmlString + "</approvalAction>"; xmlString = xmlString + "</gwcInfo>"; context.Response.Write(xmlString); }