public JsonResult SaveFeeTerm(string FeeTerm, int Refundable, int Active)
{
FeeHead FH = new FeeHead();
ChannelFactory <ICommonSrv> CF = new ChannelFactory <ICommonSrv>("COMMON");
ChannelFactory <IFeeSrv> CFFee = new ChannelFactory <IFeeSrv>("FEE");
ICommonSrv CSvc = (ICommonSrv)CF.CreateChannel();
IFeeSrv CSFee = (IFeeSrv)CFFee.CreateChannel();
string actionStatus = "";
try
{
UserMasters userMasters = CSvc.getUserProfile(WebSecurity.CurrentUserName);
FH.FeeTerm = FeeTerm;
FH.Refundable = Convert.ToBoolean(Refundable);
FH.Active = Convert.ToBoolean(Active);
FH.Action = "INS";
FH.CreatedBy = WebSecurity.CurrentUserName;
FH.SchoolID = userMasters.SchoolID;
actionStatus = CSFee.SaveFeeTerm(FH);
}
catch (Exception ex)
{
ExecptionLogger.FileHandling("Fee(SaveFeeTerm)", "Error_014", ex, "Fee");
}
finally
{
CF.Close();
CFFee.Close();
}
return(Json(actionStatus, JsonRequestBehavior.AllowGet));
}
public string SaveFeeTerm(FeeHead FH)
{
string result = "";
try
{
cmd = new SqlCommand("USP_FEE_HEADS");
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@FeeTerm", FH.FeeTerm);
cmd.Parameters.Add("@Refundable", SqlDbType.Int, Convert.ToInt32(FH.Refundable));
cmd.Parameters.Add("@Active", SqlDbType.Int, Convert.ToInt32(FH.Active));
cmd.Parameters.AddWithValue("@SchoolID", FH.SchoolID);
cmd.Parameters.AddWithValue("@CreatedBy", FH.CreatedBy);
cmd.Parameters.AddWithValue("@Action", FH.Action);
result = Convert.ToString(DBHelper.ExecuteScalar(cmd));
}
catch (Exception ex)
{
ExecptionLogger.FileHandling("DALFee(SaveFeeTerm)", "Error_014", ex, "DALFee");
}
finally
{
cmd.Dispose();
}
return(result);
}
public List <FeeHead> GetFeeHeads(FeeHead FH)
{
List <FeeHead> obj = new List <FeeHead>();
try
{
cmd = new SqlCommand("USP_FEE_HEADS");
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@SchoolID", FH.SchoolID);
cmd.Parameters.AddWithValue("@CreatedBy", FH.CreatedBy);
cmd.Parameters.AddWithValue("@Action", FH.Action);
var dr = DBHelper.ExecuteReader(cmd);
while (dr.Read())
{
obj.Add(new FeeHead
{
SchoolID = Convert.ToString(dr["SchoolID"]),
FeeTerm = Convert.ToString(dr["FeeTerm"]),
Active = Convert.ToBoolean(dr["Active"]),
Refundable = Convert.ToBoolean(dr["Refundable"]),
CreatedBy = Convert.ToString(dr["CreatedBy"]),
});
}
}
catch (Exception ex)
{
ExecptionLogger.FileHandling("DALFee(SaveFeeTerm)", "Error_014", ex, "DALFee");
}
finally
{
cmd.Dispose();
}
return(obj);
}
public ActionResult Save(FeeHead obj)
{
//if (ModelState.IsValid == true)
//{
if (obj.FeeId == 0)
{
obj.FeeId = Convert.ToInt32(db.FeeHeads.Max(x => (int?)x.FeeId) ?? 0) + 1;
obj.SessionName = "2013-2014";
obj.UpdateBy = Session["User"].ToString();
obj.UpdateDate = DateTime.Now.Date;
db.FeeHeads.Add(obj);
}
else
{
FeeHead _feehead = db.FeeHeads.Where(x => x.FeeId == obj.FeeId).FirstOrDefault();
if (_feehead != null)
{
db.Entry(_feehead).CurrentValues.SetValues(obj);
}
}
db.SaveChanges();
ModelState.Clear();
//}
return(View("Index"));
}
public ActionResult FeeHeads()
{
FeeHead FH = new FeeHead();
ChannelFactory <ICommonSrv> CF = new ChannelFactory <ICommonSrv>("COMMON");
ChannelFactory <IFeeSrv> CFFee = new ChannelFactory <IFeeSrv>("FEE");
ICommonSrv CSvc = (ICommonSrv)CF.CreateChannel();
IFeeSrv CSFee = (IFeeSrv)CFFee.CreateChannel();
try
{
UserMasters userMasters = CSvc.getUserProfile(WebSecurity.CurrentUserName);
FH.SchoolID = userMasters.SchoolID;
FH.CreatedBy = WebSecurity.CurrentUserName;
FH.Action = "GET";
FH.lstFeeHead = CSFee.GetFeeHeads(FH);
}
catch (Exception ex) { }
finally
{
CF.Close();
CFFee.Close();
}
return(View(FH));
}
public void Edit(FeeHead entity)
{
FeeHeadDAL dalObject = new FeeHeadDAL();
dalObject.Edit(entity);
}
public void Add(FeeHead entity)
{
FeeHeadDAL dalObject = new FeeHeadDAL();
dalObject.Add(entity);
}
public List <FeeHead> GetFeeHeads(FeeHead FH)
{
DALFee dal = new DALFee(ConStr);
return(dal.GetFeeHeads(FH));
}
public string SaveFeeHead(FeeHead FH)
{
DALFee dal = new DALFee(ConStr);
return(dal.SaveFeeHead(FH));
}
public List <FeeHead> GetFeeHeads(FeeHead FH)
{
BALFee bal = new BALFee(ConStr);
return(bal.GetFeeHeads(FH));
}
public string SaveFeeTerm(FeeHead FH)
{
BALFee bal = new BALFee(ConStr);
return(bal.SaveFeeTerm(FH));
}
public ActionResult edit(int id)
{
FeeHead _feehead = db.FeeHeads.SingleOrDefault(x => x.FeeId == id);
return(View("Index", _feehead));
}
