public static List <DayCarePL.SchoolProgramProperties> LoadSchoolProgramForChildSchedule(Guid SchoolId, Guid SchoolYearId)
{
DayCarePL.Logger.Write(DayCarePL.LogType.INFO, DayCarePL.ModuleToLog.clSchoolProgram, "LoadSchoolProgramForChildSchedule", "Execute LoadSchoolProgramForChildSchedule Method", DayCarePL.Common.GUID_DEFAULT);
clConnection.DoConnection();
DayCareDataContext db = new DayCareDataContext();
try
{
DayCarePL.Logger.Write(DayCarePL.LogType.DEBUG, DayCarePL.ModuleToLog.clSchoolProgram, "LoadSchoolProgramForChildSchedule", "Debug LoadSchoolProgramForChildSchedule Method", DayCarePL.Common.GUID_DEFAULT);
List <DayCarePL.SchoolProgramProperties> lstSchoolProgram = new List <DayCarePL.SchoolProgramProperties>();
DayCarePL.SchoolProgramProperties objSchoolProgram;
var data = db.spGetSchoolProgramForSchedule(SchoolId, SchoolYearId);
foreach (var d in data)
{
objSchoolProgram = new DayCarePL.SchoolProgramProperties();
objSchoolProgram.Id = d.Id;
objSchoolProgram.Title = d.Title;
objSchoolProgram.IsPrimary = Convert.ToBoolean(d.IsPrimary);
lstSchoolProgram.Add(objSchoolProgram);
}
return(lstSchoolProgram);
}
catch (Exception ex)
{
DayCarePL.Logger.Write(DayCarePL.LogType.EXCEPTION, DayCarePL.ModuleToLog.clSchoolProgram, "LoadSchoolProgramForChildSchedule", ex.Message.ToString(), DayCarePL.Common.GUID_DEFAULT);
return(null);
}
}
protected void rgSchoolProgram_ItemDataBound(object sender, Telerik.Web.UI.GridItemEventArgs e)
{
if (e.Item.ItemType == GridItemType.AlternatingItem || e.Item.ItemType == GridItemType.Item)
{
DayCarePL.SchoolProgramProperties objSchoolProgram = e.Item.DataItem as DayCarePL.SchoolProgramProperties;
HyperLink hlProgClassCategory = e.Item.FindControl("hlProgClassCategory") as HyperLink;
HyperLink hlProgSchedule = e.Item.FindControl("hlProgSchedule") as HyperLink;
HyperLink hlProgStaff = e.Item.FindControl("hlProgStaff") as HyperLink;
HyperLink hlProgClassRoom = e.Item.FindControl("hlProgClassRoom") as HyperLink;
string PageName = "";
//hlProgClassCategory.Attributes.Add("onclick", "ShowProgramClassCategory('" + objSchoolProgram.Id + "','" + objSchoolProgram.SchoolYearId + "','" + objSchoolProgram.IsPrimary + "','" + objSchoolProgram.Title + "'); return false;");
//hlProgSchedule.Attributes.Add("onclick", "ShowProgSchedule('" + objSchoolProgram.Id + "','" + objSchoolProgram.SchoolYearId + "','" + objSchoolProgram.IsPrimary + "','" + objSchoolProgram.Title + "'); return false;");
//hlProgStaff.Attributes.Add("onclick", "ShowProgramStaff('" + objSchoolProgram.Id + "','" + objSchoolProgram.SchoolYearId + "','" + objSchoolProgram.IsPrimary + "','" + objSchoolProgram.Title + "'); return false;");
PageName = "ProgramClassRoom.aspx?SchoolProgramId='" + objSchoolProgram.Id + "'&SchoolYearId='" + objSchoolProgram.SchoolYearId + "'&IsPrimary='" + objSchoolProgram.IsPrimary + "'";
hlProgClassRoom.Attributes.Add("onclick", "ShowProgramClassRoom('" + objSchoolProgram.Id + "','" + objSchoolProgram.SchoolYearId + "','" + objSchoolProgram.IsPrimary + "','" + objSchoolProgram.Title + "'); return false;");
//hlProgClassRoom.Attributes.Add("onclick", "ShowShortcut('" + PageName + "'); return false;");
}
if (e.Item.ItemType == GridItemType.EditItem)
{
GridEditableItem Itms = e.Item as GridEditableItem;
DayCarePL.SchoolProgramProperties objSchoolProgram = e.Item.DataItem as DayCarePL.SchoolProgramProperties;
DayCareBAL.SchoolProgramService proxySchoolProgram = new DayCareBAL.SchoolProgramService();
DropDownList ddlFeesPeriodName = e.Item.FindControl("ddlFeesPeriodName") as DropDownList;
CheckBox chkIsPrimary = Itms["IsPrimary"].Controls[0] as CheckBox;
Common.BindFeesPeriod(ddlFeesPeriodName);
if (objSchoolProgram != null)
{
if (ddlFeesPeriodName != null && ddlFeesPeriodName.Items.Count > 0)
{
ddlFeesPeriodName.SelectedValue = Convert.ToString(objSchoolProgram.FeesPeriodId);
}
if (objSchoolProgram.IsPrimary)
{
if (proxySchoolProgram.CheckSchoolProgramInChildSchedule(GetSchoolId(), objSchoolProgram.Id))
{
chkIsPrimary.Enabled = false;
chkIsPrimary.ToolTip = "You can not change, It is used in Child Schedule";
}
}
}
}
if (e.Item.ItemIndex == -1)
{
if (e.Item.Edit == true)
{
GridEditableItem dataItem = e.Item as Telerik.Web.UI.GridEditableItem;
CheckBox chkActive = dataItem["Active"].Controls[0] as CheckBox;
chkActive.Checked = true;
}
}
}
public static Guid Save(DayCarePL.SchoolProgramProperties objSchoolProgram)
{
DayCarePL.Logger.Write(DayCarePL.LogType.INFO, DayCarePL.ModuleToLog.clSchoolProgram, "Save", "Execute Save Method", DayCarePL.Common.GUID_DEFAULT);
SqlConnection conn = clConnection.CreateConnection();
Guid result = new Guid();
try
{
DayCarePL.Logger.Write(DayCarePL.LogType.DEBUG, DayCarePL.ModuleToLog.clSchoolProgram, "Save", "Debug Save Method", DayCarePL.Common.GUID_DEFAULT);
clConnection.OpenConnection(conn);
SqlCommand cmd;
if (objSchoolProgram.Id.ToString().Equals(DayCarePL.Common.GUID_DEFAULT))
{
cmd = clConnection.CreateCommand("spAddSchoolProgram", conn);
}
else
{
cmd = clConnection.CreateCommand("spUpdateSchoolProgram", conn);
}
if (!objSchoolProgram.Id.ToString().Equals(DayCarePL.Common.GUID_DEFAULT))
{
cmd.Parameters.Add(clConnection.GetInputParameter("@Id", objSchoolProgram.Id));
}
cmd.Parameters.Add(clConnection.GetInputParameter("@SchoolYearId", objSchoolProgram.SchoolYearId));
cmd.Parameters.Add(clConnection.GetInputParameter("@Title", objSchoolProgram.Title));
//cmd.Parameters.Add(clConnection.GetInputParameter("@Fees", 0));
// cmd.Parameters.Add(clConnection.GetInputParameter("@FeesPeriodId", DayCarePL.Common.GUID_DEFAULT));
cmd.Parameters.Add(clConnection.GetInputParameter("@Active", objSchoolProgram.Active));
cmd.Parameters.Add(clConnection.GetInputParameter("@IsPrimary", objSchoolProgram.IsPrimary));
cmd.Parameters.Add(clConnection.GetInputParameter("@Comments", objSchoolProgram.Comments));
cmd.Parameters.Add(clConnection.GetInputParameter("@CreatedById", objSchoolProgram.CreatedById));
cmd.Parameters.Add(clConnection.GetInputParameter("@LastModifiedById", objSchoolProgram.LastModifiedById));
// cmd.Parameters.Add(clConnection.GetOutputParameter("@Result", SqlDbType.Bit));
//cmd.Parameters.AddWithValue("@SchoolYearId", objSchoolProgram.SchoolYearId);
//cmd.Parameters.AddWithValue("@Title", objSchoolProgram.Title);
//cmd.Parameters.AddWithValue("@Fees", objSchoolProgram.Fees);
//cmd.Parameters.AddWithValue("@FeesPeriodId", objSchoolProgram.FeesPeriodId);
//cmd.Parameters.AddWithValue("@Active", objSchoolProgram.Active);
//cmd.Parameters.AddWithValue("@IsPrimary", objSchoolProgram.IsPrimary);
//cmd.Parameters.AddWithValue("@Comments", objSchoolProgram.Comments);
//cmd.Parameters.AddWithValue("@CreatedById", objSchoolProgram.CreatedById);
//cmd.Parameters.AddWithValue("@LastModifiedById", objSchoolProgram.LastModifiedById);
// cmd.Parameters.Add(new SqlParameter("@Result", SqlDbType.Bit)).Direction = ParameterDirection.Output;
//cmd.ExecuteNonQuery();
object SchoolProgramId = cmd.ExecuteScalar();
//if (Convert.ToBoolean(cmd.Parameters["@Result"].Value))
//{
// return true;
//}
//return false;
return(new Guid(SchoolProgramId.ToString()));
}
catch (Exception ex)
{
DayCarePL.Logger.Write(DayCarePL.LogType.EXCEPTION, DayCarePL.ModuleToLog.clSchoolProgram, "Save", ex.Message.ToString(), DayCarePL.Common.GUID_DEFAULT);
result = new Guid(DayCarePL.Common.GUID_DEFAULT);
}
finally
{
clConnection.CloseConnection(conn);
}
return(result);
}
public static List <DayCarePL.SchoolProgramProperties> LoadSchoolProgram(Guid SchoolId, Guid SchoolYearId)
{
DayCarePL.Logger.Write(DayCarePL.LogType.INFO, DayCarePL.ModuleToLog.clSchoolProgram, "LoadSchoolProgram", "Execute LoadSchoolProgram Method", DayCarePL.Common.GUID_DEFAULT);
clConnection.DoConnection();
DayCareDataContext db = new DayCareDataContext();
try
{
DayCarePL.Logger.Write(DayCarePL.LogType.DEBUG, DayCarePL.ModuleToLog.clSchoolProgram, "LoadSchoolProgram", "Debug LoadSchoolProgram Method", DayCarePL.Common.GUID_DEFAULT);
List <DayCarePL.SchoolProgramProperties> lstSchoolProgram = new List <DayCarePL.SchoolProgramProperties>();
DayCarePL.SchoolProgramProperties objSchoolProgram;
var data = db.spGetSchoolProgram(SchoolId, SchoolYearId);
foreach (var d in data)
{
objSchoolProgram = new DayCarePL.SchoolProgramProperties();
objSchoolProgram.Id = d.Id;
objSchoolProgram.SchoolYearId = d.SchoolYearId;
objSchoolProgram.Active = d.Active;
//objSchoolProgram.Fees = Convert.ToDouble(d.Fees);
objSchoolProgram.Title = d.Title;
objSchoolProgram.IsPrimary = Convert.ToBoolean(d.IsPrimary);
//if (d.FeesPeriodId != null)
//{
// objSchoolProgram.FeesPeriodId = d.FeesPeriodId;
//}
//if (d.FeesPeriodName != null)
//{
// objSchoolProgram.FeesPeriodName = d.FeesPeriodName;
//}
if (d.CreatedById != null)
{
objSchoolProgram.CreatedById = d.CreatedById;
}
if (d.CreatedDateTime != null)
{
objSchoolProgram.CreatedDateTime = d.CreatedDateTime;
}
if (d.LastModifiedById != null)
{
objSchoolProgram.LastModifiedById = d.LastModifiedById;
}
if (d.LastModifiedDatetime != null)
{
objSchoolProgram.LastModifiedDatetime = d.LastModifiedDatetime;
}
lstSchoolProgram.Add(objSchoolProgram);
}
#region Old Code
//if (conn.State == System.Data.ConnectionState.Closed)
//{
// conn.Open();
//}
//SqlCommand cmd = new SqlCommand();
//cmd.CommandText = "spGetSchoolProgram";
//cmd.CommandType = System.Data.CommandType.StoredProcedure;
//cmd.Connection = conn;
//cmd.Parameters.Add(new SqlParameter("@SchoolId", SqlDbType.UniqueIdentifier)).Value = SchoolId;
//cmd.Parameters.Add(new SqlParameter("@SchoolYearId", SqlDbType.UniqueIdentifier)).Value = SchoolYearId;
//SqlDataReader dr = cmd.ExecuteReader();
//while (dr.Read())
//{
// objSchoolProgram = new DayCarePL.SchoolProgramProperties();
// objSchoolProgram.Id = new Guid(dr["Id"].ToString());
// objSchoolProgram.SchoolYearId = new Guid(dr["SchoolYearId"].ToString());
// objSchoolProgram.Active = Convert.ToBoolean(dr["Active"].ToString());
// objSchoolProgram.Fees = Convert.ToDouble(dr["Fees"].ToString());
// objSchoolProgram.Title = dr["Title"].ToString();
// objSchoolProgram.IsPrimary = Convert.ToBoolean(dr["IsPrimary"].ToString());
// if (dr["FeesPeriodId"] != DBNull.Value)
// {
// objSchoolProgram.FeesPeriodId = new Guid(dr["FeesPeriodId"].ToString());
// }
// if (dr["FeesPeriodName"] != DBNull.Value)
// {
// objSchoolProgram.FeesPeriodName = dr["FeesPeriodName"].ToString();
// }
// if (dr["CreatedById"] != DBNull.Value)
// {
// objSchoolProgram.CreatedById = new Guid(dr["CreatedById"].ToString());
// }
// if (dr["CreatedDateTime"] != DBNull.Value)
// {
// objSchoolProgram.CreatedDateTime = Convert.ToDateTime(dr["CreatedDateTime"].ToString());
// }
// if (dr["LastModifiedById"] != DBNull.Value)
// {
// objSchoolProgram.LastModifiedById = new Guid(dr["LastModifiedById"].ToString());
// }
// if (dr["LastModifiedDatetime"] != DBNull.Value)
// {
// objSchoolProgram.LastModifiedDatetime = Convert.ToDateTime(dr["LastModifiedDatetime"].ToString());
// }
// lstSchoolProgram.Add(objSchoolProgram);
//}
#endregion
return(lstSchoolProgram);
}
catch (Exception ex)
{
DayCarePL.Logger.Write(DayCarePL.LogType.EXCEPTION, DayCarePL.ModuleToLog.clSchoolProgram, "LoadSchoolProgram", ex.Message.ToString(), DayCarePL.Common.GUID_DEFAULT);
return(null);
}
}
public bool SubmitRecord(object source, Telerik.Web.UI.GridCommandEventArgs e)
{
DayCarePL.Logger.Write(DayCarePL.LogType.INFO, DayCarePL.ModuleToLog.ClassRoom, "SubmitRecord", "Submit record method called", DayCarePL.Common.GUID_DEFAULT);
bool result = false;
Guid Id;
try
{
DayCarePL.Logger.Write(DayCarePL.LogType.DEBUG, DayCarePL.ModuleToLog.ClassRoom, "SubmitRecord", " Debug Submit record method called of ClassRoom", DayCarePL.Common.GUID_DEFAULT);
DayCareBAL.SchoolProgramService proxySchoolProgram = new DayCareBAL.SchoolProgramService();
DayCarePL.SchoolProgramProperties objSchoolProgram = new DayCarePL.SchoolProgramProperties();
GridDataItem item = (GridDataItem)e.Item;
var InsertItem = e.Item as Telerik.Web.UI.GridEditableItem;
Telerik.Web.UI.GridEditManager editMan = InsertItem.EditManager;
if (InsertItem != null)
{
foreach (GridColumn column in e.Item.OwnerTableView.RenderColumns)
{
if (column is GridEditableColumn)
{
IGridEditableColumn editTableColumn = (column as IGridEditableColumn);
if (editTableColumn.IsEditable)
{
IGridColumnEditor editor = editMan.GetColumnEditor(editTableColumn);
switch (column.UniqueName)
{
case "Title":
{
objSchoolProgram.Title = (e.Item.FindControl("txtTitle") as TextBox).Text;
break;
}
//case "Fees":
// {
// objSchoolProgram.Fees = Convert.ToDouble((e.Item.FindControl("txtFees") as TextBox).Text);
// break;
// }
//case "FeesPeriodName":
// {
// objSchoolProgram.FeesPeriodId = new Guid((e.Item.FindControl("ddlFeesPeriodName") as DropDownList).SelectedValue);
// break;
// }
case "Comments":
{
objSchoolProgram.Comments = (e.Item.FindControl("txtComments") as TextBox).Text;
break;
}
case "Active":
{
objSchoolProgram.Active = (editor as GridCheckBoxColumnEditor).Value;
break;
}
case "IsPrimary":
{
objSchoolProgram.IsPrimary = (editor as GridCheckBoxColumnEditor).Value;
break;
}
}
}
}
}
if (Session["CurrentSchoolYearId"] != null)
{
objSchoolProgram.SchoolYearId = new Guid(Session["CurrentSchoolYearId"].ToString());
}
if (e.CommandName != "PerformInsert")
{
if (Session["StaffId"] != null)
{
objSchoolProgram.LastModifiedById = new Guid(Session["StaffId"].ToString());
}
objSchoolProgram.Id = new Guid(e.Item.OwnerTableView.DataKeyValues[e.Item.ItemIndex]["Id"].ToString());
}
else
{
if (Session["StaffId"] != null)
{
objSchoolProgram.CreatedById = new Guid(Session["StaffId"].ToString());
}
}
if (!lblName.Text.ToLower().Equals(objSchoolProgram.Title.ToLower()))
{
Guid SchoolId = new Guid();
if (Session["SchoolId"] != null)
{
SchoolId = new Guid(Session["SchoolId"].ToString());
}
if (proxySchoolProgram.CheckDuplicateSchoolProgramName(objSchoolProgram.Title, SchoolId))
{
MasterAjaxManager = this.Page.Master.FindControl("RadAjaxManager1") as Telerik.Web.UI.RadAjaxManager;
MasterAjaxManager.ResponseScripts.Add(string.Format("ShowMessage('{0}','{1}')", "Title already exists", "false"));
return(false);
}
}
lblName.Text = "";
//result = proxySchoolProgram.Save(objSchoolProgram);
Id = proxySchoolProgram.Save(objSchoolProgram);
if (!Id.ToString().Equals(DayCarePL.Common.GUID_DEFAULT))
{
MasterAjaxManager = this.Page.Master.FindControl("RadAjaxManager1") as Telerik.Web.UI.RadAjaxManager;
MasterAjaxManager.ResponseScripts.Add(string.Format("ShowMessage('{0}','{1}')", "Saved Successfully", "false"));
}
}
}
catch (Exception ex)
{
DayCarePL.Logger.Write(DayCarePL.LogType.EXCEPTION, DayCarePL.ModuleToLog.HoursOfOperation, "SubmitRecord", ex.Message.ToString(), DayCarePL.Common.GUID_DEFAULT);
result = false;
}
return(result);
}
public Guid Save(DayCarePL.SchoolProgramProperties objSchoolProgram)
{
//return DayCareDAL.clSchoolProgram.Save(objSchoolProgram);
return(DayCareDAL.clSchoolProgram.Save(objSchoolProgram));
}
