protected void Page_Load(object sender, EventArgs e)
{
if (Request.Form["AjaxMethod"] == "SaveOffDetails")
{
Sessions objSess = new Sessions();
string UserID = objSess.GetUserID();
string OpResult = CustEnum.Generic.Error_SessionExpired.ToString();
if (UserID != null)
{
string OfficeID = Request.Form["OID"].Trim().SafeSqlLiteral(1);
string Name = Request.Form["Name"].Trim().SafeSqlLiteral(1);
string Addr = Request.Form["Addr"].Trim().SafeSqlLiteral(1);
string Ph1 = Request.Form["Ph1"].Trim().SafeSqlLiteral(1);
string Ph2 = Request.Form["Ph2"].Trim().SafeSqlLiteral(1);
string Fax = Request.Form["Fax"].Trim().SafeSqlLiteral(1);
string Web = Request.Form["Web"].Trim().SafeSqlLiteral(1);
string Email = Request.Form["Email"].Trim().SafeSqlLiteral(1);
OpResult = CustEnum.Generic.Error_Default.ToString();
Office obj = new Office();
if (obj.UpdateOfficeDetails(OfficeID, UserID, DbSettings.Generic.Active, Name, Addr, Ph1, Ph2, Fax, Web, Email))
{
OpResult = CustEnum.Generic.Success_.ToString();
}
}
Response.Write(OpResult);
Response.End();
} //save ho
if (Request.Form["AjaxMethod"] == "FetchParent")
{
string OfficeTypeID = Request.Form["OTID"];
string OpResult = CustEnum.Generic.Error_Default.ToString();
Users objUsr = new Users();
UserKeyDetails objUsrDet = objUsr.GetUserKeyDetails();
string UserID = objUsrDet.UserID;
string UserStatusID = objUsrDet.StatusID;
string UserRoleID = objUsrDet.RoleID;
string UserOfficeID = objUsrDet.OfficeID;
string UserOfficeTypeID = objUsrDet.OfficeTypeID;
if (UserID != null && UserStatusID == DbSettings.UserStatus.Active)
{
if (int.Parse(UserOfficeTypeID) < int.Parse(OfficeTypeID))
{
Office objOff = new Office();
DataSet ds = objOff.GetImmediateParentOfficesForOfficeType(UserOfficeID, OfficeTypeID);
if (!DataUtils.IsDataSetNull(ds, 0))
{
StringBuilder sbrMenu = new StringBuilder();
sbrMenu.Append("<select id='drpParent'>");
foreach (DataRow dr in ds.Tables[0].Rows)
{
string ParentOfficeID = dr["ParentOfficeID"].ToString();
string ParentOfficeName = dr["OfficeName"].ToString();
sbrMenu.Append("<option id=drpOptParent_" + ParentOfficeID + ">" + ParentOfficeName + "</option>");
}
sbrMenu.Append("</select>");
OpResult = sbrMenu.ToString();
}
}
}
else
{
OpResult = CustEnum.Generic.Error_SessionExpired.ToString();
}
Response.Write(OpResult);
Response.End();
} //fetch parent
if (Request.Form["AjaxMethod"] == "AddOffice")
{
string ParentOfficeID = Request.Form["PID"].Trim().SafeSqlLiteral(1);
string OfficeTypeID = Request.Form["OTID"].Trim().SafeSqlLiteral(1);
string Name = Request.Form["Name"].Trim().SafeSqlLiteral(1);
string Addr = Request.Form["Addr"].Trim().SafeSqlLiteral(1);
string Ph1 = Request.Form["Ph1"].Trim().SafeSqlLiteral(1);
string Ph2 = Request.Form["Ph2"].Trim().SafeSqlLiteral(1);
string Fax = Request.Form["Fax"].Trim().SafeSqlLiteral(1);
string Email = Request.Form["Email"].Trim().SafeSqlLiteral(1);
string OpResult = CustEnum.Generic.Error_Default.ToString();
Users objUsr = new Users();
UserKeyDetails objUsrDet = objUsr.GetUserKeyDetails();
string UserID = objUsrDet.UserID;
string UserStatusID = objUsrDet.StatusID;
//string UserRoleID = objUsrDet.RoleID;
string UserOfficeID = objUsrDet.OfficeID;
if (UserID != null && UserStatusID == DbSettings.UserStatus.Active)
{
Office objOff = new Office();
bool OfficeCreated = objOff.AddNewOffice(UserID, ParentOfficeID, OfficeTypeID, Name, Addr, Ph1, Ph2, Fax, Email);
if (OfficeCreated)
{
OpResult = CustEnum.Generic.Success_.ToString();
}
}
else
{
OpResult = CustEnum.Generic.Error_SessionExpired.ToString();
}
Response.Write(OpResult);
Response.End();
} // add
if (Request.Form["AjaxMethod"] == "DeleteOffice")
{
string OfficeID = Request.Form["OID"];
string OpResult = CustEnum.DeleteOffice.Error.ToString();
Users objUsr = new Users();
UserKeyDetails objUsrDet = objUsr.GetUserKeyDetails();
string UserID = objUsrDet.UserID;
string UserStatusID = objUsrDet.StatusID;
//string UserRoleID = objUsrDet.RoleID;
string UserOfficeID = objUsrDet.OfficeID;
if (UserID != null && UserStatusID == DbSettings.UserStatus.Active)
{
Office objOff = new Office();
string SubOffCount = objOff.GetSubOfficeCountForOffice(OfficeID);
if (SubOffCount != CustEnum.Generic.Error_Default.ToString())
{
if (int.Parse(SubOffCount) == 0)
{
//delete office
if (objOff.DeleteOffice(OfficeID, UserID) == CustEnum.Generic.Success_.ToString())
{
OpResult = CustEnum.DeleteOffice.Success.ToString();
}
}
else if (int.Parse(SubOffCount) > 0)
{
OpResult = CustEnum.DeleteOffice.HasSubOffice.ToString();
}
}
}
else
{
OpResult = CustEnum.Generic.Error_SessionExpired.ToString();
}
Response.Write(OpResult);
Response.End();
}
if (Request.Form["AjaxMethod"] == "AddCenter")
{
string VillageID = Request.Form["VillageID"];
string MeetingLocation = Request.Form["Location"];
string MeetingTime = Request.Form["Time"];
string FEID = Request.Form["FE"];
string OpResult = CustEnum.Generic.Error_Default.ToString();
Users objUsr = new Users();
UserKeyDetails objUsrDet = objUsr.GetUserKeyDetails();
string UserID = objUsrDet.UserID;
string UserStatusID = objUsrDet.StatusID;
if (UserID != null && UserStatusID == DbSettings.UserStatus.Active)
{
Office objOff = new Office();
int CenterID = 0;
int.TryParse(objOff.AddNewCenter(VillageID, MeetingLocation, FEID, UserID, MeetingTime), out CenterID);
if (CenterID > 0)
{
OpResult = CustEnum.Generic.Success_.ToString() + CenterID.ToString();
}
}
Response.Write(OpResult);
Response.End();
}
if (Request.Form["AjaxMethod"] == "EditCenter")
{
string CenterID = Request.Form["CenterID"];
string MeetingLocation = Request.Form["Location"];
string MeetingTime = Request.Form["Time"];
string FEID = Request.Form["FE"];
string OpResult = CustEnum.Generic.Error_Default.ToString();
Users objUsr = new Users();
UserKeyDetails objUsrDet = objUsr.GetUserKeyDetails();
string UserID = objUsrDet.UserID;
string UserStatusID = objUsrDet.StatusID;
if (UserID != null && UserStatusID == DbSettings.UserStatus.Active)
{
Office objOff = new Office();
if (objOff.UpdateCenter(CenterID, MeetingLocation, MeetingTime, FEID, UserID))
{
OpResult = CustEnum.Generic.Success_.ToString();
}
}
Response.Write(OpResult);
Response.End();
} //edit center
if (Request.Form["AjaxMethod"] == "DeleteCenter")
{
string CenterID = Request.Form["CID"];
string OpResult = CustEnum.DeleteOffice.Error.ToString();
Users objUsr = new Users();
UserKeyDetails objUsrDet = objUsr.GetUserKeyDetails();
string UserID = objUsrDet.UserID;
string UserStatusID = objUsrDet.StatusID;
//string UserRoleID = objUsrDet.RoleID;
string UserOfficeID = objUsrDet.OfficeID;
if (UserID != null && UserStatusID == DbSettings.UserStatus.Active)
{
Office objOff = new Office();
string SubOffCount = objOff.GetGroupCountForCenterID(CenterID);
if (SubOffCount != CustEnum.Generic.Error_Default.ToString())
{
if (SubOffCount == "0") // string comp is guaranteed to be safe check. else have to handle null/err cases
{
//delete office
if (objOff.DeleteCenter(CenterID, UserID) == CustEnum.Generic.Success_.ToString())
{
OpResult = CustEnum.DeleteOffice.Success.ToString();
}
}
else if (int.Parse(SubOffCount) > 0)
{
OpResult = CustEnum.DeleteOffice.HasSubOffice.ToString();
}
}
}
else
{
OpResult = CustEnum.Generic.Error_SessionExpired.ToString();
}
Response.Write(OpResult);
Response.End();
} //DEL CENT
if (Request.Form["AjaxMethod"] == "DeleteGroup")
{
string GroupID = Request.Form["GID"];
string OpResult = CustEnum.DeleteOffice.Error.ToString();
Users objUsr = new Users();
UserKeyDetails objUsrDet = objUsr.GetUserKeyDetails();
string UserID = objUsrDet.UserID;
string UserStatusID = objUsrDet.StatusID;
//string UserRoleID = objUsrDet.RoleID;
string UserOfficeID = objUsrDet.OfficeID;
if (UserID != null && UserStatusID == DbSettings.UserStatus.Active)
{
Office objOff = new Office();
string SubOffCount = objOff.DeleteGroup(GroupID, UserID, DbSettings.LoanStatus.GroupDeleted);
if (SubOffCount != CustEnum.Generic.Error_Default.ToString())
{
if (SubOffCount == "1") // string comp is guaranteed to be safe check. else have to handle null/err cases
{
OpResult = CustEnum.DeleteOffice.Success.ToString();
}
else if (SubOffCount == "-1")
{
OpResult = CustEnum.DeleteOffice.HasSubOffice.ToString();
}
}
}
else
{
OpResult = CustEnum.Generic.Error_SessionExpired.ToString();
}
Response.Write(OpResult);
Response.End();
}
}
