//public bool AddNewRC_User(RC_User user) //{ // SqlParameter[] parameters = new SqlParameter[] // { // new SqlParameter("@name", user.Name), // new SqlParameter("@RoleID", user.RoleID), // new SqlParameter("@DaneshID",user.DaneshID) // }; // return SqlDBHelper.ExecuteNonQuery("sp_RC_UsersInsert", CommandType.StoredProcedure, parameters); ; //} //public bool UpdateRC_User(RC_User user) //{ // SqlParameter[] parameters = new SqlParameter[] // { // new SqlParameter("@ID",user.ID), // new SqlParameter("@name", user.Name), // new SqlParameter("@RoleID", user.RoleID), // new SqlParameter("@DaneshID",user.DaneshID) // }; // return SqlDBHelper.ExecuteNonQuery("sp_RC_UsersUpdate", CommandType.StoredProcedure, parameters); //} public List <RC_User> GetOstadListByDaneshID(int daneshID) { List <RC_User> userlist = null; SqlParameter[] parameters = new SqlParameter[] { new SqlParameter("@daneshID", daneshID) }; using (DataTable table = SqlDBHelper.ExecuteParamerizedSelectCommand("[Resource_Control].[SP_GetOstadListByDaneshID]", CommandType.StoredProcedure, parameters)) { if (table.Rows.Count > 0) { userlist = new List <RC_User>(); foreach (DataRow row in table.Rows) { RC_User user = new RC_User(); user.ID = Convert.ToInt32(row["code_ostad"]); user.Name = (row["name"] as string) + " " + (row["family"] as string); //user.RoleID = Convert.ToInt32(row["RoleID"]); //user.DaneshID = Convert.ToInt32(row["DaneshID"]); userlist.Add(user); } } } return(userlist); }
//public bool DeleteRC_User(int catID) //{ // SqlParameter[] parameters = new SqlParameter[] // { // new SqlParameter("@ID", catID) // }; // return SqlDBHelper.ExecuteNonQuery("sp_RC_UsersDelete", CommandType.StoredProcedure, parameters); //} public RC_User GetUserDetails(int usrID) { RC_User user = null; SqlParameter[] parameters = new SqlParameter[] { new SqlParameter("@userID", usrID) }; using (DataTable table = SqlDBHelper.ExecuteParamerizedSelectCommand("spgetuserdetail", CommandType.StoredProcedure, parameters)) { if (table.Rows.Count == 1) { DataRow row = table.Rows[0]; user = new RC_User(); user.ID = Convert.ToInt32(row["code_ostad"]); user.Name = row["name"] as string + " " + row["family"] as string; //user.RoleID =Convert.ToInt32(row["RoleID"]); //user.DaneshID = Convert.ToInt32(row["DaneshID"]); } } return(user); }
public RC_User Get_Ostad_Details(int ostadID) { RC_User user = null; SqlParameter[] parameters = new SqlParameter[] { new SqlParameter("@ostadID", ostadID) }; using (DataTable table = SqlDBHelper.ExecuteParamerizedSelectCommand("[Resource_Control].[SP_GetOstadName]", CommandType.StoredProcedure, parameters)) { if (table.Rows.Count == 1) { DataRow row = table.Rows[0]; user = new RC_User(); user.ID = Convert.ToInt32(row["code_ostad"]); user.Name = (row["name"] as string) + " " + (row["family"] as string); //user.DaneshID = Convert.ToInt32(row["DaneshID"]); } } return(user); }
private void CreateRequest() { RequestFR req = new RequestFR(); req.CatID = Convert.ToInt32(drpCategory.SelectedValue); req.Subject = "nosub"; req.Note = txtDescription.Text; req.Location = drpLocation.SelectedValue; RC_User user = new RC_User(); RC_UserHandler us = new RC_UserHandler(); var user1 = Session["UserName"].ToString(); //user = us.Get_Ostad_DetailsByCourseId(Convert.ToInt32(drpCourse.SelectedValue)); req.IssuerID = int.Parse(Session[sessionNames.userID_Karbar].ToString()); req.IssuerName = Session["UserName"].ToString(); //int coursedid = Convert.ToInt32(drpCourse.SelectedValue); req.Capacity = Convert.ToInt32(txtCapacity.Text); req.CourseName = txt_courseName.Text; req.DaneshID = 5;//dorehaye kootah modat req.CourseDID = 0; req.Issue_time = DateTime.Now.ToPeString(); req.Status = (int)RequestStatus.sent; if (chbRepeat.Checked == false) { if (CheckReqDate(pcal1.Text)) { RequestDateTime rdt = new RequestDateTime(); rdt.Date = pcal1.Text; rdt.StartTime = RadTimePicker1.SelectedTime.Value.Ticks; rdt.EndTime = RadTimePicker2.SelectedTime.Value.Ticks; req.DateTimeRange = new List <RequestDateTime>(); req.DateTimeRange.Add(rdt); } else { string scrp = "تاریخ درخواست باید بعد از تاریخ امروز باشد."; RadWindowManager1.RadAlert(scrp, 300, 100, "خطا", ""); //ScriptManager.RegisterStartupScript(this, this.GetType(), "alert", scrp, true); return; } } else { if (CheckReqDate(pcal1.Text) && CheckReqDate(pcal2.Text)) { req.DateTimeRange = FillRequestDateTime(pcal1.Text, pcal2.Text, RadTimePicker1.SelectedTime, RadTimePicker2.SelectedTime, chblWeekDates); } else { string scrp = "تاریخ درخواست باید بعد از تاریخ امروز باشد.";//باید این پیام عوض شود. RadWindowManager1.RadAlert(scrp, 300, 100, "خطا", ""); //ScriptManager.RegisterStartupScript(this, this.GetType(), "alert", scrp, true); return; } } optlist = new List <Option>(); foreach (ListItem item in chblOptions.Items) { if (item.Selected) { Option opt = new Option(); opt.ID = Convert.ToInt32(item.Value); opt.Name = item.Text; opt.IsActive = item.Selected; optlist.Add(opt); } } RequestHandler rqh = new RequestHandler(); //DataTable dt = rqh.HasRequestBefore(req.IssuerID, req.DateTimeRange); //if (dt.Rows.Count > 0) //{ // if (dt.Select().ToList().Exists(row => row["MayConflict"].ToString() == "1")) // { // string scrp = "تداخل در ساعت و تاریخ درخواست ، با ساعات درخواست های پیشین این استاد."; // RadWindowManager1.RadAlert(scrp, 300, 100, "خطا", ""); // return; // } //} if (RequestHandler.IsNotSpecifiedDay(DayOfWeek.Friday, req.DateTimeRange)) { string scrp = "در روز جمعه امکان برگزاری وجود ندارد"; RadWindowManager1.RadAlert(scrp, 300, 100, "خطا", ""); return; } try { var address = ViewState["GoBackTo"].ToString(); int reqid = rqh.AddNewRequest(req, optlist, Session[sessionNames.userID_Karbar].ToString()); var comman = new CommonBusiness(); comman.InsertIntoUserLog(Convert.ToInt32(Session[sessionNames.userID_Karbar].ToString()), "", 11, 114, "ثبت درخواست کلاس دوره کوتاه مدت", reqid); string resdirectFunc = "function redirectToLast(){ window.location= '" + address + "' ; }"; string scrp = "درخواست شما با شماره " + reqid.ToString() + " با موفقیت ثبت گردید"; RadWindowManager1.RadAlert(scrp, 300, 100, "پیام سیستم", resdirectFunc); } catch (Exception) { throw; } }
private void CreateRequest() { RequestFR req = new RequestFR(); req.CatID = Convert.ToInt32(drpCategory.SelectedValue); req.Subject = "nosub"; req.Note = txtDescription.Text; req.Location = drpLocation.SelectedValue; req.Status = (int)RequestStatus.sent; RC_User user = new RC_User(); RC_UserHandler us = new RC_UserHandler(); CourseHandler corH = new CourseHandler(); if (chkMeeting.Checked == true) { req.IssuerID = Convert.ToInt32(Session[sessionNames.userID_Karbar].ToString()); user.Name = Session["UserName"].ToString(); req.IssuerName = user.Name; if (drpCategory.SelectedIndex == 3) { req.CourseName = "درخواست جلسه"; } else { req.CourseName = "درخواست کلاس بدون استاد"; } Session["isMeeting"] = true; daneshID = Convert.ToInt32(Session["DaneshId"]); req.DaneshID = daneshID; req.Capacity = Convert.ToInt32(txtCapacity.Text); } else { if (UtilityFunction.IsMasouleDaftarUser(roleID)) { req.IssuerID = Convert.ToInt32(Session[sessionNames.userID_Karbar].ToString()); user.Name = Session["UserName"].ToString(); req.IssuerName = user.Name; if (drpCategory.SelectedIndex == 3) { req.CourseName = "درخواست جلسه"; } else { req.CourseName = "درخواست کلاس بدون استاد"; } Session["isMeeting"] = true; daneshID = Convert.ToInt32(Session["DaneshId"]); req.DaneshID = daneshID; req.Capacity = Convert.ToInt32(txtCapacity.Text); } else { req.IssuerID = Convert.ToInt32(RadComboBoxField.SelectedValue.ToString()); user = us.Get_Ostad_Details(req.IssuerID); req.IssuerName = user.Name; courselist = corH.GetCourseListByUserID(req.IssuerID); int coursedid = Convert.ToInt32(drpCourse.SelectedValue); req.Capacity = Convert.ToInt32(txtCapacity.Text); req.CourseName = drpCourse.SelectedItem.ToString(); req.DaneshID = courselist.Find(i => i.DID == coursedid).DaneshID; req.CourseDID = coursedid; } } req.Issue_time = DateTime.Now.ToPeString(); if (chbRepeat.Checked == false) { if (CheckReqDate(pcal1.Text)) { RequestDateTime rdt = new RequestDateTime(); rdt.Date = pcal1.Text; rdt.StartTime = RadTimePicker1.SelectedTime.Value.Ticks; rdt.EndTime = RadTimePicker2.SelectedTime.Value.Ticks; req.DateTimeRange = new List <RequestDateTime>(); req.DateTimeRange.Add(rdt); } else { string scrp = "تاریخ درخواست باید بعد از تاریخ امروز باشد."; RadWindowManager1.RadAlert(scrp, 300, 100, "خطا", ""); //ScriptManager.RegisterStartupScript(this, this.GetType(), "alert", scrp, true); return; } } else { if (CheckReqDate(pcal1.Text) && CheckReqDate(pcal2.Text)) { req.DateTimeRange = FillRequestDateTime(pcal1.Text, pcal2.Text, RadTimePicker1.SelectedTime, RadTimePicker2.SelectedTime, chblWeekDates); } else { string scrp = "تاریخ درخواست باید بعد از تاریخ امروز باشد.";//باید این پیام عوض شود. RadWindowManager1.RadAlert(scrp, 300, 100, "خطا", ""); //ScriptManager.RegisterStartupScript(this, this.GetType(), "alert", scrp, true); return; } } optlist = new List <Option>(); foreach (ListItem item in chblOptions.Items) { if (item.Selected) { Option opt = new Option(); opt.ID = Convert.ToInt32(item.Value); opt.Name = item.Text; opt.IsActive = item.Selected; optlist.Add(opt); } } RequestHandler rqh = new RequestHandler(); DataTable dt = rqh.HasRequestBefore(req.IssuerID, req.DateTimeRange); if (dt.Rows.Count > 0) { if (dt.Select().ToList().Exists(row => row["MayConflict"].ToString() == "1")) { string scrp = "تداخل در ساعت و تاریخ درخواست ، با ساعات درخواست های پیشین این استاد."; RadWindowManager1.RadAlert(scrp, 300, 100, "خطا", ""); return; } } if (RequestHandler.IsNotSpecifiedDay(DayOfWeek.Friday, req.DateTimeRange)) { string scrp = "در روز جمعه امکان برگزاری وجود ندارد"; RadWindowManager1.RadAlert(scrp, 300, 100, "خطا", ""); return; } try { int reqid = rqh.AddNewRequest(req, optlist, Session[sessionNames.userID_Karbar].ToString()); var comman = new CommonBusiness(); comman.InsertIntoUserLog(userID, "", 11, 114, "ثبت درخواست کلاس ", reqid); string scrp = "درخواست شما با شماره " + reqid.ToString() + " با موفقیت ثبت گردید"; string address = prevPage + "?id=" + generaterandomstr() + "@A" + "0" + "-" + generaterandomstr(); string resdirectFunc = "function redirectToLast(){ window.location= '" + address + "' ; }"; RadWindowManager1.RadAlert(scrp, 300, 100, "پیام سیستم", resdirectFunc); //ScriptManager.RegisterStartupScript(this, this.GetType(), "alert", scrp, true); } catch (Exception) { throw; } }
static void Main(string[] args) { IBO_Authentication _authentication; IBO_User _user; string _login; for (int _provider = 0; _provider < 3; _provider++) { switch (_provider) { case 0: Console.WriteLine("--- remoting..."); _authentication = new RC_Authentication( "tcp://127.0.0.1:8085/OGen.NTier.UTs.distributedlayer.remoting.server.RS_Authentication.remoting" //"http://127.0.0.1:8085/OGen.NTier.UTs.distributedlayer.remoting.server.RS_Authentication.soap" ); _user = new RC_User( "tcp://127.0.0.1:8085/OGen.NTier.UTs.distributedlayer.remoting.server.RS_User.remoting" //"http://127.0.0.1:8085/OGen.NTier.UTs.distributedlayer.remoting.server.RS_User.soap" ); break; case 1: Console.WriteLine("--- webservices..."); _authentication = new WC_Authentication.WC_Authentication( "http://127.0.0.1:2937/WS_Authentication.asmx" ); _user = new WC_User.WC_User( "http://127.0.0.1:2937/WS_User.asmx" ); break; default: Console.WriteLine("--- direct assembly..."); _authentication = new BC_Authentication( ); _user = new BC_User( ); break; } Console.WriteLine( "authentication string: {0}\n", _login = _authentication.Login( "fmonteiro", "passpub" ) ); OGen.NTier.UTs.lib.datalayer.proxy.ISO_User _so_user = new OGen.NTier.UTs.lib.datalayer.proxy.SO_User( 0L, string.Format( "login-{0}", Guid.NewGuid().ToString() ), "password", 0 ); _so_user.SomeNullValue_isNull = true; Console.WriteLine( "IDUser: {0}; Login: {1}; Password: {2}; SomeNullValue: {3} (is null: {4})", _so_user.IDUser, _so_user.Login, _so_user.Password, _so_user.SomeNullValue, _so_user.SomeNullValue_isNull ); long _iduser; bool _constraintExists; Console.WriteLine( "IDUser: {0}; Constraint Exists: {1}", _iduser = _user.insObject( (SO_User)_so_user, true, _login, out _constraintExists ), _constraintExists ); bool _exists; _so_user = _user.getObject( _iduser, _login, out _exists ); Console.WriteLine( "Exists: {5}; IDUser: {0}; Login: {1}; Password: {2}; SomeNullValue: {3} (is null: {4})", _so_user.IDUser, _so_user.Login, _so_user.Password, _so_user.SomeNullValue, _so_user.SomeNullValue_isNull, _exists ); long _recordLength; SO_User[] _users = _user.Record_Open_byGroup( 3L, 1, 4, _login, out _recordLength ); Console.WriteLine( "Record Length: {0}", _recordLength ); for (int i = 0; i < _users.Length; i++) { Console.WriteLine( //"IDUser: {0}; Login: {1}", "IDUser: {0}; Login: {1}; Password: {2}; SomeNullValue: {3} (is null: {4})", _users[i].IDUser, _users[i].Login, _users[i].Password, _users[i].SomeNullValue, _users[i].SomeNullValue_isNull ); } _authentication.Logout(); } return; //OGen.NTier.UTs.lib.businesslayer-2.0 Assembly _assembly = Assembly.Load( #if NET_1_1 "OGen.NTier.UTs.lib.businesslayer-1.1" #elif NET_2_0 "OGen.NTier.UTs.lib.businesslayer-2.0" #endif ); if (_assembly != null) { Type[] _types = _assembly.GetTypes(); for (int t = 0; t < _types.Length; t++) { Type _type = (Type)_types[t]; object[] _attibutes = _type.GetCustomAttributes( typeof(BOClassAttribute), true //false ); if ( (_attibutes.Length > 0) && (_type.Name.IndexOf("BO0_") != 0) && (_type.Name.IndexOf("BBO0_") != 0) ) { Console.Write("{0}; ", _type.Name); for (int c = 0; c < _attibutes.Length; c++) { BOClassAttribute _attribute = (BOClassAttribute)_attibutes[c]; Console.WriteLine( "name:{0};", _attribute.Name ); MethodInfo[] _methods = _type.GetMethods( BindingFlags.Public | BindingFlags.Instance ); for (int m = 0; m < _methods.Length; m++) { if (Attribute.IsDefined( _methods[m], typeof(BOMethodAttribute) )) { Attribute[] _attributes = Attribute.GetCustomAttributes( _methods[m], typeof(BOMethodAttribute), true ); for (int a = 0; a < _attributes.Length; a++) { //if (_attributes[a].GetType() == typeof(BOMethodAttribute)) { BOMethodAttribute _propertyattribute = (BOMethodAttribute)_attributes[a]; Console.WriteLine( "\tname:{0}; distribute:{1};", _propertyattribute.Name, _propertyattribute.Distribute ); //} } Console.WriteLine( "\t.{0}:{1}.{2}(", _methods[m].Name, _methods[m].ReturnType.Namespace, _methods[m].ReturnType.Name ); ParameterInfo[] _parameterinfo = _methods[m].GetParameters(); for (int p = 0; p < _parameterinfo.Length; p++) { Console.WriteLine( "\t\tname:{0}; type:{1}; isOut:{2}; isByRef:{3}; isEnum:{4}; isClass:{5}; isValueType:{6}", _parameterinfo[p].Name, _parameterinfo[p].ParameterType, _parameterinfo[p].IsOut, _parameterinfo[p].ParameterType.IsByRef, _parameterinfo[p].ParameterType.IsEnum, _parameterinfo[p].ParameterType.IsClass, _parameterinfo[p].ParameterType.IsValueType ); } Console.WriteLine("\t)"); } } Console.WriteLine(); } } } } return; //DO_UserGroup _usergroup_test = new DO_UserGroup( // //new DBConnection( // // DBServerTypes.SQLServer, // // "server=127.0.0.1;uid=sa;pwd=passpub;database=OGen-NTier_UTs;" // //) //); //_usergroup_test.IDGroup = 1; //_usergroup_test.IDUser = 1; //_usergroup_test.Relationdate_isNull = true; //_usergroup_test.Defaultrelation_isNull = true; //_usergroup_test.setObject(true); //OGen.NTier.UTs.lib.datalayer.UTs.UT__utils _ut_utils // = new OGen.NTier.UTs.lib.datalayer.UTs.UT__utils(); //_ut_utils.TestFixtureSetUp(); //_ut_utils.UT_Check_DataObjects_integrity(); //return; //OGen.NTier.UTs.lib.datalayer.UTs.UT_User _ut_user // = new OGen.NTier.UTs.lib.datalayer.UTs.UT_User(); //_ut_user.TestFixtureSetUp(); //_ut_user.UT_hasChanges(); //return; //OGen.NTier.UTs.lib.datalayer.UTs.UT_UserGroup // _ut_usergroup = new OGen.NTier.UTs.lib.datalayer.UTs.UT_UserGroup(); //_ut_usergroup.TestFixtureSetUp(); //_ut_usergroup.UT_bugPostgreSQL_noFunctionMatchesTheGivenNameAndArgumentTypes(); ////_ut_usergroup.UT_NullableFields(); //return; //DO_Config _config_test = new DO_Config(); //_config_test.Connection.Open(); //_config_test.Connection.Transaction.Begin(); //_config_test.Fields.Name = "test"; //_config_test.Fields.Description = "test"; //_config_test.Fields.Config = "test"; //_config_test.Fields.Type = 1; //try { // _config_test.setObject(true); // Console.WriteLine("ok"); //} catch { // Console.WriteLine("ko"); //} //_config_test.Connection.Transaction.Rollback(); //_config_test.Connection.Transaction.Terminate(); //_config_test.Connection.Close(); //_config_test.Dispose(); //return; const int _cycles = 50; DBConnection[] _cons = new DBConnection[] { #region new DBConnection(DBServerTypes.SQLServer, ...), DBConnectionsupport.CreateInstance( DBServerTypes.SQLServer, DBUtilssupport.GetInstance(DBServerTypes.SQLServer).ConnectionString.Build( "127.0.0.1", "sa", "passpub", "OGen-NTier_UTs" ) ), #endregion #region new DBConnection(DBServerTypes.PostgreSQL, ...) DBConnectionsupport.CreateInstance( DBServerTypes.PostgreSQL, DBUtilssupport.GetInstance(DBServerTypes.PostgreSQL).ConnectionString.Build( "127.0.0.1", "postgres", "passpub", "OGen-NTier_UTs" ) ) #endregion //#region new DBConnection(DBServerTypes.MySQL, ...) //, DBConnectionsupport.CreateInstance( // DBServerTypes.MySQL, // DBUtilssupport.GetInstance(DBServerTypes.MySQL).ConnectionString.Build( // "127.0.0.1", // "root", // "passpub", // "OGen-NTier_UTs" // ) //) //#endregion }; long _conter = 0L; for (int _compiled = 0; _compiled < 2; _compiled++) { for (int _con = 0; _con < _cons.Length; _con++) { _cons[_con].Open(); _cons[_con].Transaction.Begin(); for (int _cached = 0; _cached < 2; _cached++) { DO_Config _config = new DO_Config(_cons[_con]); #region _config.setObject(); _conter = DateTime.Now.Ticks; for (int c = 0; c < _cycles; c++) { _config.Fields.Name = c.ToString(); _config.Fields.Config = "DELETE THIS, IT IS A TEST"; _config.Fields.Type = 2; _config.setObject(true); } Console.WriteLine( "setObject() \t{0}\tcached:{1}\tcompiled:{2}\t{3}", DBConnectionsupport.GetDBServerType(_cons[_con]), (_cached == 1), (_compiled == 1), (DateTime.Now.Ticks - _conter).ToString() ); #endregion #region _config.Record.Open_...(false); _conter = DateTime.Now.Ticks; _config.Record.Open_all(); while (_config.Record.Read()) { ; } _config.Record.Close(); Console.WriteLine( "Record.Open() \t{0}\tcached:{1}\tcompiled:{2}\t{3}", DBConnectionsupport.GetDBServerType(_cons[_con]), (_cached == 1), (_compiled == 1), (DateTime.Now.Ticks - _conter).ToString() ); #endregion #region _config.delObject(); _conter = DateTime.Now.Ticks; _config.Record.Open_all(); while (_config.Record.Read()) { if (_config.Fields.Config == "DELETE THIS, IT IS A TEST") { _config.delObject(); } } _config.Record.Close(); Console.WriteLine( "delObject() \t{0}\tcached:{1}\tcompiled:{2}\t{3}", DBConnectionsupport.GetDBServerType(_cons[_con]), (_cached == 1), (_compiled == 1), (DateTime.Now.Ticks - _conter).ToString() ); #endregion #region _config.getObject(); _conter = DateTime.Now.Ticks; _config.Fields.Name = "SomeIntConfig"; _config.Fields.Config = "1245"; _config.Fields.Type = 4; _config.setObject(true); for (int c = 0; c < _cycles; c++) { _config.getObject("SomeIntConfig"); } Console.WriteLine( "getObject() \t{0}\tcached:{1}\tcompiled:{2}\t{3}", DBConnectionsupport.GetDBServerType(_cons[_con]), (_cached == 1), (_compiled == 1), (DateTime.Now.Ticks - _conter).ToString() ); #endregion _config.Dispose(); _config = null; //--- DO_User _do_user = new DO_User(_cons[_con]); #region _do_user.insObject(); _conter = DateTime.Now.Ticks; for (int c = 0; c < _cycles; c++) { bool _constraint; _do_user.Fields.Login = c.ToString(); _do_user.Fields.Password = "******"; _do_user.insObject(true, out _constraint); } _do_user.Record.Open_all(); while (_do_user.Record.Read()) { if (_do_user.Fields.Password == "DELETE THIS, IT IS A TEST") { _do_user.delObject(); } } _do_user.Record.Close(); Console.WriteLine( "insObject() \t{0}\tcached:{1}\tcompiled:{2}\t{3}", DBConnectionsupport.GetDBServerType(_cons[_con]), (_cached == 1), (_compiled == 1), (DateTime.Now.Ticks - _conter).ToString() ); #endregion _conter = DateTime.Now.Ticks; for (int c = 0; c < _cycles; c++) { if (!_do_user.isObject_byLogin("fmonteiro")) { bool _constraint; _do_user.Fields.Login = "******"; _do_user.Fields.Password = "******"; _do_user.insObject(true, out _constraint); } _do_user.getObject_byLogin("fmonteiro"); } Console.WriteLine( "getObject_by() \t{0}\tcached:{1}\tcompiled:{2}\t{3}", DBConnectionsupport.GetDBServerType(_cons[_con]), (_cached == 1), (_compiled == 1), (DateTime.Now.Ticks - _conter).ToString() ); _do_user.Dispose(); _do_user = null; } _cons[_con].Transaction.Rollback(); _cons[_con].Transaction.Terminate(); _cons[_con].Close(); } } Console.WriteLine("Press any key to continue..."); Console.ReadLine(); }
private void ToEditMode(int reqID) { trOptions.Visible = true; chblOptions.Enabled = true; drpLocation.Enabled = false; RequestHandler reqH = new RequestHandler(); RequestFR req = reqH.GetRequestDetails(reqID); CategoryHandler cth = new CategoryHandler(); catlist = cth.GetCategoryList(); drpCategory.DataSource = catlist; drpCategory.DataTextField = "name"; drpCategory.DataValueField = "ID"; drpCategory.DataBind(); drpCategory.Items.Insert(0, "انتخاب کنید"); drpCategory.Items.FindByValue(req.CatID.ToString()).Selected = true; OptionHandler opt = new OptionHandler(); optlist = opt.GetOptionListByCatID(req.CatID); chblOptions.DataSource = optlist; chblOptions.DataTextField = "name"; chblOptions.DataValueField = "ID"; chblOptions.DataBind(); List <Req_Opt_Junc> res_opt_junlist = new List <Req_Opt_Junc>(); Req_Opt_JuncHandler rsopt = new Req_Opt_JuncHandler(); res_opt_junlist = rsopt.GetReq_Opt_JuncListByReqID(reqID); if (res_opt_junlist != null) { for (int i = 0; i < res_opt_junlist.Count; i++) { if (res_opt_junlist[i].IsActive == true) { chblOptions.Items.FindByValue(res_opt_junlist[i].Opt_id.ToString()).Selected = true; } } } RC_UserHandler usrh = new RC_UserHandler(); RC_User ostad = usrh.Get_Ostad_Details(req.IssuerID); drpProfessor.Items.Insert(0, ostad.Name); drpProfessor.Enabled = false; CourseHandler corH = new CourseHandler(); courselist = corH.GetCourseListByUserID(req.IssuerID); drpCourse.DataSource = courselist; drpCourse.DataTextField = "name"; drpCourse.DataValueField = "DID"; drpCourse.DataBind(); if (req.CourseName == "درخواست جلسه") { Session["isMeeting"] = true; } else { Session["isMeeting"] = false; } if ((bool)Session["isMeeting"]) { trProfCrs.Visible = false; } LocationHandler locH = new LocationHandler(); drpLocation.DataSource = locH.GetLocationListByCatID(Convert.ToInt32(drpCategory.SelectedValue)); drpLocation.DataTextField = "name"; drpLocation.DataValueField = "ID"; drpLocation.DataBind(); drpLocation.Items.FindByText(req.Location).Selected = true; txtCapacity.Text = req.Capacity.ToString(); txtDescription.Text = req.Note; if (req.CourseDID != 0) { drpCourse.Items.FindByValue(req.CourseDID.ToString()).Selected = true; } var datetimelist = req.DateTimeRange; //Set a Time and Date of Request var requestStartTime = datetimelist.FirstOrDefault(c => c.StartTime != 0); if (requestStartTime != null) { var startTime = TimeSpan.FromTicks(requestStartTime.StartTime); RadTimePicker1.SelectedTime = startTime; } var requestEndTime = datetimelist.FirstOrDefault(c => c.StartTime != 0); if (requestEndTime != null) { var endTime = TimeSpan.FromTicks(requestEndTime.EndTime); RadTimePicker2.SelectedTime = endTime; } var requestDateTime = datetimelist.FirstOrDefault(c => c.StartTime != 0); if (requestDateTime != null) { pcal1.Text = requestDateTime.Date; } if (datetimelist.Count > 1) { chbRepeat.Checked = true; dvEndDate.Visible = true; string scrp2 = "var objCal1 = new AMIB.persianCalendar('ContentPlaceHolder1_pcal2', {extraInputID: 'ContentPlaceHolder1_pcal2',extraInputFormat: 'yyyy/mm/dd'}); "; ScriptManager.RegisterStartupScript(this, GetType(), ClientID, scrp2, true); var listOfDay = new List <string>(); foreach (RequestDateTime dateTime in datetimelist.OrderBy(c => c.Date)) { var dateSplit = dateTime.Date.Split('/'); var d = new DateTime(Convert.ToInt32(dateSplit[0]), Convert.ToInt32(dateSplit[1]), Convert.ToInt32(dateSplit[2]), new PersianCalendar()); listOfDay.Add(d.DayOfWeek.ToString()); } var listOfDayforRequest = listOfDay.Distinct(); var lastOrDefault = datetimelist.OrderBy(d => d.Date).LastOrDefault(); if (lastOrDefault != null) { var endDateRequest = lastOrDefault.Date; pcal2.Text = endDateRequest; } foreach (var day in listOfDayforRequest) { switch (day) { case "Friday": chblWeekDates.Items[6].Selected = true; break; case "Saturday": chblWeekDates.Items[0].Selected = true; break; case "Sunday": chblWeekDates.Items[1].Selected = true; break; case "Monday": chblWeekDates.Items[2].Selected = true; break; case "Tuesday": chblWeekDates.Items[3].Selected = true; break; case "Wednesday": chblWeekDates.Items[4].Selected = true; break; case "Thursday": chblWeekDates.Items[5].Selected = true; break; } } } grdOldDateTime.DataSource = datetimelist.OrderBy(d => d.Date); grdOldDateTime.DataBind(); btnEditRequest.Enabled = true; btnEditRequest.Visible = true; if (drpCategory.SelectedIndex == 1) { txtCapacity.Text = 1.ToString(); txtCapacity.ReadOnly = true; } }
protected void btnEditRequest_Click(object sender, EventArgs e) { if (Page.IsValid) { RequestFR req = new RequestFR(); RequestHandler rqH = new RequestHandler(); req = rqH.GetRequestDetails(reqID); req.CatID = Convert.ToInt32(drpCategory.SelectedValue); RC_User user = new RC_User(); RC_UserHandler us = new RC_UserHandler(); user = us.Get_Ostad_Details(req.IssuerID); req.Subject = "nosub"; req.Note = txtDescription.Text; req.Location = drpLocation.SelectedValue; if (chbRepeat.Checked == false) { if (CheckReqDate(pcal1.Text)) { RequestDateTime rdt = new RequestDateTime(); rdt.Date = pcal1.Text; rdt.StartTime = RadTimePicker1.SelectedTime.Value.Ticks; rdt.EndTime = RadTimePicker2.SelectedTime.Value.Ticks; rdt.RequestId = req.ID; req.DateTimeRange = new List <RequestDateTime>(); req.DateTimeRange.Add(rdt); } else { string scrp = "تاریخ درخواست باید بعد از تاریخ امروز باشد."; RadWindowManager1.RadAlert(scrp, 300, 100, "خطا", ""); //ScriptManager.RegisterStartupScript(this, this.GetType(), "alert", scrp, true); return; } } else { if (CheckReqDate(pcal1.Text) && CheckReqDate(pcal2.Text)) { req.DateTimeRange = FillRequestDateTime(pcal1.Text, pcal2.Text, RadTimePicker1.SelectedTime, RadTimePicker2.SelectedTime, chblWeekDates, req.ID); } else { string scrp = "تاریخ درخواست باید بعد از تاریخ امروز باشد.";//باید این پیام عوض شود. RadWindowManager1.RadAlert(scrp, 300, 100, "خطا", ""); //ScriptManager.RegisterStartupScript(this, this.GetType(), "alert", scrp, true); return; } } req.IssuerID = user.ID; req.IssuerName = user.Name; if ((bool)Session["isMeeting"]) { trProfCrs.Visible = false; } CourseHandler corH = new CourseHandler(); courselist = corH.GetCourseListByUserID(user.ID); int coursedid = Convert.ToInt32(drpCourse.SelectedValue); req.Capacity = courselist.Find(i => i.DID == coursedid).Capacity; req.CourseName = drpCourse.SelectedItem.ToString(); req.DaneshID = courselist.Find(i => i.DID == coursedid).DaneshID; req.CourseDID = coursedid; req.Capacity = Convert.ToInt32(txtCapacity.Text); req.Issue_time = DateTime.Now.ToPeString(); if (CheckReqDate(pcal1.Text)) { //req.Sessiondate = pcal1.Text; } else { string scrp = "تاریخ درخواست باید بعد از تاریخ امروز باشد"; RadWindowManager1.RadAlert(scrp, 300, 100, "خطا", ""); return; } optlist = new List <Option>(); foreach (ListItem item in chblOptions.Items) { Option optstat = new Option(); optstat.ID = Convert.ToInt32(item.Value); optstat.Name = item.Text; optstat.IsActive = item.Selected; optlist.Add(optstat); } if (RequestHandler.IsNotSpecifiedDay(DayOfWeek.Friday, req.DateTimeRange)) { string scrp = "در روز جمعه امکان برگزاری وجود ندارد"; RadWindowManager1.RadAlert(scrp, 300, 100, "خطا", ""); return; } try { RequestHandler rq = new RequestHandler(); req.Status = 1;//sent int reqid = rq.EditRequest(req, optlist); var commanBusiness = new CommonBusiness(); userID = Convert.ToInt32(Session[sessionNames.userID_Karbar]); commanBusiness.InsertIntoUserLog(userID, "", 11, 115, "تایید آموزش درخواست رزرواسیون", reqid); var address = ViewState["GoBackTo"].ToString(); string resdirectFunc = "function redirectToLast(){ window.location= '" + address + "' ; }"; string scrp = "درخواست شما با شماره " + reqid.ToString() + " با موفقیت ویرایش و ثبت گردید"; RadWindowManager1.RadAlert(scrp, 300, 100, "پیام سیستم", resdirectFunc); } catch (Exception) { throw; } } }