// filter GL Account for scheme
public ActionResult GetGLFeeID(GLFeeRepo GLFee)
{
var misdepartmentrepo = new GLFeeRepo();
var mydata = misdepartmentrepo.GetFeesList2(GLFee);
List <object> data = new List <object>();
foreach (var ddd in mydata)
{
string id = ddd.Fund_Manager_Id;
string name = ddd.Fund_Manager;
data.Add(new { GLFeeId = id, GLFeeName = name });
}
return(this.Store(data));
}
public ActionResult GetGLFeeApply(GLFeeRepo GLFee)
{
try
{
if (string.IsNullOrEmpty(GLFee.Scheme_Fund_Id))
{
X.Msg.Show(new MessageBoxConfig
{
Title = "Error",
Message = "Please select scheme account.",
Buttons = MessageBox.Button.OK,
Icon = MessageBox.Icon.INFO,
Width = 350
});
return(this.Direct());
}
if (string.IsNullOrEmpty(GLFee.Fee_Id))
{
X.Msg.Show(new MessageBoxConfig
{
Title = "Error",
Message = "Please select fee.",
Buttons = MessageBox.Button.OK,
Icon = MessageBox.Icon.INFO,
Width = 350
});
return(this.Direct());
}
// GlobalValue.Get_Scheme_Today_Date(GLFee.Scheme_Id);
//APPLY FEES EOD_ACCRUE_SF_FEES
if (string.IsNullOrEmpty(GLFee.Fund_Manager_Id))
{
GLFee.Fund_Manager_Id = "NA";
}
var con = new AppSettings();
var paramACCAPP = new DynamicParameters();
paramACCAPP.Add("P_SCHEME_ID", GLFee.Scheme_Fund_Id, DbType.String, ParameterDirection.Input);
paramACCAPP.Add("P_FEE_ID", GLFee.Fee_Id, DbType.String, ParameterDirection.Input);
paramACCAPP.Add("P_FM_ID", GLFee.Fund_Manager_Id, DbType.String, ParameterDirection.Input);
paramACCAPP.Add("P_VALUE_DATE", GlobalValue.Scheme_Today_Date, DbType.Date, ParameterDirection.Input);
con.GetConnection().Execute("APPLY_FEES_FORCE", paramACCAPP, commandType: CommandType.StoredProcedure);
GLFee.GetFeesList2(GLFee);
this.GetCmp <TextField>("GLFeeCreate_FeeID").SetValue("");
this.GetCmp <TextField>("GLFee_Apply_Bal").SetValue("");
this.GetCmp <DateField>("GLFee_Last_Apply_Date").SetValue("");
this.GetCmp <DateField>("GLFee_Last_Paid_Date").SetValue("");
//PREVIEW
return(this.Direct());
}
catch (System.Exception ex)
{
throw ex;
}
}
