//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;
}
}
}
