public ActionResult ReadEmployeeSchemeFund(string ESF_Id)
{
try
{
return(this.Store(WithdrawalRepo.GetESFList(ESF_Id)));
}
catch (Exception ex)
{
throw ex;
}
}
public ActionResult PayTaxRecord(Remit_WithdrawalRepo WithdrawalRepo)
{
try
{
if (string.IsNullOrEmpty(WithdrawalRepo.Withdrawal_No))
{
X.Msg.Show(new MessageBoxConfig
{
Title = "Error",
Message = "Sorry! No Benefit has been selected for Payment.",
Buttons = MessageBox.Button.OK,
Icon = MessageBox.Icon.ERROR,
Width = 350
});
return(this.Direct());
}
if (string.IsNullOrEmpty(WithdrawalRepo.GL_Account_No))
{
X.Msg.Show(new MessageBoxConfig
{
Title = "Error",
Message = "Please select Bank Account.",
Buttons = MessageBox.Button.OK,
Icon = MessageBox.Icon.ERROR,
Width = 350
});
return(this.Direct());
}
WithdrawalRepo.GetESFList(WithdrawalRepo.ESF_Id);
//get GL balance from GL_Account Table
WithdrawalRepo.Get_GL_Balance(WithdrawalRepo);
if (WithdrawalRepo.Tax > WithdrawalRepo.GL_Balance * -1)
{
X.Msg.Show(new MessageBoxConfig
{
Title = "Error",
Message = "Sorry! Insufficient Account Balance.Process aborted.",
Buttons = MessageBox.Button.OK,
Icon = MessageBox.Icon.ERROR,
Width = 350
});
return(this.Direct());
}
if (string.IsNullOrEmpty(WithdrawalRepo.Payment_Mode))
{
X.Msg.Show(new MessageBoxConfig
{
Title = "Error",
Message = "Payment Mode is required",
Buttons = MessageBox.Button.OK,
Icon = MessageBox.Icon.ERROR,
Width = 350
});
return(this.Direct());
}
//if (WithdrawalRepo.Payment_Mode != "CASH" && string.IsNullOrEmpty(WithdrawalRepo.Instrument_No))
//{
// X.Msg.Show(new MessageBoxConfig
// {
// Title = "Error",
// Message = "Instrument Numebr is required.",
// Buttons = MessageBox.Button.OK,
// Icon = MessageBox.Icon.INFO,
// Width = 350
// });
// return this.Direct();
//}
if (!WithdrawalRepo.Pay_Date_Benefit.HasValue)
{
X.Msg.Show(new MessageBoxConfig
{
Title = "Error",
Message = "Payment Date is required",
Buttons = MessageBox.Button.OK,
Icon = MessageBox.Icon.INFO,
Width = 350
});
return(this.Direct());
}
// validate scheme date
if (!string.IsNullOrEmpty(WithdrawalRepo.Scheme_Id))
{
GlobalValue.Get_Scheme_Today_Date(WithdrawalRepo.Scheme_Id);
if (WithdrawalRepo.Pay_Date_Benefit != GlobalValue.Scheme_Today_Date)
{
X.Msg.Show(new MessageBoxConfig
{
Title = "Error",
Message = "Sorry! Payment date must be equal to scheme working date ",
Buttons = MessageBox.Button.OK,
Icon = MessageBox.Icon.INFO,
Width = 350
});
return(this.Direct());
}
}
else
{
X.Msg.Show(new MessageBoxConfig
{
Title = "Error",
Message = "Employee account cannot be verified.",
Buttons = MessageBox.Button.OK,
Icon = MessageBox.Icon.INFO,
Width = 350
});
}
///pay pending tax
WithdrawalRepo.PayTax_Unit_Withdrawal(WithdrawalRepo);
X.Msg.Show(new MessageBoxConfig
{
Title = "Success",
Message = "Benefit Tax Successfully Paid.",
Buttons = MessageBox.Button.OK,
Icon = MessageBox.Icon.INFO,
Width = 350
});
//ClearControls_PayTax();
//Store store = X.GetCmp<Store>("PayTaxRequestWithStore");
//store.Reload();
//return this.Direct();
var pvr = new Ext.Net.MVC.PartialViewResult
{
ViewName = "WithdrawalPayTaxPartial",
ContainerId = "MainArea",
RenderMode = RenderMode.AddTo,
};
this.GetCmp <TabPanel>("MainArea").SetLastTabAsActive();
return(pvr);
}
catch (Exception ex)
{
throw ex;
}
}
public ActionResult DApproveRecord(Remit_WithdrawalRepo WithdrawalRepo)
{
try
{
if (WithdrawalRepo.Withdrawal_No == string.Empty)
{
X.Msg.Show(new MessageBoxConfig
{
Title = "Error",
Message = "Sorry! No Request has been selected for approval.",
Buttons = MessageBox.Button.OK,
Icon = MessageBox.Icon.ERROR,
Width = 350
});
return(this.Direct());
}
WithdrawalRepo.GetESFList(WithdrawalRepo.ESF_Id);
//WithdrawalRepo.Total_Withdrawal_Unit = Math.Round(WithdrawalRepo.Total_Withdrawal_Unit, 4);
//WithdrawalRepo.Total_Unit_Balance = Math.Round(WithdrawalRepo.Total_Unit_Balance, 4);
//if (WithdrawalRepo.Total_Withdrawal_Unit > WithdrawalRepo.Total_Unit_Balance)
//{
// X.Msg.Show(new MessageBoxConfig
// {
// Title = "Error",
// Message = "Sorry!Total Withdrawal(Unit) can not be more than Total Unit.",
// Buttons = MessageBox.Button.OK,
// Icon = MessageBox.Icon.INFO,
// Width = 350
// });
// return this.Direct();
//}
///approve pending withdrawal
WithdrawalRepo.DApprove_Unit_Withdrawal(WithdrawalRepo);
X.Msg.Show(new MessageBoxConfig
{
Title = "Success",
Message = "Benefit Request Successfully Disapproved.",
Buttons = MessageBox.Button.OK,
Icon = MessageBox.Icon.INFO,
Width = 350
});
//ClearControls_Approve();
//Store store = X.GetCmp<Store>("ApproveRequestWithStore");
//store.Reload();
//return this.Direct();
var pvr = new Ext.Net.MVC.PartialViewResult
{
ViewName = "WithdrawalApprovePartial",
ContainerId = "MainArea",
RenderMode = RenderMode.AddTo,
};
this.GetCmp <TabPanel>("MianArea").SetLastTabAsActive();
return(pvr);
}
catch (Exception ex)
{
throw ex;
}
}
//public ActionResult AddReversePurchaseTab(string containerId = "MainArea")
//{
// var pvr = new Ext.Net.MVC.PartialViewResult
// {
// ViewName = "ReversePurchasePartial",
// ContainerId = containerId,
// RenderMode = RenderMode.AddTo,
// };
// this.GetCmp<TabPanel>(containerId).SetLastTabAsActive();
// return pvr;
//}
public ActionResult SaveRecord(Remit_WithdrawalRepo WithdrawalRepo)
{
try
{
if (!WithdrawalRepo.Trans_Request_Date.HasValue)
{
X.Msg.Show(new MessageBoxConfig
{
Title = "Error",
Message = "Actual Request Date is a required field",
Buttons = MessageBox.Button.OK,
Icon = MessageBox.Icon.INFO,
Width = 350
});
return(this.Direct());
}
//if (string.IsNullOrEmpty(WithdrawalRepo.Type))
//{
// X.Msg.Show(new MessageBoxConfig
// {
// Title = "Error",
// Message = "'Amount / Unit' is a required field",
// Buttons = MessageBox.Button.OK,
// Icon = MessageBox.Icon.INFO,
// Width = 350
// });
// return this.Direct();
//}
if (string.IsNullOrEmpty(WithdrawalRepo.Withdrawal_Reason))
{
X.Msg.Show(new MessageBoxConfig
{
Title = "Error",
Message = "Withdrawal Reason is a required field",
Buttons = MessageBox.Button.OK,
Icon = MessageBox.Icon.INFO,
Width = 350
});
return(this.Direct());
}
//check if unit will move to employer
if (this.GetCmp <Checkbox>("frmWD_Suspense").Checked == true)
{
WithdrawalRepo.Total_Withdrawal_Amount = Math.Round(WithdrawalRepo.Total_Withdrawal_Temp * WithdrawalRepo.Unit_Price, 2);
WithdrawalRepo.Total_Withdrawal_Unit = WithdrawalRepo.Total_Withdrawal_Temp;
WithdrawalRepo.To_Employer = Math.Round(WithdrawalRepo.Total_Unit_Balance - WithdrawalRepo.Total_Withdrawal_Unit, 4);
}
else
{
WithdrawalRepo.Total_Withdrawal_Amount = Math.Round(WithdrawalRepo.Total_Withdrawal_Temp * WithdrawalRepo.Unit_Price, 2);
WithdrawalRepo.Total_Withdrawal_Unit = WithdrawalRepo.Total_Withdrawal_Temp;
WithdrawalRepo.To_Employer = 0;
}
// check if there is a pending request for the employee scheme fund
if (WithdrawalRepo.GetcheckESFList(WithdrawalRepo) == true)
{
X.Msg.Show(new MessageBoxConfig
{
Title = "Error",
Message = "Sorry! There is already a pending request for the Employee Account",
Buttons = MessageBox.Button.OK,
Icon = MessageBox.Icon.INFO,
Width = 350
});
return(this.Direct());
}
// validate scheme date
if (!string.IsNullOrEmpty(WithdrawalRepo.Scheme_Id))
{
GlobalValue.Get_Scheme_Today_Date(WithdrawalRepo.Scheme_Id);
if (WithdrawalRepo.Trans_Request_Date > GlobalValue.Scheme_Today_Date)
{
X.Msg.Show(new MessageBoxConfig
{
Title = "Error",
Message = "Sorry! Request date can not be above the scheme working date ",
Buttons = MessageBox.Button.OK,
Icon = MessageBox.Icon.INFO,
Width = 350
});
return(this.Direct());
}
}
else
{
X.Msg.Show(new MessageBoxConfig
{
Title = "Error",
Message = "Employee account cannot be verified.",
Buttons = MessageBox.Button.OK,
Icon = MessageBox.Icon.INFO,
Width = 350
});
}
WithdrawalRepo.GetESFList(WithdrawalRepo.ESF_Id);
WithdrawalRepo.Total_Withdrawal_Unit = Math.Round(WithdrawalRepo.Total_Withdrawal_Unit, 4);
WithdrawalRepo.Total_Unit_Balance = Math.Round(WithdrawalRepo.Total_Unit_Balance, 4);
if (WithdrawalRepo.Total_Withdrawal_Unit > WithdrawalRepo.Total_Unit_Balance)
{
X.Msg.Show(new MessageBoxConfig
{
Title = "Error",
Message = "Sorry!Total Withdrawal(Unit) can not be more than Total Unit",
Buttons = MessageBox.Button.OK,
Icon = MessageBox.Icon.INFO,
Width = 350
});
return(this.Direct());
}
if (ModelState.IsValid)
{
this.WithdrawalRepo.SaveRecord(WithdrawalRepo);
X.Msg.Show(new MessageBoxConfig
{
Title = "Success",
Message = "Withdrawal Successfully Processed.",
Buttons = MessageBox.Button.OK,
Icon = MessageBox.Icon.INFO,
Width = 350
});
// ClearControls();
//Store store = X.GetCmp<Store>("WithdrawalESFStore");
//store.Reload();
//return this.Direct();
var pvr = new Ext.Net.MVC.PartialViewResult
{
ViewName = "WithdrawalPartial",
ContainerId = "MainArea",
RenderMode = RenderMode.AddTo,
};
this.GetCmp <TabPanel>("MainArea").SetLastTabAsActive();
return(pvr);
}
else
{
string messages = string.Join(Environment.NewLine, ModelState.Values
.SelectMany(x => x.Errors)
.Select(x => x.ErrorMessage));
X.Msg.Show(new MessageBoxConfig
{
Title = "Error",
Message = messages, // " Insufficient data. Operation Aborted",
Buttons = MessageBox.Button.OK,
Icon = MessageBox.Icon.ERROR,
Width = 350
});
return(this.Direct());
}
}
catch (Exception ex)
{
throw ex;
}
}
//public ActionResult AddReversePurchaseTab(string containerId = "MainArea")
//{
// var pvr = new Ext.Net.MVC.PartialViewResult
// {
// ViewName = "ReversePurchasePartial",
// ContainerId = containerId,
// RenderMode = RenderMode.AddTo,
// };
// this.GetCmp<TabPanel>(containerId).SetLastTabAsActive();
// return pvr;
//}
public ActionResult SaveRecord(Remit_WithdrawalRepo WithdrawalRepo, Remit_ReceiptRepo ReceiptRepo)
{
try
{
if (string.IsNullOrEmpty(ReceiptRepo.ES_Id))
{
X.Msg.Show(new MessageBoxConfig
{
Title = "Error",
Message = "Please select Employer Account",
Buttons = MessageBox.Button.OK,
Icon = MessageBox.Icon.INFO,
Width = 350
});
return(this.Direct());
}
if (string.IsNullOrEmpty(WithdrawalRepo.GL_Account_No))
{
X.Msg.Show(new MessageBoxConfig
{
Title = "Error",
Message = "Please select Bank Account",
Buttons = MessageBox.Button.OK,
Icon = MessageBox.Icon.INFO,
Width = 350
});
return(this.Direct());
}
if (!WithdrawalRepo.Trans_Request_Date.HasValue)
{
X.Msg.Show(new MessageBoxConfig
{
Title = "Error",
Message = "Actual Request Date is a required field",
Buttons = MessageBox.Button.OK,
Icon = MessageBox.Icon.INFO,
Width = 350
});
return(this.Direct());
}
if (string.IsNullOrEmpty(WithdrawalRepo.Withdrawal_Reason))
{
X.Msg.Show(new MessageBoxConfig
{
Title = "Error",
Message = "Withdrawal Reason is a required field",
Buttons = MessageBox.Button.OK,
Icon = MessageBox.Icon.INFO,
Width = 350
});
return(this.Direct());
}
// check if there is a pending request for the employee scheme fund
if (WithdrawalRepo.GetcheckESFListEmp(WithdrawalRepo) == true)
{
X.Msg.Show(new MessageBoxConfig
{
Title = "Error",
Message = "Sorry! There is already a pending request for the Employee Account",
Buttons = MessageBox.Button.OK,
Icon = MessageBox.Icon.INFO,
Width = 350
});
return(this.Direct());
}
// validate scheme date
if (!string.IsNullOrEmpty(WithdrawalRepo.Scheme_Id))
{
GlobalValue.Get_Scheme_Today_Date(WithdrawalRepo.Scheme_Id);
if (WithdrawalRepo.Trans_Request_Date != GlobalValue.Scheme_Today_Date)
{
X.Msg.Show(new MessageBoxConfig
{
Title = "Error",
Message = "Sorry! Request date must be equal to scheme working date ",
Buttons = MessageBox.Button.OK,
Icon = MessageBox.Icon.INFO,
Width = 350
});
return(this.Direct());
}
}
else
{
X.Msg.Show(new MessageBoxConfig
{
Title = "Error",
Message = "Employee account cannot be verified.",
Buttons = MessageBox.Button.OK,
Icon = MessageBox.Icon.INFO,
Width = 350
});
}
////get GL balance from GL_Account Table
//WithdrawalRepo.Get_GL_Balance(WithdrawalRepo);
//if (WithdrawalRepo.Total_Withdrawal_Amount > WithdrawalRepo.GL_Balance * -1)
//{
// X.Msg.Show(new MessageBoxConfig
// {
// Title = "Error",
// Message = "Sorry! Insufficient Account Balance.Process aborted.",
// Buttons = MessageBox.Button.OK,
// Icon = MessageBox.Icon.ERROR,
// Width = 350
// });
// return this.Direct();
//}
WithdrawalRepo.GetESFList(WithdrawalRepo.ESF_Id);
WithdrawalRepo.Total_Withdrawal_Unit = Math.Round(WithdrawalRepo.Total_Withdrawal_Unit, 4);
WithdrawalRepo.Total_Unit_Balance = Math.Round(WithdrawalRepo.Total_Unit_Balance, 4);
if (WithdrawalRepo.Total_Withdrawal_Unit > WithdrawalRepo.Total_Unit_Balance)
{
X.Msg.Show(new MessageBoxConfig
{
Title = "Error",
Message = "Sorry!Total Withdrawal(Unit) can not be more than Total Unit",
Buttons = MessageBox.Button.OK,
Icon = MessageBox.Icon.INFO,
Width = 350
});
return(this.Direct());
}
//if (ModelState.IsValid)
//{
this.WithdrawalRepo.SaveRecord_TE(WithdrawalRepo);
X.Msg.Show(new MessageBoxConfig
{
Title = "Success",
Message = "Benefit Transfer Successfully Processed.",
Buttons = MessageBox.Button.OK,
Icon = MessageBox.Icon.INFO,
Width = 350
});
// ClearControls();
//Store store = X.GetCmp<Store>("WithdrawalESFStore");
//store.Reload();
//return this.Direct();
var pvr = new Ext.Net.MVC.PartialViewResult
{
ViewName = "WithdrawalPartial",
ContainerId = "MainArea",
RenderMode = RenderMode.AddTo,
};
this.GetCmp <TabPanel>("MainArea").SetLastTabAsActive();
return(pvr);
//}
//else
//{
// string messages = string.Join(Environment.NewLine, ModelState.Values
// .SelectMany(x => x.Errors)
// .Select(x => x.ErrorMessage));
// X.Msg.Show(new MessageBoxConfig
// {
// Title = "Error",
// Message = messages, // " Insufficient data. Operation Aborted",
// Buttons = MessageBox.Button.OK,
// Icon = MessageBox.Icon.ERROR,
// Width = 350
// });
// return this.Direct();
//}
}
catch (Exception ex)
{
throw ex;
}
}
public ActionResult ReverseRecord(Remit_WithdrawalRepo WithdrawalRepo)
{
try
{
if (WithdrawalRepo.Withdrawal_No == string.Empty)
{
X.Msg.Show(new MessageBoxConfig
{
Title = "Error",
Message = "Sorry! No Port In has been selected for reversal.",
Buttons = MessageBox.Button.OK,
Icon = MessageBox.Icon.ERROR,
Width = 350
});
return(this.Direct());
}
if (string.IsNullOrEmpty(WithdrawalRepo.Reverse_Reason))
{
X.Msg.Show(new MessageBoxConfig
{
Title = "Error",
Message = "Reversal Reason is required.",
Buttons = MessageBox.Button.OK,
Icon = MessageBox.Icon.ERROR,
Width = 350
});
return(this.Direct());
}
WithdrawalRepo.GetESFList(WithdrawalRepo.ESF_Id);
GlobalValue.Get_Scheme_Today_Date(WithdrawalRepo.Scheme_Id);
//// validate scheme date
//if (!string.IsNullOrEmpty(WithdrawalRepo.Scheme_Id))
//{
// GlobalValue.Get_Scheme_Today_Date(WithdrawalRepo.Scheme_Id);
// if (WithdrawalRepo.Trans_Date != GlobalValue.Scheme_Today_Date)
// {
// X.Msg.Show(new MessageBoxConfig
// {
// Title = "Error",
// Message = "Sorry! This transaction can not be reversed. Process aborted",
// Buttons = MessageBox.Button.OK,
// Icon = MessageBox.Icon.INFO,
// Width = 350
// });
// return this.Direct();
// }
//}
//else
//{
// X.Msg.Show(new MessageBoxConfig
// {
// Title = "Error",
// Message = "Employee account cannot be verified.",
// Buttons = MessageBox.Button.OK,
// Icon = MessageBox.Icon.INFO,
// Width = 350
// });
//}
///reverse port in
WithdrawalRepo.Reverse_Unit_PortIn(WithdrawalRepo);
X.Msg.Show(new MessageBoxConfig
{
Title = "Success",
Message = "Porting In Successfully Reversed.",
Buttons = MessageBox.Button.OK,
Icon = MessageBox.Icon.INFO,
Width = 350
});
var pvr = new Ext.Net.MVC.PartialViewResult
{
ViewName = "PortInReversePartial",
ContainerId = "MainArea",
RenderMode = RenderMode.AddTo,
};
this.GetCmp <TabPanel>("MainArea").SetLastTabAsActive();
return(pvr);
}
catch (Exception ex)
{
throw ex;
}
}
//public ActionResult AddReversePurchaseTab(string containerId = "MainArea")
//{
// var pvr = new Ext.Net.MVC.PartialViewResult
// {
// ViewName = "ReversePurchasePartial",
// ContainerId = containerId,
// RenderMode = RenderMode.AddTo,
// };
// this.GetCmp<TabPanel>(containerId).SetLastTabAsActive();
// return pvr;
//}
public ActionResult SaveRecord_Port(Remit_WithdrawalRepo WithdrawalRepo)
{
try
{
if ((WithdrawalRepo.Employee_Amount + WithdrawalRepo.Employee_Amount) <= 0)
{
X.Msg.Show(new MessageBoxConfig
{
Title = "Error",
Message = "Total port-in amount must be more than 0",
Buttons = MessageBox.Button.OK,
Icon = MessageBox.Icon.INFO,
Width = 350
});
return(this.Direct());
}
if (!WithdrawalRepo.Trans_Date.HasValue)
{
X.Msg.Show(new MessageBoxConfig
{
Title = "Error",
Message = "Sorry!Invalid Date",
Buttons = MessageBox.Button.OK,
Icon = MessageBox.Icon.INFO,
Width = 350
});
return(this.Direct());
}
// validate scheme date
if (!string.IsNullOrEmpty(WithdrawalRepo.Scheme_Id))
{
GlobalValue.Get_Scheme_Today_Date(WithdrawalRepo.Scheme_Id);
if (WithdrawalRepo.Trans_Date != GlobalValue.Scheme_Today_Date)
{
X.Msg.Show(new MessageBoxConfig
{
Title = "Error",
Message = "Sorry!Date must be equal to scheme working date ",
Buttons = MessageBox.Button.OK,
Icon = MessageBox.Icon.INFO,
Width = 350
});
return(this.Direct());
}
}
else
{
X.Msg.Show(new MessageBoxConfig
{
Title = "Error",
Message = "Employee account cannot be verified.",
Buttons = MessageBox.Button.OK,
Icon = MessageBox.Icon.INFO,
Width = 350
});
}
if (string.IsNullOrEmpty(WithdrawalRepo.Previous_Trustee))
{
X.Msg.Show(new MessageBoxConfig
{
Title = "Error",
Message = "Previous Trustee is a required field",
Buttons = MessageBox.Button.OK,
Icon = MessageBox.Icon.INFO,
Width = 350
});
return(this.Direct());
}
if (string.IsNullOrEmpty(WithdrawalRepo.GL_Account_No))
{
X.Msg.Show(new MessageBoxConfig
{
Title = "Error",
Message = "Receiving Account is a required field",
Buttons = MessageBox.Button.OK,
Icon = MessageBox.Icon.INFO,
Width = 350
});
return(this.Direct());
}
WithdrawalRepo.GetESFList(WithdrawalRepo.ESF_Id);
if (WithdrawalRepo.ESF_Id != null)
{
this.WithdrawalRepo.SaveRecord_Port(WithdrawalRepo);
X.Msg.Show(new MessageBoxConfig
{
Title = "Success",
Message = "Port In Successfully Processed.",
Buttons = MessageBox.Button.OK,
Icon = MessageBox.Icon.INFO,
Width = 350
});
var pvr = new Ext.Net.MVC.PartialViewResult
{
ViewName = "PortInPartial",
ContainerId = "MainArea",
RenderMode = RenderMode.AddTo,
};
this.GetCmp <TabPanel>("MainArea").SetLastTabAsActive();
return(pvr);
}
else
{
string messages = string.Join(Environment.NewLine, ModelState.Values
.SelectMany(x => x.Errors)
.Select(x => x.ErrorMessage));
X.Msg.Show(new MessageBoxConfig
{
Title = "Error",
Message = messages, // " Insufficient data. Operation Aborted",
Buttons = MessageBox.Button.OK,
Icon = MessageBox.Icon.ERROR,
Width = 350
});
return(this.Direct());
}
}
catch (Exception ex)
{
throw ex;
}
}