private static void BuildPages()
{
ApplyLeave = new ApplyLeave();
C1MarginReport = new C1MarginReport();
CustomerBalanceAgeingAnalysis = new CustomerBalanceAgeingAnalysis();
ConvertPurchaseRequestToOrder = new ConvertPurchaseRequestToOrder();
CreateExpenseInvoice = new CreateExpenseInvoice();
CreateVoucher = new CreateVoucher();
CreatePurchaseRequest = new CreatePurchaseRequest();
EditExpenseInvoice = new EditExpenseInvoice();
EditPurchaseOrder = new EditPurchaseOrder();
EditPurchaseRequest = new EditPurchaseRequest();
EditVoucher = new EditVoucher();
ExpenseInvoiceTaxCalculationSummary = new ExpenseInvoiceTaxCalculationSummary();
Login = new Login();
ManageRequest = new ManageRequest();
PRAdditionalDetails = new PRAdditionalDetails();
SelectPurchaseOrder = new SelectPurchaseOrder();
SelfServiceHome = new SelfServiceHome();
SpecifyPOPRCoverage = new SpecifyPOPRCoverage();
SpecifyTermsAndCondition = new SpecifyTermsAndCondition();
SpecifyScheduleAndDistribution = new SpecifyScheduleAndDistribution();
TaxCalculationSummary = new TaxCalculationSummary();
ViewPurchaseOrder = new ViewPurchaseOrder();
ViewPurchaseRequest = new ViewPurchaseRequest();
}
public int UpdatePurchase_OrderStatus_Approved(ref EditPurchaseOrder Entity_PurchaseOrder, out string strError)
{
int iInsert = 0;
strError = string.Empty;
try
{
SqlParameter pAction = new SqlParameter(EditPurchaseOrder._Action, SqlDbType.BigInt);
SqlParameter pPOId = new SqlParameter(EditPurchaseOrder._POId, SqlDbType.BigInt);
SqlParameter pPOStatus = new SqlParameter(EditPurchaseOrder._POStatus, SqlDbType.NVarChar);
SqlParameter pApprovedTime = new SqlParameter(EditPurchaseOrder._ApprovedTime, SqlDbType.DateTime);
SqlParameter pUpdatedBy = new SqlParameter(EditPurchaseOrder._UserId, SqlDbType.BigInt);
SqlParameter pUpdatedDate = new SqlParameter(EditPurchaseOrder._LoginDate, SqlDbType.DateTime);
pAction.Value = 3;
pPOId.Value = Entity_PurchaseOrder.POId;
pPOStatus.Value = Entity_PurchaseOrder.POStatus;
pApprovedTime.Value = Entity_PurchaseOrder.ApprovedTime;
pUpdatedBy.Value = Entity_PurchaseOrder.UserId;
pUpdatedDate.Value = Entity_PurchaseOrder.LoginDate;
SqlParameter[] Param = new SqlParameter[] { pAction, pPOStatus, pApprovedTime, pPOId, pUpdatedBy, pUpdatedDate };
Open(CONNECTION_STRING);
BeginTransaction();
iInsert = SQLHelper.ExecuteNonQuery(_Connection, _Transaction, CommandType.StoredProcedure, EditPurchaseOrder.SP_EditPurchaseOrder, 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..";
}
}
}
}
