public static string LoadClass(int intSchoolMID)
{
try
{
#region Bind Class
DataTable dtClass = new DataTable();
ClassBL objClassBL = new ClassBL();
ClassBO objClassBO = new ClassBO();
ApplicationResult objResultSection = new ApplicationResult();
objResultSection = objClassBL.Class_SelectAll_ForDropDownNotSectionWise(intSchoolMID);
if (objResultSection != null)
{
dtClass = objResultSection.resultDT;
if (dtClass.Rows.Count > 0)
{
}
}
string res = "";
res = DataSetToJSON(dtClass);
return(res);
#endregion
}
catch (Exception ex)
{
throw ex;
}
}
private void btnUpdate_Click(object sender, EventArgs e)
{
objLogics = new ClassBL();
objLogics.UpdateEmployee(txtEmail.Text, txtName.Text);
dataGridView1.DataSource = objLogics.LoadEmployee();
dataGridView1.DataMember = "Table_Employee";
}
public void BindClass()
{
try
{
ApplicationResult objResult = new ApplicationResult();
ClassBL objClassBl = new ClassBL();
Controls objControl = new Controls();
objResult = objClassBl.Class_SelectAll(Convert.ToInt32(Session[ApplicationSession.SCHOOLID]));
if (objResult != null)
{
objControl.BindDropDown_ListBox(objResult.resultDT, ddlClass, "ClassName", "ClassMID");
//PanelVisibility(1);
ddlClass.Items.Insert(0, new ListItem("--Select--", ""));
}
else
{
//PanelVisibility(2);
}
}
catch (Exception ex)
{
logger.Error("Error", ex);
ClientScript.RegisterStartupScript(typeof(Page), "MessagePopUp", "<script>alert('Oops! There is some technical issue. Please Contact to your administrator.');</script>");
}
}
private void dataGridView1_UserDeletingRow(object sender, DataGridViewRowCancelEventArgs e)
{
objLogics = new ClassBL();
string email = dataGridView1.SelectedRows[0].Cells["email"].Value.ToString();
objLogics.DeleteEmployee(email);
}
public static string LoadClass(int intEmployeeMID)
{
try
{
#region Bind Class
ClassBL objClassBL = new ClassBL();
ClassBO objClassBO = new ClassBO();
ApplicationResult objResultSection = new ApplicationResult();
objResultSection = objClassBL.Class_SelectAll_EmployeeWise(intEmployeeMID);
if (objResultSection != null)
{
if (objResultSection.resultDT.Rows.Count > 0)
{
}
}
string res = "";
res = DataSetToJSON(objResultSection.resultDT);
return(res);
#endregion
}
catch (Exception ex)
{
throw ex;
}
}
private void GridDataBind()
{
try
{
ClassBL objClasstBl = new ClassBL();
ApplicationResult objResult = new ApplicationResult();
objResult = objClasstBl.Class_SelectAll_WithDivision(Convert.ToInt32(Session[ApplicationSession.SCHOOLID]));
if (objResult != null)
{
if (objResult.resultDT.Rows.Count > 0)
{
gvClass.DataSource = objResult.resultDT;
gvClass.DataBind();
PanelGrid_VisibilityMode(1);
}
else
{
PanelGrid_VisibilityMode(2);
}
}
}
catch (Exception ex)
{
logger.Error("Error", ex);
ClientScript.RegisterStartupScript(typeof(Page), "MessagePopUp", "<script>alert('Oops! There is some technical issue. Please Contact to your administrator.');</script>");
}
}
public bool ValidateName()
{
try
{
ClassBL objClasstBl = new ClassBL();
ApplicationResult objResults = new ApplicationResult();
DataTable dtClass = new DataTable();
if (ViewState["Mode"].ToString() == "Save")
{
objResults = objClasstBl.Class_ValidateName_ClassDivision(txtClassName.Text, Convert.ToInt32(Session[ApplicationSession.SCHOOLID]), -1, txtDivisionName.Text);
}
else
{
objResults = objClasstBl.Class_ValidateName_ClassDivision(txtClassName.Text, Convert.ToInt32(Session[ApplicationSession.SCHOOLID]), Convert.ToInt32(ViewState["ClassMID"].ToString()), txtDivisionName.Text);
}
if (objResults.resultDT.Rows.Count > 0)
{
return(true);
}
return(false);
}
catch (Exception ex)
{
//throw ex;
logger.Error("Error", ex);
ClientScript.RegisterStartupScript(typeof(Page), "MessagePopUp", "<script>alert('Oops! There is some technical issue. Please Contact to your administrator.');</script>");
return(false);
}
}
private void btnSave_Click(object sender, EventArgs e)
{
objLogics = new ClassBL();
if (!(txtEmail.Text == "" && txtName.Text == ""))
{
objLogics.AddNewEmployee(txtEmail.Text, txtName.Text);
}
dataGridView1.DataSource = objLogics.LoadEmployee();
dataGridView1.DataMember = "Table_Employee";
}
protected void BindClass()
{
ApplicationResult objResult = new ApplicationResult();
ClassBL objClassBl = new ClassBL();
Controls objControl = new Controls();
objResult = objClassBl.Class_SelectAll(Convert.ToInt32(Session[ApplicationSession.SCHOOLID]));
if (objResult != null)
{
objControl.BindDropDown_ListBox(objResult.resultDT, ddlClass, "ClassName", "ClassMID");
}
ddlClass.Items.Insert(0, new ListItem("--Select--", ""));
}
private DataTable FetchClass(int intSchoolMID)
{
// DataTable dtClass = new DataTable();
ClassBL objClassBL = new ClassBL();
ClassBO objClassBO = new ClassBO();
ApplicationResult objResults = new ApplicationResult();
objResults = objClassBL.Class_SelectAll(intSchoolMID);
if (objResults.status == ApplicationResult.CommonStatusType.SUCCESS && objResults.resultDT.Rows.Count > 0)
{
}
return(objResults.resultDT);
}
protected void BindClass()
{
ApplicationResult objResult = new ApplicationResult();
Controls objControls = new Controls();
ClassBL objClassBl = new ClassBL();
objResult = objClassBl.Class_SelectAll_ForDropDownNotSectionWise(Convert.ToInt32(Session[ApplicationSession.SCHOOLID]));
if (objResult != null)
{
gvClass.DataSource = objResult.resultDT;
gvClass.DataBind();
}
}
/// <summary>
/// 删除事件--从数据库中删除
/// </summary>
/// <param name="classBM"></param>
/// 创 建 人：HNAS Framework 4.0 项目组
/// 创建日期：2012/3/15 17:21:32
/// 修 改 人：
/// 修改日期：
protected void DelBM(ClassBM classBM)
{
// 从数据库中删除
//CallResult<bool> cr = new CommonBL().Delete(classBM);//直接使用BL基类方法
// 从数据库中删除
CallResult <bool> cr = new ClassBL("dbDemo1").DeleteWithTransation(classBM);//
AlertMsn.PopMsn(cr.Message);
if (!cr.HasError || cr.Result)
{
//删除成功重新绑定数据
this.AspNetPager1.CurrentPageIndex = 1;
BindData(this.AspNetPager1.CurrentPageIndex, AspNetPager1.PageSize);
}
}
public void getClassName()
{
ApplicationResult objResult = new ApplicationResult();
Controls objControls = new Controls();
ClassBL objClassBl = new ClassBL();
// string str = ddlsection.se;
objResult = objClassBl.Class_SelectAll(Convert.ToInt32(Session[ApplicationSession.SCHOOLID]));
if (objResult != null)
{
objControls.BindDropDown_ListBox(objResult.resultDT, ddlclass, "ClassName", "ClassMID");
if (objResult.resultDT.Rows.Count > 0)
{
}
ddlclass.Items.Insert(0, new System.Web.UI.WebControls.ListItem("--Select--", ""));
ddlDivision.Items.Insert(0, new System.Web.UI.WebControls.ListItem("--Select--", ""));
}
}
protected void ddlClass_OnSelectedIndexChanged(object sender, EventArgs e)
{
try
{
if (ddlClass.SelectedValue != "")
{
ApplicationResult objResult = new ApplicationResult();
ClassBL objClassBl = new ClassBL();
objResult = objClassBl.Class_Select(Convert.ToInt32(ddlClass.SelectedValue));
if (objResult != null)
{
if (objResult.resultDT.Rows.Count > 0)
{
hfNoOfPeriod.Value = objResult.resultDT.Rows[0][ClassBO.CLASS_NOOFPERIOD].ToString();
}
}
if (ViewState["DropDownMode"].ToString() == "Load")
{
BindPeriod();
}
else if (ViewState["DropDownMode"].ToString() == "New")
{
BindDays(Convert.ToInt32(ddlClass.SelectedValue), 2);
int intcount = Convert.ToInt32(hfNoOfPeriod.Value);
ClientScript.RegisterStartupScript(typeof(Page), "MessagePopUp",
"<script>BindPeriod(" + intcount + ");</script>");
}
}
else
{
gvPeriod.DataSource = null;
gvPeriod.DataBind();
}
}
catch (Exception ex)
{
logger.Error("Error", ex);
ClientScript.RegisterStartupScript(typeof(Page), "MessagePopUp", "<script>alert('Oops! There is some technical issue. Please Contact to your administrator.');</script>");
}
}
protected void ddlSection_SelectedIndexChanged(object sender, EventArgs e)
{
try
{
ApplicationResult objResult = new ApplicationResult();
Controls objControls = new Controls();
ClassBL objClassBl = new ClassBL();
objResult = objClassBl.Class_SelectAll_SectionWise_ForDropDown(Convert.ToInt32(ddlSection.SelectedValue), Convert.ToInt32(ddlSchoolName.SelectedValue));
if (objResult != null)
{
objControls.BindDropDown_ListBox(objResult.resultDT, ddlClassName, "ClassName", "ClassMID");
if (objResult.resultDT.Rows.Count > 0)
{
}
ddlClassName.Items.Insert(0, new ListItem("--Select--", ""));
}
}
catch (Exception)
{
throw;
}
}
protected void ddlClass_OnSelectedIndexChanged(object sender, EventArgs e)
{
try
{
if (ddlClass.SelectedValue != "")
{
ApplicationResult objResult = new ApplicationResult();
ClassBL objClassBl = new ClassBL();
TimeTableBL objTimeTableBl = new TimeTableBL();
objResult = objTimeTableBl.TimeTable_Validate_Period(Convert.ToInt32(ddlClass.SelectedValue));
if (objResult.resultDT.Rows[0][0].ToString() == "0")
{
objResult = objClassBl.Class_Select(Convert.ToInt32(ddlClass.SelectedValue));
if (objResult != null)
{
if (objResult.resultDT.Rows.Count > 0)
{
hfNoOfPeriod.Value = objResult.resultDT.Rows[0][ClassBO.CLASS_NOOFPERIOD].ToString();
}
}
BindDivision(Convert.ToInt32(ddlClass.SelectedValue));
}
else
{
ddlDivision.Items.Clear();
ddlDivision.Items.Insert(0, new ListItem("--Select--", ""));
ClientScript.RegisterStartupScript(typeof(Page), "MessagePopUp", "<script>alert('First you have to insert data in period.');</script>");
}
}
}
catch (Exception ex)
{
logger.Error("Error", ex);
ClientScript.RegisterStartupScript(typeof(Page), "MessagePopUp", "<script>alert('Oops! There is some technical issue. Please Contact to your administrator.');</script>");
}
}
private void EnterButton_Click(object sender, EventArgs e)
{
u = userNameText.Text;
p = Int32.Parse(PasswordText.Text);
ClassBL bl = new ClassBL();
bool find = bl.Exist(u, p);
if (find)
{
string message = "✔️זוהיתם בהצלחה ";
string title = "Message";
MessageBox.Show(message, title);
TEST t = new TEST(Convert.ToInt32(PasswordText.Text));
t.Show();
}
else
{
MessageBox.Show("הפרטים שגויים!");
}
u = null;
p = 0;
userNameText.Text = "";
PasswordText.Text = "";
}
protected void gvStudent_RowCommand(object sender, GridViewCommandEventArgs e)
{
try
{
Controls objControls = new Controls();
StudentBL objStudentBL = new StudentBL();
ApplicationResult objResults = new ApplicationResult();
if (e.CommandName.ToString() == "Edit1")
{
ViewState["StudentMID"] = Convert.ToInt32(e.CommandArgument.ToString());
divStudentPanel.Visible = true;
objResults = objStudentBL.Student_Select(Convert.ToInt32(ViewState["StudentMID"].ToString()), 0);
divStudentPanel.Visible = true;
if (objResults != null)
{
if (objResults.resultDT.Rows.Count > 0)
{
ViewState["DivisionName"] = objResults.resultDT.Rows[0][StudentBO.STUDENT_CURRENTDIVISIONTID].ToString();
#region Find DivisionName
DivisionTBL objDivision = new DivisionTBL();
ApplicationResult objResultsDivision = new ApplicationResult();
objResultsDivision = objDivision.DivisionT_Select_By_DivisionTID(Convert.ToInt32(objResults.resultDT.Rows[0][StudentBO.STUDENT_CURRENTDIVISIONTID].ToString()));
if (objResultsDivision != null)
{
if (objResultsDivision.resultDT.Rows.Count > 0)
{
ViewState["Division"] = objResultsDivision.resultDT.Rows[0][DivisionTBO.DIVISIONT_DIVISIONNAME].ToString();
}
}
#endregion
#region Find SectionName
SectionBL objSection = new SectionBL();
ApplicationResult objResultsSection = new ApplicationResult();
objResultsSection = objSection.Section_Select(Convert.ToInt32(objResults.resultDT.Rows[0][StudentBO.STUDENT_CURRENTSECTIONID].ToString()));
if (objResultsSection != null)
{
if (objResultsSection.resultDT.Rows.Count > 0)
{
ViewState["SectionName"] = objResultsSection.resultDT.Rows[0][SectionBO.SECTION_SECTIONNAME].ToString();
}
}
#endregion
#region Find Class
ClassBL objClass = new ClassBL();
ApplicationResult objResultsClass = new ApplicationResult();
objResultsClass = objClass.Class_Select(Convert.ToInt32(objResults.resultDT.Rows[0][StudentBO.STUDENT_CURRENTCLASSID].ToString()));
if (objResultsClass != null)
{
if (objResultsClass.resultDT.Rows.Count > 0)
{
ViewState["ClassMID"] = objResultsClass.resultDT.Rows[0][ClassBO.CLASS_CLASSNAME].ToString();
}
}
#endregion
lblAdmissionNo.Text = objResults.resultDT.Rows[0][StudentBO.STUDENT_ADMISSIONNO].ToString();
lblCurrentGrNo.Text = objResults.resultDT.Rows[0][StudentBO.STUDENT_CURRENTGRNO].ToString();
lblStudentNameEng.Text = objResults.resultDT.Rows[0][StudentBO.STUDENT_STUDENTLASTNAMEENG].ToString() + " " + objResults.resultDT.Rows[0][StudentBO.STUDENT_STUDENTFIRSTNAMEENG].ToString() + " " + objResults.resultDT.Rows[0][StudentBO.STUDENT_STUDENTMIDDLENAMEENG].ToString();
lblClassDivision.Text = ViewState["ClassMID"].ToString() + "-" + ViewState["Division"].ToString();
lblCurrentSection.Text = ViewState["SectionName"].ToString();
lblAcademicYear.Text = objResults.resultDT.Rows[0][StudentBO.STUDENT_CURRENTYEAR].ToString();
ViewState["AcademicYear"] = objResults.resultDT.Rows[0][StudentBO.STUDENT_CURRENTYEAR].ToString();
}
}
GridDataBind();
}
}
catch (Exception ex)
{
logger.Error("Error", ex);
ClientScript.RegisterStartupScript(typeof(Page), "MessagePopUp", "<script>alert('Oops! There is some technical issue. Please Contact to your administrator.');</script>");
}
}
/// <summary>
/// 删除事件--从数据库中删除
/// </summary>
/// <param name="classBM"></param>
/// 创 建 人：HNAS Framework 4.0 项目组
/// 创建日期：2012/3/15 17:21:32
/// 修 改 人：
/// 修改日期：
protected void DelBM(ClassBM classBM)
{
// 从数据库中删除
//CallResult<bool> cr = new CommonBL().Delete(classBM);//直接使用BL基类方法
// 从数据库中删除
CallResult<bool> cr = new ClassBL("dbDemo1").DeleteWithTransation(classBM);//
AlertMsn.PopMsn(cr.Message);
if (!cr.HasError || cr.Result)
{
//删除成功重新绑定数据
this.AspNetPager1.CurrentPageIndex = 1;
BindData(this.AspNetPager1.CurrentPageIndex, AspNetPager1.PageSize);
}
}
private void Form1_Load(object sender, EventArgs e)
{
objLogics = new ClassBL();
dataGridView1.DataSource = objLogics.LoadEmployee();
dataGridView1.DataMember = "Table_Employee";
}
protected void gvStudent_RowCommand(object sender, GridViewCommandEventArgs e)
{
try
{
btnSave.Enabled = true;
btnSave.Attributes.Add("bgcolor", "#848484");
Controls objControls = new Controls();
StudentBL objStudentBL = new StudentBL();
ApplicationResult objResults = new ApplicationResult();
if (e.CommandName.ToString() == "Edit1")
{
ViewState["StudentMID"] = Convert.ToInt32(e.CommandArgument.ToString());
objResults = objStudentBL.Student_Select(Convert.ToInt32(ViewState["StudentMID"].ToString()), 0);
if (objResults != null)
{
if (objResults.resultDT.Rows.Count > 0)
{
ViewState["DivisionName"] = objResults.resultDT.Rows[0][StudentBO.STUDENT_CURRENTDIVISIONTID].ToString();
#region Find DivisionName
DivisionTBL objDivision = new DivisionTBL();
ApplicationResult objResultsDivision = new ApplicationResult();
objResultsDivision = objDivision.DivisionT_Select_By_DivisionTID(Convert.ToInt32(objResults.resultDT.Rows[0][StudentBO.STUDENT_CURRENTDIVISIONTID].ToString()));
if (objResultsDivision != null)
{
if (objResultsDivision.resultDT.Rows.Count > 0)
{
ViewState["Division"] = objResultsDivision.resultDT.Rows[0][DivisionTBO.DIVISIONT_DIVISIONNAME].ToString();
}
}
#endregion
#region Find SectionName
SectionBL objSection = new SectionBL();
ApplicationResult objResultsSection = new ApplicationResult();
objResultsSection = objSection.Section_Select(Convert.ToInt32(objResults.resultDT.Rows[0][StudentBO.STUDENT_CURRENTSECTIONID].ToString()));
if (objResultsSection != null)
{
if (objResultsSection.resultDT.Rows.Count > 0)
{
ViewState["SectionName"] = objResultsSection.resultDT.Rows[0][SectionBO.SECTION_SECTIONNAME].ToString();
}
}
#endregion
#region Find Class
ClassBL objClass = new ClassBL();
ApplicationResult objResultsClass = new ApplicationResult();
objResultsClass = objClass.Class_Select(Convert.ToInt32(objResults.resultDT.Rows[0][StudentBO.STUDENT_CURRENTCLASSID].ToString()));
if (objResultsClass != null)
{
if (objResultsClass.resultDT.Rows.Count > 0)
{
ViewState["ClassMID"] = objResultsClass.resultDT.Rows[0][ClassBO.CLASS_CLASSMID].ToString();
ViewState["ClassName"] = objResultsClass.resultDT.Rows[0][ClassBO.CLASS_CLASSNAME].ToString();
}
}
#endregion
ViewState["AcademicYear"] = objResults.resultDT.Rows[0][StudentBO.STUDENT_CURRENTYEAR].ToString();
}
}
}
}
catch (Exception ex)
{
logger.Error("Error", ex);
ClientScript.RegisterStartupScript(typeof(Page), "MessagePopUp", "<script>alert('Oops! There is some technical issue. Please Contact to your administrator.');</script>");
}
}
protected void btnGo_Click(object sender, EventArgs e)
{
if (rblToggleView.SelectedItem.Text == "Class")
{
try
{
ApplicationResult objResult = new ApplicationResult();
ClassBL objClassBL = new ClassBL();
ClassBO objClassBO = new ClassBO();
#region RollBack Transaction Starts
DatabaseTransaction.OpenConnectionTransation();
for (int i = 0; i < gvClass.Rows.Count; i++)
{
TextBox txtSequence = (TextBox)gvClass.Rows[i].FindControl("txtSequence");
if (txtSequence.Text != "")
{
objClassBO.Priority = Convert.ToInt32(txtSequence.Text);
objClassBO.ClassMID = Convert.ToInt32(gvClass.Rows[i].Cells[0].Text);
objClassBO.ClassName = gvClass.Rows[i].Cells[1].Text;
objClassBO.SchoolMID = Convert.ToInt32(Session[ApplicationSession.SCHOOLID]);
objResult = objClassBL.Class_Update_For_Priority(objClassBO);
if (objResult != null)
{
}
else
{
ClientScript.RegisterStartupScript(typeof(Page), "MessagePopUp",
"<script>alert('Oops! There is some technical issue. Please Contact to your administrator...');</script>");
}
}
else
{
ClientScript.RegisterStartupScript(typeof(Page), "MessagePopUp",
"<script>alert('Enter the priority.');</script>");
break;
}
}
DatabaseTransaction.CommitTransation();
#endregion
ClientScript.RegisterStartupScript(typeof(Page), "MessagePopUp",
"<script>alert('Record Saved Successfully.');</script>");
}
catch (Exception ex)
{
logger.Error("Error", ex);
ClientScript.RegisterStartupScript(typeof(Page), "MessagePopUp", "<script>alert('Oops! There is some technical issue. Please Contact to your administrator.');</script>");
}
}
else if (rblToggleView.SelectedItem.Text == "Fees Category")
{
try
{
ApplicationResult objResult = new ApplicationResult();
FeesCategoryBL objFeesCategoryBL = new FeesCategoryBL();
FeesCategoryBO objFeesCategoryBO = new FeesCategoryBO();
#region RollBack Transaction Starts
DatabaseTransaction.OpenConnectionTransation();
for (int i = 0; i < gvFees.Rows.Count; i++)
{
TextBox txtSequence = (TextBox)gvFees.Rows[i].FindControl("txtSequence1");
if (txtSequence.Text != "")
{
objFeesCategoryBO.Priority = Convert.ToInt32(txtSequence.Text);
objFeesCategoryBO.FeesCategoryMID = Convert.ToInt32(gvFees.Rows[i].Cells[0].Text);
objFeesCategoryBO.FeesName = gvFees.Rows[i].Cells[1].Text;
objResult = objFeesCategoryBL.FeesCategory_Update_For_Priority(objFeesCategoryBO);
if (objResult != null)
{
}
else
{
ClientScript.RegisterStartupScript(typeof(Page), "MessagePopUp",
"<script>alert('Oops! There is some technical issue. Please Contact to your administrator...');</script>");
}
}
else
{
ClientScript.RegisterStartupScript(typeof(Page), "MessagePopUp",
"<script>alert('Enter the priority.');</script>");
break;
}
}
DatabaseTransaction.CommitTransation();
#endregion
ClientScript.RegisterStartupScript(typeof(Page), "MessagePopUp",
"<script>alert('Record Saved Successfully.');</script>");
}
catch (Exception ex)
{
logger.Error("Error", ex);
ClientScript.RegisterStartupScript(typeof(Page), "MessagePopUp", "<script>alert('Oops! There is some technical issue. Please Contact to your administrator.');</script>");
}
}
else
{
}
}
protected void gvClass_RowCommand(object sender, GridViewCommandEventArgs e)
{
try
{
ViewState["ClassMID"] = e.CommandArgument.ToString();
Controls objControls = new Controls();
ClassBL objClasstBl = new ClassBL();
ApplicationResult objResults = new ApplicationResult();
DivisionTBL objDivisionBl = new DivisionTBL();
if (e.CommandName.ToString() == "Edit1")
{
objResults = objClasstBl.Class_Select(Convert.ToInt32(ViewState["ClassMID"].ToString()));
if (objResults != null)
{
if (objResults.resultDT.Rows.Count > 0)
{
ddlSection.SelectedValue = objResults.resultDT.Rows[0][ClassBO.CLASS_SECTIONTID].ToString();
txtClassName.Text = objResults.resultDT.Rows[0][ClassBO.CLASS_CLASSNAME].ToString();
txtApprovalNo.Text = objResults.resultDT.Rows[0][ClassBO.CLASS_APPROVALNO].ToString();
txtApprovalDate.Text = objResults.resultDT.Rows[0][ClassBO.CLASS_APPROVALDATE].ToString();
txtNoOfPeriod.Text = objResults.resultDT.Rows[0][ClassBO.CLASS_NOOFPERIOD].ToString();
objResults = objDivisionBl.DivisionT_Select_DivisionName_By_Class(Convert.ToInt32(ViewState["ClassMID"].ToString()));
if (objResults != null)
{
// ViewState["Division"] = objResults.resultDT;
// gvDivision.DataSource = (DataTable)ViewState["Division"];
gvDivision.DataSource = objResults.resultDT;
gvDivision.DataBind();
}
ViewState["Mode"] = "Edit";
PanelGrid_VisibilityMode(2);
}
}
}
if (e.CommandName.ToString() == "Delete1")
{
//objControls.EnableControls(Master.FindControl("ContentPlaceHolder1"));
//ApplicationResult objDelete = new ApplicationResult();
//objDelete = objClasstBl.Validate_Class_Delete(Convert.ToInt32(ViewState["ClassMID"].ToString()), Convert.ToInt32(Session[ApplicationSession.SCHOOLID]), ViewState["DivisionName"].ToString());
//if (objDelete != null)
//{
// if (objDelete.resultDT.Rows.Count > 0)
// {
// if (Convert.ToInt32(objDelete.resultDT.Rows[0]["CurrentClassID"]) == Convert.ToInt32(ViewState["ClassMID"].ToString()))
// {
// ClientScript.RegisterStartupScript(typeof(Page), "MessagePopUp", "<script language='javascript'>alert('There are Student(s) associated with this Class. To delete this Section you need to delete Student(s) first.');</script>");
// }
// }
// else
// {
// objResults = objClasstBl.Class_Delete(Convert.ToInt32(e.CommandArgument.ToString()), Convert.ToInt32(Session[ApplicationSession.SCHOOLID]), ViewState["DivisionName"].ToString());
// if (objResults.status == ApplicationResult.CommonStatusType.SUCCESS)
// {
// ClientScript.RegisterStartupScript(typeof(Page), "MessagePopUp", "<script language='javascript'>alert('Class deleted successfully.');</script>");
// ClearAll();
// GridDataBind();
// PanelGrid_VisibilityMode(1);
// }
// }
//}
ApplicationResult objResult = new ApplicationResult();
ClassBL objClassBl = new ClassBL();
objResult = objClassBl.Class_Delete(Convert.ToInt32(ViewState["ClassMID"].ToString()),
Convert.ToInt32(Session[ApplicationSession.SCHOOLID]));
if (objResult.status == ApplicationResult.CommonStatusType.SUCCESS)
{
ClientScript.RegisterStartupScript(typeof(Page), "MessagePopUp", "<script language='javascript'>alert('Class deleted successfully.');</script>");
GridDataBind();
}
else
{
ClientScript.RegisterStartupScript(typeof(Page), "MessagePopUp", "<script language='javascript'>alert('There are Student(s) associated with this Class. To delete this Section you need to delete Student(s) first.');</script>");
}
}
}
catch (Exception ex)
{
logger.Error("Error", ex);
ClientScript.RegisterStartupScript(typeof(Page), "MessagePopUp", "<script>alert('Oops! There is some technical issue. Please Contact to your administrator.');</script>");
}
}
protected void btnSaveClass_Click(object sender, EventArgs e)
{
try
{
ClassBL objClasstBl = new ClassBL();
ClassBO objClassBo = new ClassBO();
DivisionTBO objDivisionBo = new DivisionTBO();
DivisionTBL objDivisionBl = new DivisionTBL();
Controls objControls = new Controls();
ApplicationResult objResults = new ApplicationResult();
if (ValidateName() == true)
{
ClientScript.RegisterStartupScript(typeof(Page), "MessagePopUp", "<script language='javascript'>alert('Class Name " + txtClassName.Text + " And Divsion " + txtDivisionName.Text + " already Exists.');</script>");
goto Exit;
}
objClassBo.SchoolMID = Convert.ToInt32(Session[ApplicationSession.SCHOOLID].ToString());
objClassBo.SectionTID = Convert.ToInt32(ddlSection.SelectedValue);
objClassBo.SchoolMID = Convert.ToInt32(Session[ApplicationSession.SCHOOLID]);
objClassBo.ClassName = txtClassName.Text;
objClassBo.NoOfPeriod = Convert.ToInt32(txtNoOfPeriod.Text);
objClassBo.ApprovalNo = txtApprovalNo.Text;
objClassBo.ApprovalDate = txtApprovalDate.Text;
objClassBo.LastModifiedDate = DateTime.UtcNow.AddHours(5.5).ToString();
objClassBo.LastModifiedUserID = Convert.ToInt32(Session[ApplicationSession.USERID]);
objDivisionBo.LastModifiedDate = DateTime.UtcNow.AddHours(5.5).ToString();
objDivisionBo.LastModifiedUserID = Convert.ToInt32(Session[ApplicationSession.USERID]);
#region RollBack Transaction Starts
DatabaseTransaction.OpenConnectionTransation();
if (ViewState["Mode"].ToString() == "Save")
{
//objResults = objClasstBl.Class_ValidateName(txtClassName.Text, Convert.ToInt32(Session[ApplicationSession.SCHOOLID]));
//if (objResults != null)
//{
// if (objResults.resultDT.Rows.Count > 0)
// {
// ViewState["ClassMID"] = Convert.ToInt32(objResults.resultDT.Rows[0][0].ToString());
// SaveClass_T();
// }
// else
// {
objResults = objClasstBl.Class_Insert(objClassBo);
if (objResults != null)
{
if (objResults.resultDT.Rows.Count > 0)
{
ViewState["ClassMID"] = Convert.ToInt32(objResults.resultDT.Rows[0][0].ToString());
SaveClass_T();
ClearAll();
ClientScript.RegisterStartupScript(typeof(Page), "MessagePopUp", "<script language='javascript'>alert('Record saved successfully.');</script>");
GridDataBind();
PanelGrid_VisibilityMode(1);
}
else
{
ClientScript.RegisterStartupScript(typeof(Page), "MessagePopUp", "<script language='javascript'>alert('Class Name " + txtClassName.Text + " Already Exists.');</script>");
}
}
// }
//}
}
else
{
objClassBo.ClassMID = Convert.ToInt32(ViewState["ClassMID"].ToString());
objDivisionBo.ClassMID = Convert.ToInt32(ViewState["ClassMID"].ToString());
objResults = objClasstBl.Class_Update(objClassBo);
if (objResults.status == ApplicationResult.CommonStatusType.SUCCESS)
{
//ApplicationResult objResultsDivisionUpdate = new ApplicationResult();
//objResultsDivisionUpdate =
// objDivisionBl.DivisionT_Delete_By_Class(Convert.ToInt32(ViewState["ClassMID"].ToString()));
//DataTable dtTask = (DataTable)ViewState["Division"];
//for (int i = 0; i < dtTask.Rows.Count; i++)
//{
// objDivisionBo.DivisionName = dtTask.Rows[i]["DivisionName"].ToString();
// objResultsDivisionUpdate = objDivisionBl.DivisionT_Insert(objDivisionBo);
//}
ClientScript.RegisterStartupScript(typeof(Page), "MessagePopUp", "<script language='javascript'>alert('Record updated successfully.');</script>");
ClearAll();
GridDataBind();
objControls.ClearForm(Master.FindControl("ContentPlaceHolder1"));
ViewState["Mode"] = "Save";
}
else
{
ClientScript.RegisterStartupScript(typeof(Page), "MessagePopUp", "<script language='javascript'>alert('Class Name " + txtClassName.Text + " Already Exists.');</script>");
}
}
DatabaseTransaction.CommitTransation();
#endregion
Exit :;
}
catch (Exception ex)
{
logger.Error("Error", ex);
ClientScript.RegisterStartupScript(typeof(Page), "MessagePopUp", "<script>alert('Oops! There is some technical issue. Please Contact to your administrator.');</script>");
}
}
/**
* 1. MainMenu - The function prints menu.
* 2. GetUserRequest - The function gets a user request and performs search according this request.
* 3. FileNameRequested - The function returns file name from the user.
* 4. PathRequested - The function returns path from the user if the user chose option 2. If the user chose option 1 the path is C:\\ by default.
* 5. SearchAccessibleFiles - The function receives 2 parameters: filename and directory - path (where to search this file) and
* returns list of paths if there 1 or more and 0 if the file name not found;
* 6. InsertInToDB - The function inserts the result to the database (SearchFileDB) with a table name searchFileLog and columns:
* ID, seachPattern, seachPatternPath, searchDate, resultPatternPath.
* */
static void Main(string[] args)
{
ClassBL bl = new ClassBL();
MainMenu();
void MainMenu()
{
Console.WriteLine("___________________The Program Search file name ______________________________\n");
Console.WriteLine("1. Enter file name to search.");
Console.WriteLine("2. Enter file name to search. + parent directory to search in.");
Console.WriteLine("3. Exit.");
Boolean isExit = GetUserRequest(Console.ReadLine());
if (isExit)
{
Environment.Exit(0);
}
}
Boolean GetUserRequest(string selectedNum)
{
DateTime searchDateTime = DateTime.Now;
string fileName = "";
string pathName = "C:\\";
IEnumerable <string> listFilePath;
switch (selectedNum)
{
case "1":
fileName = FileNameRequested();
if (ErrorInputPatternName(fileName))
{
break;
}
Console.WriteLine("Start searching ... {0}", searchDateTime);
listFilePath = bl.SearchAccessibleFiles(pathName, fileName);
if (listFilePath.Count() == 0)
{
bl.InsertInToDB(fileName, pathName, searchDateTime, "File Not Found");
Console.WriteLine("\nFile name " + fileName + " Not Found. Please try again.");
}
else
{
foreach (string path in listFilePath)
{
bl.InsertInToDB(fileName, pathName, searchDateTime, path);
Console.WriteLine("{0}", path);
}
}
break;
case "2":
fileName = FileNameRequested();
if (ErrorInputPatternName(fileName))
{
break;
}
pathName = PathRequested();
if (ErrorInputPatternName(pathName))
{
break;
}
Console.WriteLine("Start searching ... {0}", searchDateTime);
listFilePath = bl.SearchAccessibleFiles(pathName, fileName);
if (listFilePath.Count() == 0)
{
bl.InsertInToDB(fileName, pathName, searchDateTime, "File Not Found");
Console.WriteLine("\nFile name " + fileName + " Not Found. Please try again.");
}
else
{
foreach (string path in listFilePath)
{
bl.InsertInToDB(fileName, pathName, searchDateTime, path);
Console.WriteLine("{0}", path);
}
}
break;
case "3": return(true);
default:
Console.WriteLine("You have to choose 1,2 or 3.");
break;
}
MainMenu();
return(false);
}
string FileNameRequested()
{
Console.Write("Enter file name to search: ");
return(Console.ReadLine());
}
string PathRequested()
{
Console.Write("Enter root directory to search in: ");
string userPath = Console.ReadLine();
bool isDirectoryExist = Directory.Exists(userPath);
return((isDirectoryExist) ? userPath : null);
}
bool ErrorInputPatternName(string pattern)
{
if (string.IsNullOrEmpty(pattern))
{
Console.WriteLine("\n Error in file name or path. Try again.");
}
return(string.IsNullOrEmpty(pattern));
}
}
