public static bool Save(DayCarePL.SchoolProgramFeesDetailProperties objSchoolProgramFeesDetail)
{
DayCarePL.Logger.Write(DayCarePL.LogType.INFO, DayCarePL.ModuleToLog.clSchoolProgram, "Save", "Execute Save Method", DayCarePL.Common.GUID_DEFAULT);
SqlConnection conn = clConnection.CreateConnection();
try
{
DayCarePL.Logger.Write(DayCarePL.LogType.DEBUG, DayCarePL.ModuleToLog.clSchoolProgram, "Save", "Debug Save Method", DayCarePL.Common.GUID_DEFAULT);
clConnection.OpenConnection(conn);
SqlCommand cmd;
if (objSchoolProgramFeesDetail.Id.ToString().Equals(DayCarePL.Common.GUID_DEFAULT))
{
cmd = clConnection.CreateCommand("spAddSchoolProgramFeesDetail", conn);
cmd.Parameters.Add(clConnection.GetInputParameter("@CreatedById", objSchoolProgramFeesDetail.LastmodifiedById));
}
else
{
cmd = clConnection.CreateCommand("spUpdateSchoolProgramFeesDetail", conn);
}
if (!objSchoolProgramFeesDetail.Id.ToString().Equals(DayCarePL.Common.GUID_DEFAULT))
{
cmd.Parameters.Add(clConnection.GetInputParameter("@Id", objSchoolProgramFeesDetail.Id));
}
cmd.Parameters.Add(clConnection.GetInputParameter("@SchoolProgramId", objSchoolProgramFeesDetail.SchoolProgramId));
cmd.Parameters.Add(clConnection.GetInputParameter("@Fees", objSchoolProgramFeesDetail.Fees));
cmd.Parameters.Add(clConnection.GetInputParameter("@FeesPeriodId", objSchoolProgramFeesDetail.FeesPeriodId));
cmd.Parameters.Add(clConnection.GetInputParameter("@EffectiveYearDate", objSchoolProgramFeesDetail.EffectiveYearDate));
cmd.Parameters.Add(clConnection.GetInputParameter("@EffectiveMonthDay", objSchoolProgramFeesDetail.EffectiveMonthDay));
cmd.Parameters.Add(clConnection.GetInputParameter("@EffectiveWeekDay", objSchoolProgramFeesDetail.EffectiveWeekDay));
cmd.Parameters.Add(clConnection.GetInputParameter("@LastModifiedById", objSchoolProgramFeesDetail.LastmodifiedById));
//cmd.Parameters.Add(clConnection.GetInputParameter("@LateFeesCharge", objSchoolProgramFeesDetail.LateFeesCharge));
cmd.Parameters.Add(clConnection.GetOutputParameter("@Result", SqlDbType.Bit));
cmd.ExecuteNonQuery();
if (Convert.ToBoolean(cmd.Parameters["@Result"].Value))
{
return(true);
}
return(false);
}
catch (Exception ex)
{
DayCarePL.Logger.Write(DayCarePL.LogType.EXCEPTION, DayCarePL.ModuleToLog.clSchoolProgram, "Save", ex.Message.ToString(), DayCarePL.Common.GUID_DEFAULT);
return(false);
}
finally
{
clConnection.CloseConnection(conn);
}
}
public static List <DayCarePL.SchoolProgramFeesDetailProperties> LoadSchoolProgramFeesDetail(Guid SchoolProgramId)
{
DayCarePL.Logger.Write(DayCarePL.LogType.INFO, DayCarePL.ModuleToLog.clChildProgEnrollment, "Save", "Execute Save Method", DayCarePL.Common.GUID_DEFAULT);
clConnection.DoConnection();
DayCareDataContext db = new DayCareDataContext();
List <DayCarePL.SchoolProgramFeesDetailProperties> lstSchoolProgramFeesDetail = new List <DayCarePL.SchoolProgramFeesDetailProperties>();
try
{
DayCarePL.Logger.Write(DayCarePL.LogType.DEBUG, DayCarePL.ModuleToLog.clChildProgEnrollment, "LoadChildFamily", "Debug LoadChildFamily Method", DayCarePL.Common.GUID_DEFAULT);
DayCarePL.SchoolProgramFeesDetailProperties objSchoolProgramFeesDetail = null;
var data = db.spGetSchoolProgramFeesDetail(SchoolProgramId);
foreach (var d in data)
{
objSchoolProgramFeesDetail = new DayCarePL.SchoolProgramFeesDetailProperties();
objSchoolProgramFeesDetail.SchoolProgram = d.ProgramTitle;
objSchoolProgramFeesDetail.FeesPeriod = d.Name;
objSchoolProgramFeesDetail.SchoolProgramId = d.SchoolProgramId;
objSchoolProgramFeesDetail.FeesPeriodId = d.FeesPeriodId;
objSchoolProgramFeesDetail.Id = d.Id;
objSchoolProgramFeesDetail.Fees = d.Fees;
// objSchoolProgramFeesDetail.LateFeesCharge = d.LateFeesCharge;
objSchoolProgramFeesDetail.EffectiveWeekDay = Convert.ToInt32(d.EffectiveWeekDay == null ? null : d.EffectiveWeekDay);
objSchoolProgramFeesDetail.EffectiveMonthDay = Convert.ToInt32(d.EffectiveMonthDay == null ? null : d.EffectiveMonthDay);
if (d.EffectiveYearDate != null)
{
objSchoolProgramFeesDetail.EffectiveYearDate = d.EffectiveYearDate.Value;
}
lstSchoolProgramFeesDetail.Add(objSchoolProgramFeesDetail);
}
return(lstSchoolProgramFeesDetail);
}
catch (Exception ex)
{
DayCarePL.Logger.Write(DayCarePL.LogType.EXCEPTION, DayCarePL.ModuleToLog.clChildProgEnrollment, "Save", ex.Message.ToString(), DayCarePL.Common.GUID_DEFAULT);
return(null);
}
}
public bool Save(DayCarePL.SchoolProgramFeesDetailProperties objSchoolProgramFeesDetail)
{
return(DayCareDAL.clSchoolProgramFeesDetail.Save(objSchoolProgramFeesDetail));
}
