public ActionResult GetDynamicNatureOfParticularCT()
{
FM_Fees_Fee model = new FM_Fees_Fee();
model.ParticularList = new SelectList((from s in TOSSDB.NatureOfParticulars.ToList() select new { NatureofParticularID = s.NatureofParticularID, NatureofParticularName = s.NatureofParticularName }), "NatureofParticularID", "NatureofParticularName");
return(PartialView("Particulars/_DynamicDDNatureOfParticular", model));
}
public ActionResult GetDynamicFundType()
{
FM_Fees_Fee model = new FM_Fees_Fee();
var Acronym = "";
foreach (var item in TOSSDB.SubFunds.ToList())
{
for (var i = 0; i < item.Fund.FundName.Length;)
{
if (i == 0)
{
Acronym += item.Fund.FundName[i].ToString();
}
if (item.Fund.FundName[i] == ' ')
{
Acronym += item.Fund.FundName[i + 1].ToString();
}
i++;
}
model.globalClasses.fieldFeeDDs.Add(new FieldFeeDD
{
SubFundID = item.SubFundID,
FundName = Acronym + " - " + item.SubFundName,
});
Acronym = "";
}
model.FieldFeeList = new SelectList(model.globalClasses.fieldFeeDDs.ToList(), "SubFundID", "FundName");
return(PartialView("Fee/_DynamicFundType", model));
}
public ActionResult GetDynamicGeneralAccountCodeCT(int RevisionYearID)
{
FM_Fees_Fee model = new FM_Fees_Fee();
model.ParticularList = new SelectList((from s in TOSSDB.GeneralAccounts.ToList() where s.SubMajorAccountGroup.MajorAccountGroup.AccountGroup.AllotmentClass.RevisionYear.RevisionYearID == RevisionYearID select new { GeneralAccountID = s.GeneralAccountID, GeneralAccountCode = s.SubMajorAccountGroup.MajorAccountGroup.AccountGroup.AccountGroupCode + "-" + s.SubMajorAccountGroup.MajorAccountGroup.MajorAccountGroupCode + "-" + s.SubMajorAccountGroup.SubMajorAccountGroupCode + "-" + s.GeneralAccountCode + " - " + s.GeneralAccountName }), "GeneralAccountID", "GeneralAccountCode");
return(PartialView("Particulars/_DynamicDDGeneralAccountCode", model));
}
//Dropdown Fund
public ActionResult GetDynamicAccountableFormDescription()
{
FM_Fees_Fee model = new FM_Fees_Fee();
model.FeeCategoryList = new SelectList((from s in TOSSDB.AF_Description.ToList() select new { AFDescriptionID = s.AFDescriptionID, DescriptionName = s.DescriptionName }), "AFDescriptionID", "DescriptionName");
return(PartialView("Fee/FeeCategory/_DynamicDDAccountableFormDescription", model));
}
public ActionResult GetDynamicFeeCategory()
{
FM_Fees_Fee model = new FM_Fees_Fee();
model.FieldFeeList = new SelectList((from s in TOSSDB.FeeCategories.ToList() select new { FeeCategoryID = s.FeeCategoryID, FeeCategoryName = s.FeeCategoryName }), "FeeCategoryID", "FeeCategoryName");
return(PartialView("Fee/_DynamicDDFeeCategoryName", model));
}
//Table Nature Of Particulars
public ActionResult Get_NatureOfParticularTable()
{
FM_Fees_Fee model = new FM_Fees_Fee();
List <NatureofParticularList> tbl_Fees = new List <NatureofParticularList>();
var SQLQuery = "SELECT NatureofParticularID,NatureofParticularName FROM DB_TOSS.dbo.NatureOfParticular";
//SQLQuery += " WHERE (IsActive != 0)";
using (SqlConnection Connection = new SqlConnection(GlobalFunction.ReturnConnectionString()))
{
Connection.Open();
using (SqlCommand command = new SqlCommand("[dbo].[SP_PayeeList]", Connection))
{
command.CommandType = CommandType.StoredProcedure;
command.Parameters.Add(new SqlParameter("@SQLStatement", SQLQuery));
SqlDataReader dr = command.ExecuteReader();
while (dr.Read())
{
tbl_Fees.Add(new NatureofParticularList()
{
NatureofParticularID = GlobalFunction.ReturnEmptyInt(dr[0]),
NatureofParticularName = GlobalFunction.ReturnEmptyString(dr[1]),
});
}
}
Connection.Close();
}
model.getNatureofParticularList = tbl_Fees.ToList();
return(PartialView("Particulars/NatureOfParticular/_NatureOfParticularTable", model.getNatureofParticularList));
}
//Table Field Fees
public ActionResult Get_FieldFeeTable()
{
FM_Fees_Fee model = new FM_Fees_Fee();
List <FieldFeeList> tbl_Fees = new List <FieldFeeList>();
var SQLQuery = "SELECT FieldFeeID,FieldFeeDescription,GeneralAccount.GeneralAccountID,Rate,FeeCategory.FeeCategoryID,SubFund.SubFundID FROM DB_TOSS.dbo.FieldFee,GeneralAccount,FeeCategory,SubFund where GeneralAccount.GeneralAccountID = FieldFee.GeneralAccountID AND FeeCategory.FeeCategoryID = FieldFee.FeeCategoryID AND SubFund.SubFundID = FieldFee.SubFundID";
//SQLQuery += " WHERE (IsActive != 0)";
using (SqlConnection Connection = new SqlConnection(GlobalFunction.ReturnConnectionString()))
{
Connection.Open();
using (SqlCommand command = new SqlCommand("[dbo].[SP_PayeeList]", Connection))
{
command.CommandType = CommandType.StoredProcedure;
command.Parameters.Add(new SqlParameter("@SQLStatement", SQLQuery));
SqlDataReader dr = command.ExecuteReader();
while (dr.Read())
{
tbl_Fees.Add(new FieldFeeList()
{
FieldFeeID = GlobalFunction.ReturnEmptyInt(dr[0]),
FieldFeeDescription = GlobalFunction.ReturnEmptyString(dr[1]),
Rate = GlobalFunction.ReturnEmptyInt(dr[3]),
AccountCode = GlobalFunction.ReturnEmptyInt(dr[2]),
FeeCategory = GlobalFunction.ReturnEmptyInt(dr[4]),
FundType = GlobalFunction.ReturnEmptyInt(dr[5]),
});
}
}
Connection.Close();
}
model.getFieldFeeList = tbl_Fees.ToList();
return(PartialView("Fee/_FeesTable", model.getFieldFeeList));
}
public ActionResult Get_FeeCategoryTable()
{
FM_Fees_Fee model = new FM_Fees_Fee();
List <FeeCategoryList> tbl_Fees = new List <FeeCategoryList>();
var SQLQuery = "SELECT FeeCategoryID, FeeCategoryName,AF_Description.DescriptionName FROM DB_TOSS.dbo.FeeCategory,dbo.AF_Description where dbo.AF_Description.AFDescriptionID = dbo.FeeCategory.AFDescriptionID";
//SQLQuery += " WHERE (IsActive != 0)";
using (SqlConnection Connection = new SqlConnection(GlobalFunction.ReturnConnectionString()))
{
Connection.Open();
using (SqlCommand command = new SqlCommand("[dbo].[SP_PayeeList]", Connection))
{
command.CommandType = CommandType.StoredProcedure;
command.Parameters.Add(new SqlParameter("@SQLStatement", SQLQuery));
SqlDataReader dr = command.ExecuteReader();
while (dr.Read())
{
tbl_Fees.Add(new FeeCategoryList()
{
FeeCategoryID = Convert.ToInt32(dr[0]),
FeeCategoryName = GlobalFunction.ReturnEmptyString(dr[1]),
AFDescription = GlobalFunction.ReturnEmptyString(dr[2]),
});
}
}
Connection.Close();
}
model.getFeeCategoryList = tbl_Fees.ToList();
return(PartialView("Fee/FeeCategory/_FeeCategoryTable", model.getFeeCategoryList));
}
public ActionResult GetDynamicRevisionYear()
{
FM_Fees_Fee model = new FM_Fees_Fee();
model.FieldFeeList = new SelectList((from s in TOSSDB.RevisionYears.ToList() where s.IsUsed == true select new { RevisionYearID = s.RevisionYearID, RevisionYearDate = s.RevisionYearDate }), "RevisionYearID", "RevisionYearDate");
return(PartialView("Fee/_DynamicDDRevisionYear", model));
}
public ActionResult GetDynamicGeneralAccountCode()
{
FM_Fees_Fee model = new FM_Fees_Fee();
model.FieldFeeList = new SelectList((from s in TOSSDB.GeneralAccounts.ToList() select new { GeneralAccountID = s.GeneralAccountID, GeneralAccountCode = s.SubMajorAccountGroup.MajorAccountGroup.AccountGroup.AccountGroupCode + "-" + s.SubMajorAccountGroup.MajorAccountGroup.MajorAccountGroupCode + "-" + s.SubMajorAccountGroup.SubMajorAccountGroupCode + "-" + s.GeneralAccountCode + " - " + s.GeneralAccountName }), "GeneralAccountID", "GeneralAccountCode");
return(PartialView("Fee/_DynamicDDGeneralAccountCode", model));
}
//Delete Field Fees
public ActionResult DeleteFieldFee(FM_Fees_Fee model, int FieldFeeID)
{
FieldFee tblFieldFees = (from e in TOSSDB.FieldFees where e.FieldFeeID == FieldFeeID select e).FirstOrDefault();
TOSSDB.FieldFees.Remove(tblFieldFees);
TOSSDB.SaveChanges();
return(RedirectToAction("Index"));
}
//Get Update Field Fees
public ActionResult Get_UpdateNatureOfParticular(FM_Fees_Fee model, int NatureofParticularID)
{
NatureOfParticular tblNatureOfParticulars = (from e in TOSSDB.NatureOfParticulars where e.NatureofParticularID == NatureofParticularID select e).FirstOrDefault();
model.getNatureofParticularcolumns.NatureofParticularID = tblNatureOfParticulars.NatureofParticularID;
model.getNatureofParticularcolumns.NatureofParticularName = tblNatureOfParticulars.NatureofParticularName;
return(PartialView("Particulars/NatureOfParticular/_UpdateNatureOfParticular", model));
}
//Delete Internal Revenue Allotment
public ActionResult DeleteFeeCategory(FM_Fees_Fee model, int FeeCategoryID)
{
FeeCategory tblFeeCategory = (from e in TOSSDB.FeeCategories where e.FeeCategoryID == FeeCategoryID select e).FirstOrDefault();
TOSSDB.FeeCategories.Remove(tblFeeCategory);
TOSSDB.SaveChanges();
return(RedirectToAction("Index"));
}
public ActionResult GetSelectedDynamicRevisionYearCT(int RevisionYearTempIDCT)
{
FM_Fees_Fee model = new FM_Fees_Fee();
model.ParticularList = new SelectList((from s in TOSSDB.RevisionYears.ToList() where s.IsUsed == true select new { RevisionYearID = s.RevisionYearID, RevisionYearDate = s.RevisionYearDate }), "RevisionYearID", "RevisionYearDate");
model.RevisionYearTempID = RevisionYearTempIDCT;
return(PartialView("Particulars/_DynamicDDRevisionYear", model));
}
//Delete Field Fees
public ActionResult DeleteNatureOfParticular(FM_Fees_Fee model, int NatureofParticularID)
{
NatureOfParticular tblNatureOfParticular = (from e in TOSSDB.NatureOfParticulars where e.NatureofParticularID == NatureofParticularID select e).FirstOrDefault();
TOSSDB.NatureOfParticulars.Remove(tblNatureOfParticular);
TOSSDB.SaveChanges();
return(RedirectToAction("Index"));
}
public JsonResult AddNatureOfParticular(FM_Fees_Fee model)
{
NatureOfParticular tblNatureOfParticular = new NatureOfParticular();
tblNatureOfParticular.NatureofParticularName = model.getNatureofParticularcolumns.NatureofParticularName;
TOSSDB.NatureOfParticulars.Add(tblNatureOfParticular);
TOSSDB.SaveChanges();
return(Json(tblNatureOfParticular));
}
public ActionResult UpdateNatureOfParticular(FM_Fees_Fee model)
{
NatureOfParticular tblNatureOfParticular = (from e in TOSSDB.NatureOfParticulars where e.NatureofParticularID == model.getNatureofParticularcolumns.NatureofParticularID select e).FirstOrDefault();
tblNatureOfParticular.NatureofParticularName = model.getNatureofParticularcolumns.NatureofParticularName;
TOSSDB.Entry(tblNatureOfParticular);
TOSSDB.SaveChanges();
return(PartialView("Particulars/NatureOfParticular/_UpdateNatureOfParticular", model));
}
//Get Update Field Fees
public ActionResult Get_UpdateParticular(FM_Fees_Fee model, int ParticularID)
{
Particular tblParticular = (from e in TOSSDB.Particulars where e.ParticularID == ParticularID select e).FirstOrDefault();
model.getParticularcolumns.ParticularID = tblParticular.ParticularID;
model.NatureOfParticularTempIDCT = tblParticular.NatureofParticularID;
model.GeneralAccountTempIDCT = tblParticular.GeneralAccountID;
return(PartialView("Particulars/_UpdateParticulars", model));
}
//Get Update Internal Revenue Allotment
public ActionResult Get_UpdateFeeCategory(FM_Fees_Fee model, int FeeCategoryID)
{
FeeCategory tblFeeCategory = (from e in TOSSDB.FeeCategories where e.FeeCategoryID == FeeCategoryID select e).FirstOrDefault();
model.getFeeCategorycolumns.FeeCategoryID = tblFeeCategory.FeeCategoryID;
model.getFeeCategorycolumns.FeeCategoryName = tblFeeCategory.FeeCategoryName;
model.AccountFormTempID = tblFeeCategory.AFDescriptionID;
return(PartialView("Fee/FeeCategory/_UpdateFeeCategory", model));
}
public JsonResult AddFeeCategory(FM_Fees_Fee model)
{
FeeCategory tblFeeCategory = new FeeCategory();
tblFeeCategory.FeeCategoryName = model.getFeeCategorycolumns.FeeCategoryName;
tblFeeCategory.AFDescriptionID = model.AFDescriptionID;
TOSSDB.FeeCategories.Add(tblFeeCategory);
TOSSDB.SaveChanges();
return(Json(tblFeeCategory));
}
public ActionResult UpdateParticular(FM_Fees_Fee model)
{
Particular tblParticular = (from e in TOSSDB.Particulars where e.ParticularID == model.getParticularcolumns.ParticularID select e).FirstOrDefault();
tblParticular.NatureofParticularID = model.NatureOfParticularIDCT;
tblParticular.GeneralAccountID = model.GeneralAccountIDCT;
TOSSDB.Entry(tblParticular);
TOSSDB.SaveChanges();
return(PartialView("Particulars/_UpdateParticulars", model));
}
//Update Internal Revenue Allotment
public ActionResult UpdateFeeCategory(FM_Fees_Fee model)
{
FeeCategory tblFeeCategory = (from e in TOSSDB.FeeCategories where e.FeeCategoryID == model.getFeeCategorycolumns.FeeCategoryID select e).FirstOrDefault();
tblFeeCategory.FeeCategoryName = model.getFeeCategorycolumns.FeeCategoryName;
tblFeeCategory.AFDescriptionID = model.AFDescriptionID;
TOSSDB.Entry(tblFeeCategory);
TOSSDB.SaveChanges();
return(PartialView("Fee/FeeCategory/_UpdateFeeCategory", model));
}
public JsonResult AddParticular(FM_Fees_Fee model)
{
Particular tblParticular = new Particular();
tblParticular.NatureofParticularID = model.NatureOfParticularIDCT;
tblParticular.GeneralAccountID = model.GeneralAccountIDCT;
TOSSDB.Particulars.Add(tblParticular);
TOSSDB.SaveChanges();
return(Json(tblParticular));
}
//Get Update Field Fees
public ActionResult Get_UpdateFieldFee(FM_Fees_Fee model, int FieldFeeID)
{
FieldFee tblFieldFee = (from e in TOSSDB.FieldFees where e.FieldFeeID == FieldFeeID select e).FirstOrDefault();
model.getFieldFeecolumns.FieldFeeID = tblFieldFee.FieldFeeID;
model.getFieldFeecolumns.FieldFeeDescription = tblFieldFee.FieldFeeDescription;
model.getFieldFeecolumns.Rate = tblFieldFee.Rate;
model.AccountCodeTempID = tblFieldFee.GeneralAccountID;
model.FundTypeTempID = tblFieldFee.SubFundID;
model.FeeCategoryTempID = tblFieldFee.FeeCategoryID;
model.RevisionYearTempID = tblFieldFee.GeneralAccount.SubMajorAccountGroup.MajorAccountGroup.AccountGroup.AllotmentClass.RevisionYear.RevisionYearID;
model.isRequired = tblFieldFee.ORRequired;
return(PartialView("Fee/_UpdateFees", model));
}
//Get Add Field Fees
public JsonResult AddFieldFee(FM_Fees_Fee model)
{
FieldFee tblFieldFee = new FieldFee();
tblFieldFee.FieldFeeDescription = model.getFieldFeecolumns.FieldFeeDescription;
tblFieldFee.Rate = model.getFieldFeecolumns.Rate;
tblFieldFee.GeneralAccountID = model.AccountCodeID;
tblFieldFee.SubFundID = model.FundTypeID;
tblFieldFee.FeeCategoryID = model.FeeCategoryID;
tblFieldFee.ORRequired = model.isRequired;
TOSSDB.FieldFees.Add(tblFieldFee);
TOSSDB.SaveChanges();
return(Json(tblFieldFee));
}
public ActionResult UpdateFieldFee(FM_Fees_Fee model)
{
FieldFee tblFieldFee = (from e in TOSSDB.FieldFees where e.FieldFeeID == model.getFieldFeecolumns.FieldFeeID select e).FirstOrDefault();
tblFieldFee.FieldFeeDescription = model.getFieldFeecolumns.FieldFeeDescription;
tblFieldFee.Rate = model.getFieldFeecolumns.Rate;
tblFieldFee.GeneralAccountID = model.AccountCodeID;
tblFieldFee.SubFundID = model.FundTypeID;
tblFieldFee.FeeCategoryID = model.FeeCategoryID;
tblFieldFee.ORRequired = model.isRequired;
TOSSDB.Entry(tblFieldFee);
TOSSDB.SaveChanges();
return(PartialView("Fee/_UpdateFees", model));
}
public ActionResult Get_AddFeeCategory()
{
FM_Fees_Fee model = new FM_Fees_Fee();
return(PartialView("Fee/FeeCategory/_AddFeeCategory", model));
}
//Get Add Field Fees Partial View
public ActionResult Get_AddFieldFees()
{
FM_Fees_Fee model = new FM_Fees_Fee();
return(PartialView("Fee/_AddFees", model));
}
//Get Add Nature Of Particulars Partial View
public ActionResult Get_AddNatureOfParticular()
{
FM_Fees_Fee model = new FM_Fees_Fee();
return(PartialView("Particulars/NatureOfParticular/_AddNatureOfParticular", model));
}
