public int UpdateReq_Status_Authorozed(ref ApproveRequisition Entity_ApproveRequisition, out string strError) { int iInsert = 0; strError = string.Empty; try { SqlParameter pAction = new SqlParameter(ApproveRequisition._Action, SqlDbType.BigInt); SqlParameter pRequisitionCafeId = new SqlParameter(ApproveRequisition._RequisitionCafeId, SqlDbType.BigInt); SqlParameter pReqStatus = new SqlParameter(ApproveRequisition._ReqStatus, SqlDbType.NVarChar); SqlParameter pAuthorizedTime = new SqlParameter(ApproveRequisition._AuthorizedTime, SqlDbType.DateTime); SqlParameter pUpdatedBy = new SqlParameter(ApproveRequisition._UserId, SqlDbType.BigInt); SqlParameter pUpdatedDate = new SqlParameter(ApproveRequisition._LoginDate, SqlDbType.DateTime); pAction.Value = 4; pRequisitionCafeId.Value = Entity_ApproveRequisition.RequisitionCafeId; pReqStatus.Value = Entity_ApproveRequisition.ReqStatus; pAuthorizedTime.Value = Entity_ApproveRequisition.AuthorizedTime; pUpdatedBy.Value = Entity_ApproveRequisition.UserId; pUpdatedDate.Value = Entity_ApproveRequisition.LoginDate; SqlParameter[] Param = new SqlParameter[] { pAction, pReqStatus, pAuthorizedTime, pRequisitionCafeId, pUpdatedBy, pUpdatedDate }; Open(CONNECTION_STRING); BeginTransaction(); iInsert = SQLHelper.ExecuteNonQuery(_Connection, _Transaction, CommandType.StoredProcedure, ApproveRequisition.SP_ApproveRequisition, Param); if (iInsert > 0) { CommitTransaction(); } else { RollBackTransaction(); } } catch (Exception ex) { RollBackTransaction(); strError = ex.Message; } finally { Close(); } return(iInsert); }
private void GetConfirm() { string RequestFor = string.Empty; string RequestBY = string.Empty; string StrError = string.Empty; int RequestID = 0; DateTime RequestDate = DateTime.Now; int LoginID = 0; DateTime LoginDate = DateTime.Now; RequestFor = Convert.ToString(Request.QueryString["for"].ToString()); RequestID = Convert.ToInt32(Request.QueryString["request"].ToString()); RequestBY = Convert.ToString(Request.QueryString["by"].ToString()); DMUserLogin obj_Login = new DMUserLogin(); DataSet dsLogin = obj_Login.GetLoginIDFORMAILREQUEST(RequestBY, out StrError); if (dsLogin.Tables.Count > 0 && dsLogin.Tables[0].Rows.Count > 0) { LoginID = Convert.ToInt32(dsLogin.Tables[0].Rows[0]["UserId"].ToString()); if (RequestFor == "Req") { DMApproveRequisition Obj_ApproveRequisition = new DMApproveRequisition(); ApproveRequisition Entity_ApproveRequisition = new ApproveRequisition(); Entity_ApproveRequisition.RequisitionCafeId = Convert.ToInt32(RequestID); Entity_ApproveRequisition.ReqStatus = "Authorised"; Entity_ApproveRequisition.AuthorizedTime = DateTime.Now; Entity_ApproveRequisition.UserId = LoginID; Entity_ApproveRequisition.LoginDate = DateTime.Now; int UpdateRow = Obj_ApproveRequisition.UpdateReq_Status_Authorozed(ref Entity_ApproveRequisition, out StrError); if (UpdateRow > 0) { SendMailREQ(RequestID); LblPass.Text = "Requisition Has Been Successfully Authorized.."; } else { LblPass.Text = "Requisition Not Authorize Please Try After Some Time.."; } } else { DMEditPurchaseOrder Obj_EditPO = new DMEditPurchaseOrder(); EditPurchaseOrder Entity_PurchaseOrder = new EditPurchaseOrder(); Entity_PurchaseOrder.POId = Convert.ToInt32(RequestID); Entity_PurchaseOrder.POStatus = "Authorised"; Entity_PurchaseOrder.AuthorizedTime = DateTime.Now; Entity_PurchaseOrder.UserId = LoginID; Entity_PurchaseOrder.LoginDate = DateTime.Now; int UpdateRow = Obj_EditPO.UpdatePurchase_OrderStatus_Authroized(ref Entity_PurchaseOrder, out StrError); if (UpdateRow > 0) { SendMail(RequestID); LblPass.Text = "Purchase Order Has Been Successfully Authorized.."; } else { LblPass.Text = "Purchase Order Not Authorize Please Try After Some Time.."; } } } }