void pGrid_ItemCommand(object sender, GridCommandEventArgs e) { Int64 Key = 0; // Get the ID for the row to select or delete if (e.CommandName.ToUpper() == "SELECT" || e.CommandName.ToUpper() == "DELETE") { //Key = Methods.Convert_Int64(this.UserGrid.pGrid.MasterTableView.Items[e.Item.ItemIndex].GetDataKeyValue("RecruitmentTestUserID").ToString()); Key = this.UserGrid.GetKey(e.Item.ItemIndex); } switch (e.CommandName) { case "Select": this.Response.Redirect(@"~/Page/User_Details.aspx?ID=" + Key); break; case "Delete": ClsKeys ClsKey = new ClsKeys(); ClsKey.Add("RecruitmentTestUserID", Convert.ToInt64(Key)); this.ClsUser.Load(ClsKey); this.ClsUser.Delete(); this.UserGrid.RebindGrid(); break; } }
protected void btnDelete_Click(object sender, EventArgs e) { Int64 Key = Convert.ToInt64(Request.QueryString["ID"].ToString()); ClsKeys ClsKey = new ClsKeys(); ClsKey.Add("RecruitmentTestQuestionsID", Key); ClsQuestion objQuestion = new ClsQuestion(this.Master.pCurrentUser); objQuestion.Load(ClsKey); objQuestion.Delete(); Response.Redirect("Question.aspx"); }
/// <summary> /// (Overrided) Loads the List with the supplied Key /// </summary> /// <param name="Keys"> /// Key object to use /// </param> public override void Load(ClsKeys Keys = null) { if (Keys == null) { this.New(); } else { ClsQueryCondition Qc = this.mDa.CreateQueryCondition(); foreach (string KeyName in Keys.pName) { Qc.Add(KeyName, Keys[KeyName].ToString(), typeof(Int64).ToString(), "0"); } if (this.mQc_LoadCondition != null) { foreach (Layer01_Common.Objects.ClsQueryCondition.Str_QueryCondition Str_Qc in this.mQc_LoadCondition.pList) { Qc.pList.Add(Str_Qc); } } this.Load(Qc); } }
public override void Load(ClsKeys Keys = null) { base.Load(Keys); Int64 ID = 0; if (Keys != null) { try { ID = Keys["RecruitmentTestUserID"]; } catch { } } List<Layer01_Constants.Str_Parameters> List_Sp = new List<Layer01_Constants.Str_Parameters>(); List_Sp.Add(new Layer01_Constants.Str_Parameters("@ID", ID)); DataTable Dt; Dt = (this.mDa.Connection as ClsConnection_SqlServer).ExecuteQuery("usp_RecruitmentTestUser_Rights_Load", List_Sp).Tables[0]; this.AddRequired(Dt); this.pTableDetail_Set("RecruitmentTestUser_Rights", Dt); }
void pGrid_ItemCommand(object sender, Telerik.Web.UI.GridCommandEventArgs e) { Int64 Key = 0; // Get the ID for the row to select or delete if (e.CommandName.ToUpper() == "SELECT" || e.CommandName.ToUpper() == "DELETE") { Key = this.QuestionGrid.GetKey(e.Item.ItemIndex); } switch (e.CommandName) { case "Select": this.Response.Redirect(@"~/Page/Question_Details.aspx?ID=" + Key); break; case "Delete": ClsKeys ClsKey = new ClsKeys(); ClsKey.Add("RecruitmentTestQuestionsID", Convert.ToInt64(Key)); ClsQuestion Obj_Question = new ClsQuestion(this.Master.pCurrentUser); Obj_Question.Load(ClsKey); if (this.Master.pCurrentUser.pUserType != Layer02_Constants.eLookupUserType.Administrator) { Int64 CurrentUserID = Methods.Convert_Int64(this.Master.pCurrentUser.pDrUser["RecruitmentTestUserID"], 0); Int64 OwnerUserID = Methods.Convert_Int64(Obj_Question.pDr["RecruitmentTestUserID_CreatedBy"], 0); if (CurrentUserID != OwnerUserID) { this.Show_EventMsg("You can't delete this question.", ClsBaseMain_Master.eStatus.Event_Error); this.QuestionGrid.RebindGrid(); return; } } Obj_Question.Delete(); this.QuestionGrid.RebindGrid(); break; } }
public static bool CheckSeriesDuplicate( string TableName , string SeriesField , ClsKeys Keys , string SeriesNo) { bool Rv = false; DataTable Dt; System.Text.StringBuilder Sb_Query_Key = new StringBuilder(); string Query_Key = ""; string Query_And = ""; foreach (string Inner_Key in Keys.pName) { Sb_Query_Key.Append(Query_And + " " + Inner_Key + " = " + Keys[Inner_Key]); Query_And = " And "; } Query_Key = " 1 = 1 "; if (Sb_Query_Key.ToString() != "") { Query_Key = "(Not (" + Sb_Query_Key.ToString() + "))"; } Dt = Do_Methods_Query.GetQuery( "[" + TableName + "]" , "Count(1) As [Ct]" , Query_Key + " And " + SeriesField + " = '" + SeriesNo + "'"); if (Dt.Rows.Count > 0) { if ((Int32)Dt.Rows[0][0] > 0) { Rv = true; } } //True means duplicates have been found return(Rv); }
public DataTable Load_TableDetails(string ObjectName, ClsKeys Keys, string Condition) { StringBuilder Sb_Condition = new StringBuilder(); DataTable Dt; if (Keys == null) { Dt = this.GetQuery(this.Connection, ObjectName, "*", "1 = 0"); } else { string Inner_Condition_And = ""; bool IsStart = false; foreach (string Inner_Key in Keys.pName) { Sb_Condition.Append(Inner_Condition_And + " " + Inner_Key + " = " + Keys[Inner_Key]); if (!IsStart) Inner_Condition_And = " And "; IsStart = true; } string OtherCondition = ""; if (Condition != "") OtherCondition = " And " + Condition; Dt = this.GetQuery(this.Connection, ObjectName, "*", Sb_Condition.ToString() + OtherCondition); } return Dt; }
//[-] /// <summary> /// (Overridable) Loads the Data Object with the supplied Key /// </summary> /// <param name="Keys"> /// Key object to use /// </param> public virtual void Load(ClsKeys Keys = null) { try { this.mDa.Connect(); //[-] this.mHeader_Dr = this.mDa.Load(this.mHeader_ViewName, this.mHeader_Key, Keys); //[-] if (this.mBase_TableDetail != null) { foreach (ClsBaseTableDetail Inner_Obj in this.mBase_TableDetail) { Inner_Obj.Load(this.mDa, Keys); } } //[-] if (this.mBase_RowDetail != null) { foreach (ClsBaseRowDetail Inner_Obj in this.mBase_RowDetail) { Inner_Obj.Load(this.mDa, Keys); } } //[-] this.AddRequired(); } catch (Exception Ex) { throw Ex; } finally { this.mDa.Close(); } }
public DataRow Load(string ObjectName, List<string> List_Key, ClsKeys Keys) { DataTable Dt; DataRow Dr; if (Keys == null) { Dr = this.GetQuery(this.Connection, ObjectName, "*", "1 = 0").NewRow(); } else { StringBuilder Sb_Condition = new StringBuilder(); if (Keys.Count() != List_Key.Count) { throw new Exception("Keys not equal to required keys."); } Sb_Condition.Append(" 1 = 1 "); foreach (string Inner_Key in List_Key) { Sb_Condition.Append(" And " + Inner_Key + " = " + Keys[Inner_Key]); } Dt = this.GetQuery(this.Connection, ObjectName, "*", Sb_Condition.ToString()); if (Dt.Rows.Count > 0) { Dr = Dt.Rows[0]; } else { throw new ClsCustomException("Record not found."); } } return Dr; }
/// <summary> /// Gets the Keys of the supplied row using the Key Definition of the Data Object /// </summary> /// <param name="Dr"> /// Source datarow, mostly the same definition as from Me.List() /// </param> /// <returns></returns> public ClsKeys GetKeys(DataRow Dr) { ClsKeys Obj = new ClsKeys(); foreach (string Key in this.mHeader_Key) { Int64 ID = (Int64)Methods.IsNull(Dr[Key], 0); Obj.Add(Key, ID); } return Obj; }
/// <summary> /// Gets the Keys of the supplier datarow using the supplier Key Definition /// </summary> /// <param name="Dr"> /// Source datarow /// </param> /// <param name="KeyNames"> /// Key definition /// </param> /// <returns></returns> public ClsKeys GetKeys(DataRow Dr, List<string> KeyNames) { bool IsFound = false; ClsKeys Key = new ClsKeys(); foreach (string Inner_Key in KeyNames) { if (!Information.IsDBNull(Dr[Inner_Key])) { Key.Add(Inner_Key, (Int64)Methods.IsNull(Dr[Inner_Key], 0)); } else { IsFound = true; break; } } if (IsFound) { Key = null; } return Key; }
/* public void Load(Interface_DataAccess Da, string Condition) { string OtherCondition = ""; if (this.mOtherLoadCondition != "") OtherCondition = " And " + this.mOtherLoadCondition; DataTable Dt; if (Condition == "") Dt = this.mDa.GetQuery(Da.Connection, this.mViewName, "*", "1 = 0"); else Dt = this.mDa.GetQuery(Da.Connection, this.mViewName, "*", Condition + OtherCondition); this.mDt = Dt; } */ /* public void Load(string Condition) { try { this.mDa.Connect(); this.Load(this.mDa, Condition); } catch (Exception ex) { throw ex; } finally { this.mDa.Close(); } } */ public void Load(Interface_DataAccess Da, ClsKeys Keys) { this.mDt = Da.Load_TableDetails(this.mViewName, Keys, this.mOtherLoadCondition); }
//[-] /// <summary> /// Gets the current Keys of the Data Object /// </summary> /// <returns></returns> public ClsKeys GetKeys() { ClsKeys Obj = new ClsKeys(); foreach (string Key in this.mHeader_Key) { Int64 ID = Convert.ToInt64(Methods.IsNull(this.mHeader_Dr[Key], 0)); Obj.Add(Key, ID); } return Obj; }
protected void RadAjaxPanel1_AjaxRequest(object sender, Telerik.Web.UI.AjaxRequestEventArgs e) { string[] Tmp; string CommandName = string.Empty; Int32 ItemIndex = -1; string ComboText = ""; try { Tmp = e.Argument.Split(','); CommandName = Tmp[0]; switch (CommandName) { case "Dialog_Answer": ComboText = Tmp[1]; break; case "Delete": ItemIndex = Methods.Convert_Int32(Tmp[1], -1); break; } } catch { } switch (CommandName) { case "Dialog_Answer": { Int64 Key = Methods.Convert_Int64(this.RadWindow1_Hid_TmpKey.Value); Layer02_Objects.Modules_Objects.ClsQuestion Obj = (Layer02_Objects.Modules_Objects.ClsQuestion)this.mObj_Base; Layer02_Objects.Modules_Objects.ClsAnswer Obj_Answer = null; System.Data.DataRow Dr_QA = null; bool IsNew = false; if (Key == 0) { IsNew = true; } else { System.Data.DataRow[] Arr_Dr = Obj.pDt_QuestionAnswer.Select("TmpKey = " + Key); if (Arr_Dr.Length > 0) { Dr_QA = Arr_Dr[0]; Obj_Answer = (Layer02_Objects.Modules_Objects.ClsAnswer)Obj.pBO_Answer[Key.ToString()]; } else { IsNew = true; } } if (IsNew) { Dr_QA = Obj.pDt_QuestionAnswer.NewRow(); Dr_QA["TmpKey"] = Layer02_Objects.Modules_Base.Abstract.ClsBase.GetNewTmpKey(Obj.pDt_QuestionAnswer); Obj.pDt_QuestionAnswer.Rows.Add(Dr_QA); } bool IsNewAnswer = false; if (this.RadWindow1_RadComboBox1.SelectedValue == "") { IsNewAnswer = true; } if (IsNewAnswer || IsNew) { Obj_Answer = new Layer02_Objects.Modules_Objects.ClsAnswer(); if (IsNewAnswer) { Obj_Answer.Load(); //Obj_Answer.pDr["Answer"] = this.RadWindow1_RadComboBox1.Text; Obj_Answer.pDr["Answer"] = ComboText; } Obj.pBO_Answer.Add(Dr_QA["TmpKey"].ToString(), Obj_Answer); } if (!IsNewAnswer) { Layer02_Objects._System.ClsKeys Inner_Key = null; Inner_Key = new Layer02_Objects._System.ClsKeys(); Inner_Key.Add("RecruitmentTestAnswersID", Layer01_Common.Common.Methods.Convert_Int64(this.RadWindow1_RadComboBox1.SelectedValue)); Obj_Answer.Load(Inner_Key); } Dr_QA["IsAnswer"] = this.RadWindow1_Chk_IsAnswer.Checked; Dr_QA["Lkp_RecruitmentTestAnswersID_Desc"] = (string)Layer01_Common.Common.Methods.IsNull(Obj_Answer.pDr["Answer"], ""); break; } case "Delete": { Int64 Key = Methods.Convert_Int64(this.RadGrid1.MasterTableView.Items[ItemIndex].GetDataKeyValue("TmpKey").ToString()); ClsQuestion Obj = (ClsQuestion)this.mObj_Base; DataRow[] Arr_Dr = Obj.pDt_QuestionAnswer.Select("TmpKey = " + Key); if (Arr_Dr.Length > 0) { Arr_Dr[0].Delete(); } break; } } this.BindGrid(); }
//[-] public virtual void Load(ClsKeys Keys = null) { ClsDataAccess Da = new ClsDataAccess(); StringBuilder Sb_Condition = new StringBuilder(); string Condition = ""; try { if (Keys != null) { if (Keys.Count() != this.mHeader_Key.Count) { throw new Exception("Keys not equal to required keys."); } string Inner_Condition_And = ""; bool IsStart = false; foreach (string Inner_Key in this.mHeader_Key) { Sb_Condition.Append(Inner_Condition_And + " " + Inner_Key + " = " + Keys[Inner_Key]); if (!IsStart) Inner_Condition_And = " And "; IsStart = true; } } Condition = Sb_Condition.ToString(); Da.Connect(); DataTable Dt; DataRow Dr; if (Keys == null) { Dt = Methods_Query.GetQuery(Da, this.mHeader_ViewName, "*", "1 = 0"); Dr = Dt.NewRow(); } else { Dt = Methods_Query.GetQuery(Da, this.mHeader_ViewName, "*", Condition); Dr = Dt.Rows[0]; } this.mHeader_Dr = Dr; //[-] if (this.mBase_TableDetail != null) { foreach (ClsBaseTableDetail Inner_Obj in this.mBase_TableDetail) { Inner_Obj.Load(Da, Condition); } } //[-] if (this.mBase_RowDetail != null) { foreach (ClsBaseRowDetail Inner_Obj in this.mBase_RowDetail) { Inner_Obj.Load(Da, Condition); } } //[-] this.AddRequired(); } catch { } }
public override void Load(ClsKeys Keys = null) { base.Load(Keys); this.CheckIfDeleted(); //[-] Int64 QuestionID = Convert.ToInt64(Layer01_Methods.IsNull(this.pDr["RecruitmentTestQuestionsID"], 0)); if (QuestionID != 0) { Keys = new ClsKeys(); Keys.Add("Lkp_RecruitmentTestQuestionsID", QuestionID); } else { Keys = null; } this.mBL_QuestionAnswer.Load(Keys); foreach (DataRow Dr in this.mBL_QuestionAnswer.pDt_List.Rows) { ClsAnswer Inner_Obj = new ClsAnswer(); ClsKeys Inner_Keys = null; Int64 Inner_ID = Convert.ToInt64(Layer01_Methods.IsNull(Dr["Lkp_RecruitmentTestAnswersID"], 0)); if (Inner_ID != 0) { Inner_Keys = new ClsKeys(); Inner_Keys.Add("RecruitmentTestAnswersID", Inner_ID); } Inner_Obj.Load(Inner_Keys); this.mBO_Answer.Add(Convert.ToInt64(Layer01_Methods.IsNull(Dr["TmpKey"], 0)).ToString(), Inner_Obj); } DataRow[] ArrDr = this.mBL_QuestionAnswer.pDt_List.Select("", "OrderIndex"); int Ct = 0; foreach (DataRow Dr in ArrDr) { Ct++; Dr["OrderIndex"] = Ct; } this.FixOrderIndex(true); this.mBL_QuestionAnswer.pDt_List.DefaultView.Sort = "OrderIndex"; }
public void LoadExam(Int64 ExamID, Int64 ItemsLimit) { ClsBase Base = new ClsBase(); Interface_DataAccess Da = Base.pDa; DataTable Dt_Exam = Da.GetQuery("RecruitmentTestExams", "", "RecruitmentTestExamsID = " + ExamID); Int64 ApplicantID = 0; if (Dt_Exam.Rows.Count > 0) { this.mDr_Exam = Dt_Exam.Rows[0]; ApplicantID = Convert.ToInt64(Layer01_Methods.IsNull(this.mDr_Exam["RecruitmentTestApplicantID"], 0)); } else { throw new Exception("Exam Data not found."); } ClsKeys Key = new ClsKeys(); Key.Add("RecruitmentTestApplicantID", ApplicantID); this.mObj_Applicant = new ClsApplicant(); this.mObj_Applicant.Load(Key); DataSet Ds = this.mEm.LoadExam(ExamID); this.mDs = Ds; this.mDt_Question = Ds.Tables[0]; this.mDt_Question_Answer = Ds.Tables[1]; this.mDt_Question.Columns.Add("Ct", typeof(Int64)); Int64 Ct = 0; foreach (DataRow Dr in this.mDt_Question.Rows) { Ct++; Dr["Ct"] = Ct; } this.mDt_Question_Answer.Columns.Add("Ct", typeof(Int64)); Ct = 0; foreach (DataRow Dr in this.mDt_Question_Answer.Rows) { Ct++; Dr["Ct"] = Ct; } this.mItemsLimit = ItemsLimit; this.mItems = this.mDt_Question.Rows.Count; this.mPages = this.mItems / this.mItemsLimit; if (this.mItems % this.mItemsLimit > 0) { this.mPages++; } }
void SetupPage() { ClsSysCurrentUser CurrentUser = this.Master.pCurrentUser; Int64 ID = Methods.Convert_Int64(this.Request.QueryString["ID"]); ClsKeys Key = null; if (ID != 0) { Key = new Layer02_Objects._System.ClsKeys(); Key.Add("RecruitmentTestQuestionsID", ID); } else { this.mIsNew = true; } this.mObj_Base = new ClsQuestion(this.Master.pCurrentUser); this.mObj_Base.Load(Key); this.mObjID = CurrentUser.GetNewPageObjectID(); this.ViewState[CnsObjID] = this.mObjID; this.Session[this.mObjID] = this.mObj_Base; //[-] Int64 UserID = Methods.Convert_Int64(CurrentUser.pDrUser["RecruitmentTestUserID"], 0); Int64 UserID_CreatedBy = Methods.Convert_Int64(this.mObj_Base.pDr["RecruitmentTestUserID_CreatedBy"], 0); bool IsApproved = Convert.ToBoolean(Methods.IsNull(this.mObj_Base.pDr["IsApproved"], false)); if (! ( (CurrentUser.pIsAdmin || ((UserID == UserID_CreatedBy) && (!IsApproved))) || (this.mIsNew) ) ) { this.mIsReadOnly = true; } //[-] if ((bool)Methods.IsNull(CurrentUser.pDrUser["IsAdministrator"], false)) { this.Btn_Approve.Enabled = true; //this.Btn_Approve2.Enabled = true; } //[-] ClsQuestion Obj_Question = (ClsQuestion)this.mObj_Base; this.Txt_Question.Text = (string)Methods.IsNull(Obj_Question.pDr["Question"], ""); this.Chk_IsMultipleAnswer.Checked = Convert.ToBoolean(Methods.IsNull(Obj_Question.pDr["IsMultipleAnswer"], false)); //[-] this.SetupPage_ControlAttributes(); this.BindGrid(); }