protected void chkStaff_CheckedChanged(object sender, EventArgs e)
{
try
{
DayCareBAL.ProgStaffService proxyProgStaff = new DayCareBAL.ProgStaffService();
DayCarePL.ProgStaffProperties objProgStaff = new DayCarePL.ProgStaffProperties();
List <DayCarePL.ProgStaffProperties> lstProgStaff = new List <DayCarePL.ProgStaffProperties>();
CheckBox chkStaff = sender as CheckBox;
GridDataItem item = chkStaff.NamingContainer as GridDataItem;
if (ViewState["SchoolProgramId"] != null)
{
if (item.ItemIndex > -1)
{
objProgStaff.Id = new Guid(item.GetDataKeyValue("Id").ToString());
objProgStaff.StaffId = new Guid((item.FindControl("lblStaffId") as Label).Text);
objProgStaff.SchoolProgramId = new Guid(ViewState["SchoolProgramId"].ToString());
objProgStaff.Active = chkStaff.Checked;
if (Session["StaffId"] != null)
{
objProgStaff.CreatedById = new Guid(Session["StaffId"].ToString());
objProgStaff.LastModifiedById = new Guid(Session["StaffId"].ToString());
}
}
if (proxyProgStaff.Save(objProgStaff))
{
MasterAjaxManager = this.Page.FindControl("RadAjaxManager1") as Telerik.Web.UI.RadAjaxManager;
MasterAjaxManager.ResponseScripts.Add(string.Format("ShowMessage('{0}','{1}')", "Saved Successfully", "false"));
rgProgramStaff.Rebind();
}
else
{
MasterAjaxManager = this.Page.FindControl("RadAjaxManager1") as Telerik.Web.UI.RadAjaxManager;
MasterAjaxManager.ResponseScripts.Add(string.Format("ShowMessage('{0}','{1}')", "Internal Error!", "false"));
return;
}
}
}
catch (Exception ex)
{
}
}
protected void rgProgramStaff_ItemDataBound(object sender, Telerik.Web.UI.GridItemEventArgs e)
{
if (e.Item.ItemType == GridItemType.AlternatingItem || e.Item.ItemType == GridItemType.Item)
{
CheckBox chkStaff = e.Item.FindControl("chkStaff") as CheckBox;
CheckBox chkActive = e.Item.FindControl("chkActive") as CheckBox;
DayCarePL.ProgStaffProperties objProgStaff = e.Item.DataItem as DayCarePL.ProgStaffProperties;
if (objProgStaff != null)
{
if (objProgStaff.Active)
{
chkStaff.Checked = true;
}
if (objProgStaff.Active == true)
{
chkActive.Checked = true;
}
}
}
}
protected void btnSave_Click(object sender, EventArgs e)
{
try
{
DayCareBAL.ProgStaffService proxyProgStaff = new DayCareBAL.ProgStaffService();
DayCarePL.ProgStaffProperties objProgStaff = new DayCarePL.ProgStaffProperties();
List <DayCarePL.ProgStaffProperties> lstProgStaff = new List <DayCarePL.ProgStaffProperties>();
if (ViewState["SchoolProgramId"] != null)
{
foreach (GridItem itm in rgProgramStaff.Items)
{
GridDataItem items = itm as GridDataItem;
CheckBox chkStaff = items["SelectCheckStaff"].FindControl("chkStaff") as CheckBox;
//CheckBox chkActive = items["Active"].FindControl("chkActive") as CheckBox;
Label lblStaffId = items["StaffId"].FindControl("lblStaffId") as Label;
if (chkStaff.Checked)
{
objProgStaff = new DayCarePL.ProgStaffProperties();
objProgStaff.StaffId = new Guid(lblStaffId.Text);
objProgStaff.Active = true;// chkActive.Checked;
if (Session["StaffId"] != null)
{
objProgStaff.CreatedById = new Guid(Session["StaffId"].ToString());
objProgStaff.LastModifiedById = new Guid(Session["StaffId"].ToString());
}
objProgStaff.SchoolProgramId = new Guid(ViewState["SchoolProgramId"].ToString());
lstProgStaff.Add(objProgStaff);
}
}
}
}
catch (Exception ex)
{
DayCarePL.Logger.Write(DayCarePL.LogType.EXCEPTION, DayCarePL.ModuleToLog.ProgStaff, "btnSave_Click", ex.Message.ToString(), DayCarePL.Common.GUID_DEFAULT);
}
}
public static List <DayCarePL.ProgStaffProperties> GetStaffFromProgStaffBySchoolProgram(Guid SchoolProgramId)
{
DayCarePL.Logger.Write(DayCarePL.LogType.INFO, DayCarePL.ModuleToLog.clProgStaff, "GetStaffFromProgStaffBySchoolProgram", "Execute GetStaffFromProgStaffBySchoolProgram Method", DayCarePL.Common.GUID_DEFAULT);
SqlConnection conn = new SqlConnection(System.Web.Configuration.WebConfigurationManager.ConnectionStrings["daycareConnectionString"].ToString());
try
{
DayCarePL.Logger.Write(DayCarePL.LogType.DEBUG, DayCarePL.ModuleToLog.clProgStaff, "GetStaffFromProgStaffBySchoolProgram", "Debug GetStaffFromProgStaffBySchoolProgram Method", DayCarePL.Common.GUID_DEFAULT);
List <DayCarePL.ProgStaffProperties> lstSchoolProgram = new List <DayCarePL.ProgStaffProperties>();
DayCarePL.ProgStaffProperties objSchoolProgram;
if (conn.State == System.Data.ConnectionState.Closed)
{
conn.Open();
}
SqlCommand cmd = new SqlCommand();
cmd.CommandText = "spGetStaffFromProgStaffBySchoolProgram";
cmd.CommandType = System.Data.CommandType.StoredProcedure;
cmd.Connection = conn;
cmd.Parameters.Add(new SqlParameter("@SchoolProgramId", SqlDbType.UniqueIdentifier)).Value = SchoolProgramId;
SqlDataReader dr = cmd.ExecuteReader();
while (dr.Read())
{
objSchoolProgram = new DayCarePL.ProgStaffProperties();
objSchoolProgram.Id = new Guid(dr["Id"].ToString());
objSchoolProgram.StaffFullName = dr["FullName"].ToString();
lstSchoolProgram.Add(objSchoolProgram);
}
return(lstSchoolProgram);
}
catch (Exception ex)
{
DayCarePL.Logger.Write(DayCarePL.LogType.EXCEPTION, DayCarePL.ModuleToLog.clProgStaff, "GetStaffFromProgStaffBySchoolProgram", ex.Message.ToString(), DayCarePL.Common.GUID_DEFAULT);
return(null);
}
}
public bool Save(DayCarePL.ProgStaffProperties objProgStaff)
{
return(DayCareDAL.clProgStaff.Save(objProgStaff));
}
public static List <DayCarePL.ProgStaffProperties> LoadStaffBySchoolProgram(Guid SchoolId, Guid SchoolYearId, Guid SchoolProgramId, bool IsPrimary)
{
DayCarePL.Logger.Write(DayCarePL.LogType.INFO, DayCarePL.ModuleToLog.clProgStaff, "LoadStaffBySchoolProgram", "Execute LoadStaffBySchoolProgram Method", DayCarePL.Common.GUID_DEFAULT);
SqlConnection conn = new SqlConnection(System.Web.Configuration.WebConfigurationManager.ConnectionStrings["daycareConnectionString"].ToString());
try
{
DayCarePL.Logger.Write(DayCarePL.LogType.DEBUG, DayCarePL.ModuleToLog.clProgStaff, "LoadStaffBySchoolProgram", "Debug LoadStaffBySchoolProgram Method", DayCarePL.Common.GUID_DEFAULT);
List <DayCarePL.ProgStaffProperties> lstProgStaff = new List <DayCarePL.ProgStaffProperties>();
DayCarePL.ProgStaffProperties objProgStaff;
if (conn.State == System.Data.ConnectionState.Closed)
{
conn.Open();
}
SqlCommand cmd = new SqlCommand();
cmd.CommandText = "spGetStaffBySchoolProgram";
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;
cmd.Parameters.Add(new SqlParameter("@SchoolProgramId", SqlDbType.UniqueIdentifier)).Value = SchoolProgramId;
//cmd.Parameters.Add(new SqlParameter("@IsPrimary", SqlDbType.Bit)).Value = IsPrimary;
SqlDataReader dr = cmd.ExecuteReader();
while (dr.Read())
{
objProgStaff = new DayCarePL.ProgStaffProperties();
objProgStaff.Id = new Guid(dr["ProgStaff_Id"].ToString());
objProgStaff.ProgStaff_StaffId = new Guid(dr["ProgStaff_StaffId"].ToString());
objProgStaff.StaffId = new Guid(dr["StaffId"].ToString());
objProgStaff.StaffFullName = dr["FullName"].ToString();
objProgStaff.StaffUserName = dr["UserName"].ToString();
objProgStaff.StaffEmail = dr["Email"].ToString();
objProgStaff.StaffCity = dr["City"].ToString();
objProgStaff.StaffMainPhone = dr["MainPhone"].ToString();
if (dr["ProgStaff_CreatedById"] != DBNull.Value)
{
objProgStaff.CreatedById = new Guid(dr["ProgStaff_CreatedById"].ToString());
}
if (dr["ProgStaff_CreatedDateTime"] != DBNull.Value)
{
objProgStaff.CreatedDateTime = Convert.ToDateTime(dr["ProgStaff_CreatedDateTime"].ToString());
}
if (dr["ProgStaff_LastModifiedById"] != DBNull.Value)
{
objProgStaff.LastModifiedById = new Guid(dr["ProgStaff_LastModifiedById"].ToString());
}
if (dr["ProgStaff_LastModifiedDatetime"] != DBNull.Value)
{
objProgStaff.LastModifiedDatetime = Convert.ToDateTime(dr["ProgStaff_LastModifiedDatetime"].ToString());
}
objProgStaff.Active = Convert.ToBoolean(dr["Active"].ToString());
if (dr["IsPrimary"] != DBNull.Value)
{
objProgStaff.IsPrimary = Convert.ToBoolean(dr["IsPrimary"].ToString());
}
objProgStaff.GroupTitle = dr["GroupTitle"].ToString();
lstProgStaff.Add(objProgStaff);
}
return(lstProgStaff);
}
catch (Exception ex)
{
DayCarePL.Logger.Write(DayCarePL.LogType.EXCEPTION, DayCarePL.ModuleToLog.clProgStaff, "LoadStaffBySchoolProgram", ex.Message.ToString(), DayCarePL.Common.GUID_DEFAULT);
return(null);
}
finally
{
if (conn.State == System.Data.ConnectionState.Open)
{
conn.Close();
}
}
}
public static bool Save(DayCarePL.ProgStaffProperties objProgStaff)
{
DayCarePL.Logger.Write(DayCarePL.LogType.INFO, DayCarePL.ModuleToLog.clProgStaff, "Save", "Execute Save Method", DayCarePL.Common.GUID_DEFAULT);
SqlConnection conn = clConnection.CreateConnection();// new SqlConnection(System.Web.Configuration.WebConfigurationManager.ConnectionStrings["daycareConnectionString"].ToString());
SqlTransaction sqlTran = null;
try
{
DayCarePL.Logger.Write(DayCarePL.LogType.DEBUG, DayCarePL.ModuleToLog.clProgStaff, "Save", "Debug Save Method", DayCarePL.Common.GUID_DEFAULT);
clConnection.OpenConnection(conn);
SqlCommand cmd;
bool status = true;
sqlTran = conn.BeginTransaction();
if (!objProgStaff.Id.ToString().Equals(DayCarePL.Common.GUID_DEFAULT))
{
cmd = clConnection.CreateCommand("spUpdateProgClassRoomByStaffId", conn);
cmd.Transaction = sqlTran;
cmd.Parameters.Add(clConnection.GetInputParameter("@SchoolProgramId", objProgStaff.SchoolProgramId));
cmd.Parameters.Add(clConnection.GetInputParameter("@ProgStaffId", objProgStaff.Id));
cmd.Parameters.Add(clConnection.GetInputParameter("@Active", objProgStaff.Active));
cmd.Parameters.Add(clConnection.GetInputParameter("@LastModifiedDatetime", DateTime.Now));
cmd.Parameters.Add(clConnection.GetInputParameter("@LastModifiedById", objProgStaff.LastModifiedById));
cmd.Parameters.Add(clConnection.GetOutputParameter("@status", SqlDbType.Bit));
cmd.ExecuteNonQuery();
status = Convert.ToBoolean(cmd.Parameters["@status"].Value);
}
if (status)
{
if (objProgStaff.Id.ToString().Equals(DayCarePL.Common.GUID_DEFAULT))
{
cmd = clConnection.CreateCommand("spAddProgStaff", conn);
cmd.Parameters.Add(clConnection.GetInputParameter("@CreatedById", objProgStaff.CreatedById));
cmd.Parameters.Add(clConnection.GetInputParameter("@CreatedDateTime", DateTime.Now));
}
else
{
cmd = clConnection.CreateCommand("spUpdateProgStaff", conn);
}
cmd.Transaction = sqlTran;
if (!objProgStaff.Id.ToString().Equals(DayCarePL.Common.GUID_DEFAULT))
{
cmd.Parameters.Add(clConnection.GetInputParameter("@Id", objProgStaff.Id));
}
cmd.Parameters.Add(clConnection.GetInputParameter("@SchoolProgramId", objProgStaff.SchoolProgramId));
cmd.Parameters.Add(clConnection.GetInputParameter("@StaffId", objProgStaff.StaffId));
cmd.Parameters.Add(clConnection.GetInputParameter("@Active", objProgStaff.Active));
cmd.Parameters.Add(clConnection.GetInputParameter("@LastModifiedDatetime", DateTime.Now));
cmd.Parameters.Add(clConnection.GetInputParameter("@LastModifiedById", objProgStaff.LastModifiedById));
cmd.Parameters.Add(clConnection.GetOutputParameter("@status", SqlDbType.Bit));
cmd.ExecuteNonQuery();
}
else
{
sqlTran.Rollback();
return(false);
}
sqlTran.Commit();
return(true);
}
catch (Exception ex)
{
DayCarePL.Logger.Write(DayCarePL.LogType.EXCEPTION, DayCarePL.ModuleToLog.clProgStaff, "Save", ex.Message.ToString(), DayCarePL.Common.GUID_DEFAULT);
if (sqlTran != null)
{
sqlTran.Rollback();
}
return(false);
}
finally
{
clConnection.CloseConnection(conn);
}
}
public bool SubmitRecord(object sender, GridCommandEventArgs e)
{
DayCarePL.Logger.Write(DayCarePL.LogType.INFO, DayCarePL.ModuleToLog.SchoolYear, "SubmitRecord", "Submit record method called", DayCarePL.Common.GUID_DEFAULT);
bool result = false;
try
{
DayCarePL.Logger.Write(DayCarePL.LogType.DEBUG, DayCarePL.ModuleToLog.SchoolYear, "SubmitRecord", "Debug Submit Record Of SchoolYear", DayCarePL.Common.GUID_DEFAULT);
DayCareBAL.ProgStaffService proxyProgStaff = new DayCareBAL.ProgStaffService();
DayCarePL.ProgStaffProperties objProgStaff = new DayCarePL.ProgStaffProperties();
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 "Name":
{
objProgStaff.StaffId = new Guid((e.Item.FindControl("lblStaffId") as Label).Text);
break;
}
case "Active":
{
objProgStaff.Active = (e.Item.FindControl("chkActive") as CheckBox).Checked;
break;
}
}
}
}
}
if (e.CommandName != "PerformInsert")
{
objProgStaff.Id = new Guid(e.Item.OwnerTableView.DataKeyValues[e.Item.ItemIndex]["Id"].ToString());
if (Session["StaffId"] != null)
{
objProgStaff.LastModifiedById = new Guid(Session["StaffId"].ToString());
}
}
else
{
}
hdnName.Value = "";
//result = proxyProgStaff.Save(objProgStaff);
//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.Relationship, "SubmitRecord", ex.Message.ToString(), DayCarePL.Common.GUID_DEFAULT);
result = false;
}
return(result);
}
