protected void RadScheduler1_AppointmentContextMenuItemClicked(object sender, AppointmentContextMenuItemClickedEventArgs e)
{
try
{
if ((e.MenuItem.Value == "Create") && (e.Appointment.Attributes["Annotations"] == "Appointment"))
{
if (DateTime.Now.Day < e.Appointment.Start.Day && DateTime.Now.Month <= int.Parse(Session["MonthID"].ToString()))
{
return;
}
Session["IsEditCall"] = 0;
Session["PlannedVisitID"] = int.Parse(e.Appointment.ID.ToString());
Session["PlannedVisitDate"] = e.Appointment.Start;
Session["IsDoubleVisit"] = -1;
if (e.Appointment.Resources.GetResourceByType("Affiliation") == null || e.Appointment.Resources.GetResourceByType("Affiliation") != null)
{
con = new SqlConnection(System.Configuration.ConfigurationManager.ConnectionStrings["AmounCrmConnectionString"].ToString());
//string s = "Select Distinct AffiliationID, AreaRecID From View_ListOfAppointments_Admin WHERE AppointmentID = " + int.Parse(e.Appointment.ID.ToString());
string s = "Select Distinct AffiliationID, SpecialtyID From View_Appointments_Scheduler WHERE AppointmentID = " + int.Parse(e.Appointment.ID.ToString());
cmd = new SqlCommand(s, con);
con.Open();
SqlDataReader dr = cmd.ExecuteReader();
if (dr.HasRows)
{
while (dr.Read())
{
Session["ParticipantID"] = dr["AffiliationID"].ToString();
Session["SpecialtyID"] = dr["SpecialtyID"].ToString();
}
}
dr.Close();
}
//else
//{
// Session["ParticipantID"] = e.Appointment.Resources.GetResourceByType("Affiliation").Key.ToString();
//}
int aaa = 1; int bbb = 0;
if (aaa == bbb)
{
ScriptManager.RegisterStartupScript(Page, typeof(Page), "OpenWindow", "window.open('CallsEntry.aspx');", true);
}
else
{
ScriptManager.RegisterStartupScript(Page, typeof(Page), "OpenWindow", "window.open('Calls2.aspx');", true);
}
}
if ((e.MenuItem.Value == "Create") && (e.Appointment.Attributes["Annotations"] != "Appointment"))
{
Label1.Text = "Alert!" + "<br />" + "This Visit Already Created";
RadWindowManager1.RadAlert("Duplicate Visits <br /> This Appointment Has a Corresponding Visit", 400, 200, "Alert!", null, "");
}
if (e.MenuItem.Value == "EditCall" && e.Appointment.Attributes["Annotations"] == "Created")
{
if (DateTime.Now.Day < e.Appointment.Start.Day)
{
return;
}
Session["IsEditCall"] = 1;
Session["PlannedVisitID"] = int.Parse(e.Appointment.ID.ToString());
Session["PlannedVisitDate"] = e.Appointment.Start;
Session["IsDoubleVisit"] = 0;
if (e.Appointment.Resources.GetResourceByType("Affiliation") == null || e.Appointment.Resources.GetResourceByType("Affiliation") != null)
{
con = new SqlConnection(System.Configuration.ConfigurationManager.ConnectionStrings["AmounCrmConnectionString"].ToString());
//string s = "Select Distinct AffiliationID, AreaRecID From View_ListOfAppointments_Admin WHERE AppointmentID = " + int.Parse(e.Appointment.ID.ToString());
string s = "Select Distinct AffiliationID, SpecialtyID, IsDoubleVisit From View_Appointments_Scheduler WHERE AppointmentID = " + int.Parse(e.Appointment.ID.ToString());
cmd = new SqlCommand(s, con);
con.Open();
SqlDataReader dr = cmd.ExecuteReader();
if (dr.HasRows)
{
while (dr.Read())
{
Session["ParticipantID"] = dr["AffiliationID"].ToString();
Session["SpecialtyID"] = dr["SpecialtyID"].ToString();
Session["IsDoubleVisit"] = dr["IsDoubleVisit"].ToString();
}
}
dr.Close();
}
//else
//{
// Session["ParticipantID"] = e.Appointment.Resources.GetResourceByType("Affiliation").Key.ToString();
//}
int aaa = 1; int bbb = 0;
if (aaa == bbb)
{
ScriptManager.RegisterStartupScript(Page, typeof(Page), "OpenWindow", "window.open('CallsEntry.aspx');", true);
}
else
{
ScriptManager.RegisterStartupScript(Page, typeof(Page), "OpenWindow", "window.open('Calls2.aspx');", true);
}
}
if (e.MenuItem.Value == "EditCall" && e.Appointment.Attributes["Annotations"] != "Created")
{
Session["IsEditCall"] = 0;
Label1.Text = "Alert!" + "<br />" + "This appointment was finally saved or you did not creat a call for it";
RadWindowManager1.RadAlert("This appointment was finally saved or you did not creat a call for it", 400, 200, "Alert!", null, "");
}
if (e.MenuItem.Value == "DisplayCall" && e.Appointment.Attributes["Annotations"] != "Appointment")
{
Session["IsEditCall"] = 2;
Session["IsFinal"] = e.Appointment.Attributes["Annotations"];
Session["PlannedVisitID"] = int.Parse(e.Appointment.ID.ToString());
Session["PlannedVisitDate"] = e.Appointment.Start;
Session["IsDoubleVisit"] = 0;
if (e.Appointment.Resources.GetResourceByType("Affiliation") == null || e.Appointment.Resources.GetResourceByType("Affiliation") != null)
{
con = new SqlConnection(System.Configuration.ConfigurationManager.ConnectionStrings["AmounCrmConnectionString"].ToString());
//string s = "Select Distinct AffiliationID, AreaRecID From View_ListOfAppointments_Admin WHERE AppointmentID = " + int.Parse(e.Appointment.ID.ToString());
string s = "Select Distinct AffiliationID, SpecialtyID, LineID, IsDoubleVisit From View_Appointments_Scheduler WHERE AppointmentID = " + int.Parse(e.Appointment.ID.ToString());
cmd = new SqlCommand(s, con);
con.Open();
SqlDataReader dr = cmd.ExecuteReader();
if (dr.HasRows)
{
while (dr.Read())
{
Session["ParticipantID"] = dr["AffiliationID"].ToString();
Session["SpecialtyID"] = dr["SpecialtyID"].ToString();
Session["LineID_Sch"] = dr["LineID"].ToString();
Session["IsDoubleVisit"] = dr["IsDoubleVisit"].ToString();
}
}
dr.Close();
}
//else
//{
// Session["ParticipantID"] = e.Appointment.Resources.GetResourceByType("Affiliation").Key.ToString();
//}
int aaa = 1; int bbb = 0;
if (aaa == bbb)
{
ScriptManager.RegisterStartupScript(Page, typeof(Page), "OpenWindow", "window.open('CallsEntry.aspx');", true);
}
else
{
ScriptManager.RegisterStartupScript(Page, typeof(Page), "OpenWindow", "window.open('Calls2.aspx');", true);
}
}
if (e.MenuItem.Value == "DisplayCall" && e.Appointment.Attributes["Annotations"] == "Appointment")
{
Label1.Text = "Error" + "<br />" + "This appointment has no corresponding call";
RadWindowManager1.RadAlert("This appointment has no corresponding call", 400, 200, "Alert!", null, "");
}
if ((e.MenuItem.Value == "CommandDelete" || e.MenuItem.Value == "CommandEdit") && e.Appointment.Attributes["Annotations"] != "Appointment")
{
return;
}
}
catch (Exception ex)
{
Label1.Text = ex.Message;
RadWindowManager1.RadAlert(ex.Source + "<br />" + ex.Message, 400, 200, "Alert!", null, "");
}
}
protected void RadToolBar1_ButtonClick(object sender, RadToolBarEventArgs e)
{
switch (e.Item.Value)
{
case "Save":
if (idDaoTao == null)
{
DaoTao dt = new DaoTao();
dt.IDNhanVien = (int)Session["idNV"];
dt.IDTrinhDo = Convert.ToInt32(cboTrinhDo.SelectedValue);
dt.IDLoaiHinh = Convert.ToInt32(cboLoaiHinh.SelectedValue);
dt.IDNoiCapBang = Convert.ToInt32(cboNoiDT.SelectedValue);
dt.TuNgay = txtTuNgay.SelectedDate;
dt.DenNgay = txtDenNgay.SelectedDate;
dt.IDChuyenNganh = Convert.ToInt32(cboChuyenNganh.SelectedValue);
dt.IDLoaiBangDT = Convert.ToInt32(cboLoaiBang.SelectedValue);
dt.Anh = imgdata;
dt.Type = 0; // Type = 0 là loại bằng cấp
dt.NgayTao = dt.NgayCapNhat = DateTime.Now;
dt.NguoiTao = dt.NguoiCapNhat = idUser;
_entities.AddToDaoTaos(dt);
try
{
_entities.SaveChanges();
grvDaoTao.Rebind();
RadWindowManager1.RadAlert("Thêm thông tin thành công", 285, 100, "Thông báo", null);
}
catch (Exception ex)
{
RadWindowManager1.RadAlert("Thêm thông tin thất bại", 285, 100, "Lỗi", null);
throw ex;
}
}
else
{
DaoTao daoTao = _entities.DaoTaos.Where(d => d.IDDaoTao == idDaoTao).FirstOrDefault();
daoTao.IDTrinhDo = Convert.ToInt32(cboTrinhDo.SelectedValue);
daoTao.IDLoaiHinh = Convert.ToInt32(cboLoaiHinh.SelectedValue);
daoTao.IDNoiCapBang = Convert.ToInt32(cboNoiDT.SelectedValue);
daoTao.TuNgay = txtTuNgay.SelectedDate;
daoTao.DenNgay = txtDenNgay.SelectedDate;
daoTao.IDChuyenNganh = Convert.ToInt32(cboChuyenNganh.SelectedValue);
daoTao.IDLoaiBangDT = Convert.ToInt32(cboLoaiBang.SelectedValue);
daoTao.Type = 0;// Type = 0 là loại bằng cấp
daoTao.Anh = imgdata;
daoTao.NgayCapNhat = DateTime.Now;
daoTao.NguoiCapNhat = idUser;
try
{
_entities.SaveChanges();
grvDaoTao.Rebind();
RadWindowManager1.RadAlert("Sửa thông tin thành công", 285, 100, "Thông báo", null);
}
catch (Exception ex)
{
RadWindowManager1.RadAlert("Sửa thông tin thất bại", 285, 100, "Lỗi", null);
throw ex;
}
}
break;
case "Reset":
cboTrinhDo.SelectedIndex = -1;
cboLoaiHinh.SelectedIndex = -1;
cboNoiDT.SelectedIndex = -1;
txtTuNgay.Clear();
txtDenNgay.Clear();
cboChuyenNganh.SelectedIndex = -1;
cboLoaiBang.SelectedIndex = -1;
upAnh.UploadedFiles.Clear();
AnhScan.ImageUrl = "../Images/no_photo.jpg";
idDaoTao = null;
break;
}
}
/// <summary>
/// Saves this instance.
/// </summary>
public bool Save()
{
if (!access.Write)
{
return(false);
}
var contact = _dataManager.Contact.SelectById(SiteId, ContactId) ?? new tbl_Contact();
if (contact.UserFullName != txtUserFullName.Text || !contact.IsNameChecked)
{
var nameChecker = new NameChecker(ConfigurationManager.AppSettings["ADONETConnectionString"]);
var nameCheck = nameChecker.CheckName(txtUserFullName.Text, NameCheckerFormat.FIO, Correction.Correct);
if (!string.IsNullOrEmpty(nameCheck))
{
contact.UserFullName = nameCheck;
contact.Surname = nameChecker.Surname;
contact.Name = nameChecker.Name;
contact.Patronymic = nameChecker.Patronymic;
contact.IsNameChecked = nameChecker.IsNameCorrect;
}
else
{
contact.UserFullName = txtUserFullName.Text;
contact.Name = string.Empty;
contact.Surname = string.Empty;
contact.Patronymic = string.Empty;
contact.IsNameChecked = false;
}
}
else
{
contact.IsNameChecked = imgbtnOk.Visible;
}
contact.ContactTypeID = ddlContactType.SelectedValue != string.Empty ? (Guid?)Guid.Parse(ddlContactType.SelectedValue) : null;
contact.StatusID = _dataManager.Status.SelectDefault(CurrentUser.Instance.SiteID).ID;
contact.OwnerID = ucOwner.SelectedValue;
contact.CompanyID = ucCompany.SelectedValue;
contact.JobTitle = txtJobTitle.Text;
contact.ContactFunctionInCompanyID = ddlFunctionInCompany.SelectedValue != string.Empty ? (Guid?)Guid.Parse(ddlFunctionInCompany.SelectedValue) : null;
contact.ContactJobLevelID = ddlJobLevel.SelectedValue != string.Empty ? (Guid?)Guid.Parse(ddlJobLevel.SelectedValue) : null;
contact.Phone = txtPhone.Text;
contact.CellularPhone = txtCellularPhone.Text;
contact.CellularPhoneStatusID = int.Parse(ddlCellularPhoneStatus.SelectedValue);
contact.Email = txtEmail.Text;
if (ddlEmailStatus.SelectedValue.ToInt() != (int)EmailStatus.Banned ||
CurrentUser.Instance.AccessLevelID == (int)AccessLevel.SystemAdministrator || CurrentUser.Instance.AccessLevelID == (int)AccessLevel.Administrator)
{
contact.EmailStatusID = int.Parse(ddlEmailStatus.SelectedValue);
}
contact.AddressID = ucPostalAddress.Save();
contact.RefferID = ucReffer.SelectedValue;
contact.Comment = txtComment.Text;
if (rdpBirthday.SelectedDate != null)
{
contact.BirthDate = rdpBirthday.SelectedDate;
}
if (dcbAdvertisingPlatform.SelectedIdNullable.HasValue)
{
contact.AdvertisingPlatformID = dcbAdvertisingPlatform.SelectedIdNullable;
}
else if (!string.IsNullOrEmpty(dcbAdvertisingPlatform.Text) && !string.Equals(dcbAdvertisingPlatform.EmptyItemText, dcbAdvertisingPlatform.Text, StringComparison.OrdinalIgnoreCase))
{
var advertisingPlatform = _dataManager.AdvertisingPlatform.SelectByTitle(CurrentUser.Instance.SiteID, dcbAdvertisingPlatform.Text);
if (advertisingPlatform == null)
{
advertisingPlatform = new tbl_AdvertisingPlatform {
SiteID = CurrentUser.Instance.SiteID
};
advertisingPlatform.Code = advertisingPlatform.Title = dcbAdvertisingPlatform.Text;
_dataManager.AdvertisingPlatform.Add(advertisingPlatform);
}
contact.AdvertisingPlatformID = advertisingPlatform.ID;
}
if (dcbAdvertisingCampaign.SelectedIdNullable.HasValue)
{
contact.AdvertisingCampaignID = dcbAdvertisingCampaign.SelectedIdNullable;
}
else if (!string.IsNullOrEmpty(dcbAdvertisingCampaign.Text) && !string.Equals(dcbAdvertisingCampaign.EmptyItemText, dcbAdvertisingCampaign.Text, StringComparison.OrdinalIgnoreCase))
{
var advertisingCampaign = _dataManager.AdvertisingCampaign.SelectByTitle(CurrentUser.Instance.SiteID, dcbAdvertisingCampaign.Text);
if (advertisingCampaign == null)
{
advertisingCampaign = new tbl_AdvertisingCampaign {
SiteID = CurrentUser.Instance.SiteID
};
advertisingCampaign.Code = advertisingCampaign.Title = dcbAdvertisingCampaign.Text;
_dataManager.AdvertisingCampaign.Add(advertisingCampaign);
}
contact.AdvertisingCampaignID = advertisingCampaign.ID;
}
if (dcbAdvertisingType.SelectedIdNullable.HasValue)
{
contact.AdvertisingTypeID = dcbAdvertisingType.SelectedIdNullable;
}
else if (!string.IsNullOrEmpty(dcbAdvertisingType.Text) && !string.Equals(dcbAdvertisingType.EmptyItemText, dcbAdvertisingType.Text, StringComparison.OrdinalIgnoreCase))
{
var advertisingType = _dataManager.AdvertisingType.SelectByTitle(CurrentUser.Instance.SiteID, dcbAdvertisingType.Text);
if (advertisingType == null)
{
advertisingType = new tbl_AdvertisingType {
SiteID = CurrentUser.Instance.SiteID
};
advertisingType.Code = advertisingType.Title = dcbAdvertisingType.Text;
_dataManager.AdvertisingType.Add(advertisingType);
}
contact.AdvertisingTypeID = advertisingType.ID;
}
if (contact.ID == Guid.Empty)
{
contact.SiteID = SiteId;
contact.RefferURL = string.Empty;
contact.UserIP = string.Empty;
contact.OwnerID = CurrentUser.Instance.ContactID;
_dataManager.Contact.Add(contact);
ContactId = contact.ID;
}
else
{
_dataManager.Contact.Update(contact);
}
if (!ucCompany.SelectedValue.HasValue && !string.IsNullOrEmpty(ucCompany.Text))
{
Session["UpdatedContactId"] = contact.ID;
Session["CompanyTitle"] = ucCompany.Text;
RadWindowManager1.RadConfirm("Создать новую компанию?", "confirmCallBackFn", 400, 100, null, "Создание компании");
return(false);
}
return(true);
}
protected void btnRegister_OnClick(object sender, EventArgs e)
{
string message;
if (!Page.IsValid)
{
return; //اینجا باید رد الرت باشه
}
var defenceInformation = _requestHandler.GetDefenceInformation(txtStCode.Text);
var request = new StudentDefenceRequest
{
CategoryId = (int)IAUEC_Apps.DTO.ResourceControlClasses.Category.InPersonClass,
Subject = StudentDefenceRequest.StaticStudentRequest().Subject,
Location = ((int)IAUEC_Apps.DTO.ResourceControlClasses.Location.Raam).ToString(),
Status = (int)RequestStatus.submitted,
IssuerId = Convert.ToInt32(txtStCode.Text),
IssuerName = defenceInformation.StudentFullName,
Capacity = StudentDefenceRequest.StaticStudentRequest().Capacity,
DefenceSubject = defenceInformation.DefenceSubject,
DaneshId = Convert.ToInt32(defenceInformation.CollegeId),
CourseName = defenceInformation.DefenceSubject,
RequestDate = txtDate.Text,
RequestStartTime = txtTime.SelectedTime.Value.Ticks,
OnlineTeacherRole = ckbAprroveOnline.Checked ? drpRoleTeacher.SelectedValue : string.Empty,
OnlineFirstTeacherName = ckbAprroveOnline.Checked && rcbOnlineTeacher.Items[0].Checked ? rcbOnlineTeacher.Items[0].Text : string.Empty,
OnlineFirstTeacherId = ckbAprroveOnline.Checked && rcbOnlineTeacher.Items[0].Checked ? rcbOnlineTeacher.Items[0].Value.Substring(3) : string.Empty,
// = ckbAprroveOnline.Checked ? drpRoleTeacher.SelectedItem.Text : string.Empty,
UseOwnPc = rdbOwnSystem.Checked,
UserId = Session[sessionNames.userName_Karbar].ToString(),
Gender = defenceInformation.studentGender
};
if (rcbOnlineTeacher.Items.Count > 1)
{
request.OnlineSecondTeacherName = ckbAprroveOnline.Checked && rcbOnlineTeacher.Items[1].Checked
? rcbOnlineTeacher.Items[1].Text
: string.Empty;
request.OnlineSecondTeacherId = ckbAprroveOnline.Checked && rcbOnlineTeacher.Items[1].Checked
? rcbOnlineTeacher.Items[1].Value.Substring(3)
: string.Empty;
}
request.RequestEndTime = request.RequestStartTime + _requestHandler.GetDefenceInMeetingLength(Convert.ToInt32(defenceInformation.CollegeId));
request.AcceptPropDate = defenceInformation.GroupAcceptDate;
int reqId = 0;
request.IsRequestEducation = true;
message = _requestHandler.CreateStudentRequestForEducationV2(out reqId, request);
if (message.Contains("ok"))
{
defenceInformation.RequestDate = request.RequestDate;
defenceInformation.StartTime = request.RequestStartTime;
defenceInformation.EndTime = request.RequestEndTime;
string scrp = message.Substring(2);
//PrevPage = ViewState["PrevPage"].ToString();
//var uri = Request.UrlReferrer.ToString();
//PrevPage = uri.ToLower().Replace("educationaddrequest.aspx", "EducationStudentReview.aspx");
var userID = Convert.ToInt32(Session[sessionNames.userID_Karbar]);
var comman = new CommonBusiness();
comman.InsertIntoUserLog(userID, DateTime.Now.ToString("HH:mm"), 11, 171, string.Format("{0}", "ثبت درخواست جلسه دفاع توسط دانشکده"), reqId /*Convert.ToInt32(request.Id)*/);
//CommonBusiness CommonBusiness = new CommonBusiness();
//CommonBusiness.InsertIntoStudentLogReservation(Session[sessionNames.userID_StudentOstad].ToString(), DateTime.Now.ToString("HH:mm"), 11, 40, "ثبت درخواست رزرو جلسه دفاع توسط دانشجو", reqId);
string address = "../Forms/EducationStudentReview.aspx" + "?id=" + generaterandomstr() + "@A" + "0" + "-" + generaterandomstr();
string resdirectFunc = "function redirectToLast(){ window.location= '" + address + "' ; }";
RadWindowManager1.RadAlert(scrp, 500, 100, "پیام سیستم", resdirectFunc);
}
else
{
RadWindowManager1.RadAlert(message, 500, 100, "خطا", "");
}
}
protected void btnSave_Click(object sender, EventArgs e)
{
if (txtSubject.Text != "" && dpStartDate.SelectedDate != null && dpEndDate.SelectedDate != null && txtMsgDescription.Text != "")
{
if (dpEndDate.SelectedDate < dpStartDate.SelectedDate)
{
lblMsgMessage.Text = "Invalid End Date,it must be greater than Start Date";
return;
}
string newline = txtMsgDescription.Text;
string lines = string.Join(Environment.NewLine, newline.Split()
.Select((word, index) => new { word, index })
.GroupBy(x => x.index / 9)
.Select(grp => string.Join(" ", grp.Select(x => x.word))));
string lines2 = lines.Replace("\r\n", "<br />");
if (ddlMsgType.SelectedValue == "1")
{
con.Open();
SqlCommand cmd = new SqlCommand("insert into [AmounCRM2].[dbo].[CRM_Messages_Master] (CRM_MessageName,CRM_MessageDescription,StartDate,EndDate,CRM_MessageType) values (N'" + txtSubject.Text + "', N'" + lines2 + "','" + dpStartDate.SelectedDate.Value.ToString("M/dd/yyyy") + "','" + dpEndDate.SelectedDate.Value.ToString("M/dd/yyyy") + "'," + ddlMsgType.SelectedValue + ")", con);
cmd.ExecuteNonQuery();
SqlCommand cmd2 = new SqlCommand("select max(CRM_MessageID) from [AmounCRM2].[dbo].[CRM_Messages_Master]");
cmd2.CommandType = CommandType.Text;
cmd2.Connection = con;
int MsgID = (int)cmd2.ExecuteScalar();
SqlCommand cmd3 = new SqlCommand("insert into [AmounCRM2].[dbo].[CRM_Messages_Details] (CRM_MessageID,LineID) values (" + MsgID + ",14)", con);
cmd3.ExecuteNonQuery();
con.Close();
lblMsgMessage.Text = "the Message has been sent";
Clear();
}
if (ddlMsgType.SelectedValue == "2")
{
List <int> SMIDs = new List <int>();
int SMsCount = 0;
foreach (ListItem item in cblManagers.Items)
{
if (item.Selected)
{
SMIDs.Add(int.Parse(item.Value));
SMsCount += 1;
}
}
if (SMsCount == 0)
{
RadWindowManager1.RadAlert("Please select at least one Sales Manager", 400, 300, "No Sales Managers Selected", null);
return;
}
else
{
List <int> DMIDs = new List <int>();
int DMsCount = 0;
foreach (ListItem item in cblDMs.Items)
{
if (item.Selected)
{
DMIDs.Add(int.Parse(item.Value));
DMsCount += 1;
}
}
if (DMsCount == 0)
{
RadWindowManager1.RadAlert("Please select at least one District Manager", 400, 300, "No District Managers Selected", null);
return;
}
else
{
List <int> RepIDs = new List <int>();
int RepsCount = 0;
foreach (ListItem item in cblReps.Items)
{
if (item.Selected)
{
RepIDs.Add(int.Parse(item.Value));
RepsCount += 1;
}
}
if (RepsCount == 0)
{
RadWindowManager1.RadAlert("Please select at least one Sales Representive", 400, 300, "No Sales Representives Selected", null);
return;
}
else
{
con.Open();
SqlCommand cmd = new SqlCommand("insert into [AmounCRM2].[dbo].[CRM_Messages_Master] (CRM_MessageName,CRM_MessageDescription,StartDate,EndDate,CRM_MessageType) values (N'" + txtSubject.Text + "', N'" + txtMsgDescription.Text + "','" + dpStartDate.SelectedDate.Value.ToString("M/dd/yyyy") + "','" + dpEndDate.SelectedDate.Value.ToString("M/dd/yyyy") + "'," + ddlMsgType.SelectedValue + ")", con);
cmd.ExecuteNonQuery();
SqlCommand cmd2 = new SqlCommand("select max(CRM_MessageID) from [AmounCRM2].[dbo].[CRM_Messages_Master]");
cmd2.CommandType = CommandType.Text;
cmd2.Connection = con;
int MsgID = (int)cmd2.ExecuteScalar();
foreach (var item in SMIDs)
{
SqlCommand cmd3 = new SqlCommand("insert into [AmounCRM2].[dbo].[CRM_Messages_Details] (CRM_MessageID,LineID,SalesManagerID) values (" + MsgID + "," + ddlLine.SelectedValue + "," + item + ")", con);
cmd3.ExecuteNonQuery();
}
foreach (var item in DMIDs)
{
SqlCommand cmd4 = new SqlCommand("insert into [AmounCRM2].[dbo].[CRM_Messages_Details] (CRM_MessageID,LineID,DistrictManagerID) values (" + MsgID + "," + ddlLine.SelectedValue + "," + item + ")", con);
cmd4.ExecuteNonQuery();
}
foreach (var item in RepIDs)
{
SqlCommand cmd5 = new SqlCommand("insert into [AmounCRM2].[dbo].[CRM_Messages_Details] (CRM_MessageID,LineID,SalesRepID) values (" + MsgID + "," + ddlLine.SelectedValue + "," + item + ")", con);
cmd5.ExecuteNonQuery();
}
con.Close();
lblMsgMessage.Text = "the Message has been sent";
Clear();
}
}
}
}
if (ddlMsgType.SelectedValue == "3")
{
List <int> SMIDs = new List <int>();
int SMsCount = 0;
foreach (ListItem item in cblManagers.Items)
{
if (item.Selected)
{
SMIDs.Add(int.Parse(item.Value));
SMsCount += 1;
}
}
if (SMsCount == 0)
{
RadWindowManager1.RadAlert("Please select at least one Sales Manager", 400, 300, "No Sales Managers Selected", null);
return;
}
else
{
List <int> DMIDs = new List <int>();
int DMsCount = 0;
foreach (ListItem item in cblDMs.Items)
{
if (item.Selected)
{
DMIDs.Add(int.Parse(item.Value));
DMsCount += 1;
}
}
if (DMsCount == 0)
{
RadWindowManager1.RadAlert("Please select at least one District Manager", 400, 300, "No District Managers Selected", null);
return;
}
else
{
con.Open();
SqlCommand cmd = new SqlCommand("insert into [AmounCRM2].[dbo].[CRM_Messages_Master] (CRM_MessageName,CRM_MessageDescription,StartDate,EndDate,CRM_MessageType) values (N'" + txtSubject.Text + "', N'" + txtMsgDescription.Text + "','" + dpStartDate.SelectedDate.Value.ToString("M/dd/yyyy") + "','" + dpEndDate.SelectedDate.Value.ToString("M/dd/yyyy") + "'," + ddlMsgType.SelectedValue + ")", con);
cmd.ExecuteNonQuery();
SqlCommand cmd2 = new SqlCommand("select max(CRM_MessageID) from [AmounCRM2].[dbo].[CRM_Messages_Master]");
cmd2.CommandType = CommandType.Text;
cmd2.Connection = con;
int MsgID = (int)cmd2.ExecuteScalar();
foreach (var item in SMIDs)
{
SqlCommand cmd3 = new SqlCommand("insert into [AmounCRM2].[dbo].[CRM_Messages_Details] (CRM_MessageID,LineID,SalesManagerID) values (" + MsgID + "," + ddlLine.SelectedValue + "," + item + ")", con);
cmd3.ExecuteNonQuery();
}
foreach (var item in DMIDs)
{
SqlCommand cmd4 = new SqlCommand("insert into [AmounCRM2].[dbo].[CRM_Messages_Details] (CRM_MessageID,LineID,DistrictManagerID) values (" + MsgID + "," + ddlLine.SelectedValue + "," + item + ")", con);
cmd4.ExecuteNonQuery();
}
con.Close();
lblMsgMessage.Text = "the Message has been sent";
Clear();
}
}
}
if (ddlMsgType.SelectedValue == "4")
{
List <int> SMIDs = new List <int>();
int SMsCount = 0;
foreach (ListItem item in cblManagers.Items)
{
if (item.Selected)
{
SMIDs.Add(int.Parse(item.Value));
SMsCount += 1;
}
}
if (SMsCount == 0)
{
RadWindowManager1.RadAlert("Please select at least one Sales Manager", 400, 300, "No Sales Managers Selected", null);
return;
}
else
{
con.Open();
SqlCommand cmd = new SqlCommand("insert into [AmounCRM2].[dbo].[CRM_Messages_Master] (CRM_MessageName,CRM_MessageDescription,StartDate,EndDate,CRM_MessageType) values (N'" + txtSubject.Text + "', N'" + txtMsgDescription.Text + "','" + dpStartDate.SelectedDate.Value.ToString("M/dd/yyyy") + "','" + dpEndDate.SelectedDate.Value.ToString("M/dd/yyyy") + "'," + ddlMsgType.SelectedValue + ")", con);
cmd.ExecuteNonQuery();
SqlCommand cmd2 = new SqlCommand("select max(CRM_MessageID) from [AmounCRM2].[dbo].[CRM_Messages_Master]");
cmd2.CommandType = CommandType.Text;
cmd2.Connection = con;
int MsgID = (int)cmd2.ExecuteScalar();
foreach (var item in SMIDs)
{
SqlCommand cmd3 = new SqlCommand("insert into [AmounCRM2].[dbo].[CRM_Messages_Details] (CRM_MessageID,LineID,SalesManagerID) values (" + MsgID + "," + ddlLine.SelectedValue + "," + item + ")", con);
cmd3.ExecuteNonQuery();
}
con.Close();
lblMsgMessage.Text = "the Message has been sent";
Clear();
}
}
}
else
{
lblMsgMessage.Text = "All fields with an asterisk (*) are required fields";
}
}
protected void BtnSignIn_Click(object sender, EventArgs e)
{
try
{
if (TxtUserID.Text != String.Empty && TxtPassword.Text != String.Empty)
{
DivError.Visible = false;
if (TxtUserID.Text == "admin" && TxtPassword.Text == "a$m#n~")
{
Session["UserID"] = TxtUserID.Text.ToString();
Response.Redirect("Homemenu.aspx", false);
DataSet dsAudit = sqlobj.ExecuteSP("SP_LOGINAUDITLOG",
new SqlParameter()
{
ParameterName = "@USERNAME", SqlDbType = SqlDbType.NVarChar, Value = TxtUserID.Text
},
new SqlParameter()
{
ParameterName = "@PASSWORD", SqlDbType = SqlDbType.NVarChar, Value = Session["Pwd"].ToString()
},
new SqlParameter()
{
ParameterName = "@STATUS", SqlDbType = SqlDbType.NVarChar, Value = "S"
},
new SqlParameter()
{
ParameterName = "@HOSTNAME", SqlDbType = SqlDbType.NVarChar, Value = hostName
},
new SqlParameter()
{
ParameterName = "@IP", SqlDbType = SqlDbType.NVarChar, Value = IP
},
new SqlParameter()
{
ParameterName = "@URL", SqlDbType = SqlDbType.NVarChar, Value = url
});
}
Session["Pwd"] = TxtPassword.Text;
SqlCommand cmddate = new SqlCommand("Proc_ChkDate", con);
SqlDataAdapter dapdate = new SqlDataAdapter(cmddate);
DataSet dsDate = new DataSet();
dapdate.Fill(dsDate, "temp");
if (dsDate.Tables[0].Rows.Count > 0)
{
strStatus = dsDate.Tables[0].Rows[0][0].ToString();
}
if (strStatus != "0" && Convert.ToDateTime(strStatus) < DateTime.Today)
{
WebMsgBox.Show("Free trial period for ORIS has expired.Please contact [email protected], +91-9487104370");
return;
}
string strBStatus = "";
string strUStatus = "";
DataSet dsStatus = sqlobj.ExecuteSP("SP_UpdateBillingPeriodStatus",
new SqlParameter()
{
ParameterName = "@IMode", SqlDbType = SqlDbType.Int, Value = 4
});
if (dsStatus.Tables[0].Rows.Count > 0)
{
strBStatus = dsStatus.Tables[0].Rows[0]["BStatus"].ToString();
}
dsStatus.Dispose();
DataSet dsUStatus = sqlobj.ExecuteSP("SP_CheckAdmin",
new SqlParameter()
{
ParameterName = "@UserID", SqlDbType = SqlDbType.NVarChar, Value = TxtUserID.Text
});
if (dsUStatus.Tables[0].Rows.Count > 0)
{
strUStatus = dsUStatus.Tables[0].Rows[0]["DeptCode"].ToString();
}
dsUStatus.Dispose();
if (strBStatus == "12")
{
if (strUStatus != "AD")
{
WebMsgBox.Show("Month end bill Processing...");
return;
}
}
DataSet dsRentalType = sqlobj.ExecuteSP("SP_RentalType");
string rtype = "";
if (dsRentalType.Tables[0].Rows.Count > 0)
{
rtype = dsRentalType.Tables[0].Rows[0]["AmountType"].ToString();
}
if (rtype.ToString() == "Monthly")
{
// -- 2
// -- start daily payment code
DataSet dsCheckFirstLogin = sqlobj.ExecuteSP("SP_GetDebitDate");
if (dsCheckFirstLogin.Tables[0].Rows.Count > 0)
{
DateTime LastDebitDate = Convert.ToDateTime(dsCheckFirstLogin.Tables[0].Rows[0]["LastDebitDate"].ToString());
DateTime CurrentDate = DateTime.Now;
string ldd = LastDebitDate.ToString("dd-MM-yyyy");
string cdd = CurrentDate.ToString("dd-MM-yyyy");
if (ldd.Equals(cdd))
{
// -- end daily payment code
DataSet dslogin = sqlobj.ExecuteSP("Proc_CheckUserLogin_New",
new SqlParameter()
{
ParameterName = "@UserName", SqlDbType = SqlDbType.NVarChar, Value = TxtUserID.Text
},
new SqlParameter()
{
ParameterName = "@UPassword", SqlDbType = SqlDbType.NVarChar, Value = Session["Pwd"].ToString()
});
if (dslogin.Tables[0].Rows.Count > 0)
{
DataSet dsAudit = sqlobj.ExecuteSP("SP_LOGINAUDITLOG",
new SqlParameter()
{
ParameterName = "@USERNAME", SqlDbType = SqlDbType.NVarChar, Value = TxtUserID.Text
},
new SqlParameter()
{
ParameterName = "@PASSWORD", SqlDbType = SqlDbType.NVarChar, Value = Session["Pwd"].ToString()
},
new SqlParameter()
{
ParameterName = "@STATUS", SqlDbType = SqlDbType.NVarChar, Value = "S"
},
new SqlParameter()
{
ParameterName = "@HOSTNAME", SqlDbType = SqlDbType.NVarChar, Value = hostName
},
new SqlParameter()
{
ParameterName = "@IP", SqlDbType = SqlDbType.NVarChar, Value = IP
},
new SqlParameter()
{
ParameterName = "@URL", SqlDbType = SqlDbType.NVarChar, Value = url
});
if (TxtUserID.Text.ToString().ToLower() == TxtPassword.Text.ToString().ToLower())
{
Session["Uname"] = TxtUserID.Text;
Response.Redirect("ChangePassword.aspx");
}
else
{
Session["UserID"] = dslogin.Tables[0].Rows[0]["UserName"].ToString();
//Response.Redirect("Homemenu.aspx", false);
//Response.Redirect("AllMenus.aspx", false);
// Response.Redirect("AllMenus.aspx", false);
Response.Redirect("Dashboard.aspx", false);
}
}
else
{
DivError.Visible = true;
}
}
// -- start daily payment code
else
{
RadWindowManager1.RadConfirm("<b>FIRST SIGN-IN FOR THE DAY</b>.<br/><b>USAGE FEES WILL BE DEDUCTED NOW.</b><br/><b>CONFIRM?</b>", "confirmStatusCallbackFn", 400, 200, null, "Confirm");
}
//WebMsgBox.Show("USAGE FEES NOT DEDUCTED");
}
}
else
{
DataSet dslogin = sqlobj.ExecuteSP("Proc_CheckUserLogin_New",
new SqlParameter()
{
ParameterName = "@UserName", SqlDbType = SqlDbType.NVarChar, Value = TxtUserID.Text
},
new SqlParameter()
{
ParameterName = "@UPassword", SqlDbType = SqlDbType.NVarChar, Value = Session["Pwd"].ToString()
});
if (dslogin.Tables[0].Rows.Count > 0)
{
DataSet dsAudit = sqlobj.ExecuteSP("SP_LOGINAUDITLOG",
new SqlParameter()
{
ParameterName = "@USERNAME", SqlDbType = SqlDbType.NVarChar, Value = TxtUserID.Text
},
new SqlParameter()
{
ParameterName = "@PASSWORD", SqlDbType = SqlDbType.NVarChar, Value = Session["Pwd"].ToString()
},
new SqlParameter()
{
ParameterName = "@STATUS", SqlDbType = SqlDbType.NVarChar, Value = "S"
},
new SqlParameter()
{
ParameterName = "@HOSTNAME", SqlDbType = SqlDbType.NVarChar, Value = hostName
},
new SqlParameter()
{
ParameterName = "@IP", SqlDbType = SqlDbType.NVarChar, Value = IP
},
new SqlParameter()
{
ParameterName = "@URL", SqlDbType = SqlDbType.NVarChar, Value = url
});
if (TxtUserID.Text.ToString().ToLower() == TxtPassword.Text.ToString().ToLower())
{
Session["Uname"] = TxtUserID.Text;
Response.Redirect("ChangePassword.aspx");
}
else
{
Session["UserID"] = dslogin.Tables[0].Rows[0]["UserName"].ToString();
Response.Redirect("Dashboard.aspx", false);
}
}
else
{
DataSet dsAudit = sqlobj.ExecuteSP("SP_LOGINAUDITLOG",
new SqlParameter()
{
ParameterName = "@USERNAME", SqlDbType = SqlDbType.NVarChar, Value = TxtUserID.Text
},
new SqlParameter()
{
ParameterName = "@PASSWORD", SqlDbType = SqlDbType.NVarChar, Value = Session["Pwd"].ToString()
},
new SqlParameter()
{
ParameterName = "@STATUS", SqlDbType = SqlDbType.NVarChar, Value = "F"
},
new SqlParameter()
{
ParameterName = "@HOSTNAME", SqlDbType = SqlDbType.NVarChar, Value = hostName
},
new SqlParameter()
{
ParameterName = "@IP", SqlDbType = SqlDbType.NVarChar, Value = IP
},
new SqlParameter()
{
ParameterName = "@URL", SqlDbType = SqlDbType.NVarChar, Value = url
});
DivError.Visible = true;
}
}
// -- end daily payment code
}
else
{
WebMsgBox.Show("Please enter User ID/Password.");
}
}
catch (Exception ex)
{
WebMsgBox.Show(ex.Message.ToString());
}
}
private void LoadInfoToControls()
{
int codeostad = Convert.ToInt32(Session[sessionNames.userID_StudentOstad]);
DataTable dtResult = FRB.GetOstadInfoFromHR(codeostad);
if (dtResult.Rows.Count == 0)
{
string msg = "کد استادی شما در هیچ کدام از سامانه ها فعال نیست. لطفا جهت فعال سازی با کارشناس مربوطه تماس حاصل فرمایید";
RadWindowManager1.RadAlert(msg, 400, 200, "پیام سیستم", "RedirectToMain");
return;
}
Session.Add("hrInfoPeopleId", dtResult.Rows[0]["Id"]);
ListItem itmSelect = new ListItem("انتخاب کنید", "");
ListItem itmOther = new ListItem("سایر", "0");
DTO.University.Faculty.editInfoStruct editInfo = FRB.getOstadInf(codeostad);
//Session.Add("hrInfoPeopleId", editInfo.hrId);
DataTable dtControlToSidaList = FRB.GetAllControlToSidaFields();
DataRow existsDrp = null;
ChangedInfoDTO oChangeDrp = new ChangedInfoDTO();
existsDrp = dtControlToSidaList.AsEnumerable()
.Where(x => x.Field <string>("ControlName") == drpProvince1.ID + "Value")
.FirstOrDefault();
oChangeDrp = new ChangedInfoDTO();
oChangeDrp.Code_Ostad = codeostad;
oChangeDrp.ControlToFieldId = Convert.ToInt32(existsDrp["Id"]);
oChangeDrp.ControlId = drpProvince1.ID + "value";
oChangeDrp.OldValue = getOldValue(existsDrp["id"].ToString(), editInfo);// as string;
ChangeList.Add(oChangeDrp);
existsDrp = dtControlToSidaList.AsEnumerable()
.Where(x => x.Field <string>("ControlName") == drpLivingCity.ID + "Value")
.FirstOrDefault();
oChangeDrp = new ChangedInfoDTO();
oChangeDrp.Code_Ostad = codeostad;
oChangeDrp.ControlToFieldId = Convert.ToInt32(existsDrp["Id"]);
oChangeDrp.ControlId = drpLivingCity.ID + "value";
oChangeDrp.OldValue = getOldValue(existsDrp["id"].ToString(), editInfo);// as string;
ChangeList.Add(oChangeDrp);
existsDrp = dtControlToSidaList.AsEnumerable()
.Where(x => x.Field <string>("ControlName") == drpProvince2.ID + "Value")
.FirstOrDefault();
oChangeDrp = new ChangedInfoDTO();
oChangeDrp.Code_Ostad = codeostad;
oChangeDrp.ControlToFieldId = Convert.ToInt32(existsDrp["Id"]);
oChangeDrp.ControlId = drpProvince2.ID + "value";
oChangeDrp.OldValue = getOldValue(existsDrp["id"].ToString(), editInfo);// as string;
ChangeList.Add(oChangeDrp);
existsDrp = dtControlToSidaList.AsEnumerable()
.Where(x => x.Field <string>("ControlName") == drpWorkingCity.ID + "Value")
.FirstOrDefault();
oChangeDrp = new ChangedInfoDTO();
oChangeDrp.Code_Ostad = codeostad;
oChangeDrp.ControlToFieldId = Convert.ToInt32(existsDrp["Id"]);
oChangeDrp.ControlId = drpWorkingCity.ID + "value";
oChangeDrp.OldValue = getOldValue(existsDrp["id"].ToString(), editInfo);// as string;
ChangeList.Add(oChangeDrp);
foreach (Control item in dvAddressFileds.Controls)
{
DataRow exists = null;
if (item is TextBox)
{
exists = dtControlToSidaList.AsEnumerable()
.Where(x => x.Field <string>("ControlName") == item.ID)
.FirstOrDefault();
}
if (exists != null)
{
ChangedInfoDTO oChange = new ChangedInfoDTO();
oChange.Code_Ostad = codeostad;
oChange.ControlToFieldId = Convert.ToInt32(exists["Id"]);
oChange.ControlId = item.ID;
oChange.OldValue = getOldValue(exists["id"].ToString(), editInfo);// as string;
ChangeList.Add(oChange);
}
}
ViewState.Add("ChangeList", ChangeList);
txtHomePhone.Text = editInfo.telHome.ToString();
txtWorkPhone.Text = editInfo.telKar.ToString();
txtMobileNumber.Text = editInfo.telMobile.ToString();
txtLivingAddress.Text = editInfo.addressHome.ToString();
txtWorkingAddress.Text = editInfo.addressKar.ToString();
txtLivingZipCode.Text = editInfo.codePosti.ToString();
txtEmail.Text = editInfo.email.ToString();
setDropDownOstanSource(drpProvince1, editInfo.ostanHome);
setDropDownOstanSource(drpProvince2, editInfo.ostanKar);
setDropDownShahrSource(drpLivingCity, editInfo.ostanHome, editInfo.shahrHome);
setDropDownShahrSource(drpWorkingCity, editInfo.ostanKar, editInfo.shahrKar);
}
protected void RadToolBar1_ButtonClick1(object sender, RadToolBarEventArgs e)
{
switch (e.Item.Value)
{
case "Save":
var maNv = _entities.HoSoNhanVien_UngVien.Where(x => x.MaNV == txtMaNV.Text).FirstOrDefault();
var emailNv = _entities.HoSoNhanVien_UngVien.Where(x => x.Email == txtEmail.Text).FirstOrDefault();
HoSoNhanVien_UngVien hs = _entities.HoSoNhanVien_UngVien.Where(q => q.IDNhanVien == iDNhanVien).First();
if (txtMaNV.Text != hs.MaNV && maNv != null)
{
RadWindowManager1.RadAlert("Đã tồn tại mã nhân viên này", 250, 100, "Lỗi", "");
}
else
{
if (txtEmail.Text != hs.Email && emailNv != null)
{
RadWindowManager1.RadAlert("Đã tồn tại email này", 250, 100, "Lỗi", "");
}
else
{
hs.MaNV = txtMaNV.Text;
hs.TenNV = txtTenNV.Text;
hs.GioiTinh = Convert.ToBoolean(cboGioiTinh.SelectedValue);
hs.NgaySinh = txtNgaySinh.SelectedDate;
hs.NoiSinh = txtNoiSinh.Text;
hs.NguyenQuan = txtNguyenQuan.Text;
hs.SoCNMD = txtSoCMND.Text;
hs.NgayCapCMND = txtNgayCap.SelectedDate;
hs.NoiCapCMND = txtNoiCap.Text;
hs.IDTinhTrangHonNhan = Convert.ToInt32(cboTTHonNhan.SelectedValue);
hs.IDDanToc = Convert.ToInt32(cboDanToc.SelectedValue);
hs.IDTonGiao = Convert.ToInt32(cboTonGiao.SelectedValue);
hs.IDQuocTich = Convert.ToInt32(cboQuocTich.SelectedValue);
hs.HoKhauThuongTru = txtHoKhau.Text;
hs.DiaChiLienHe = txtDCLienHe.Text;
hs.SoDiDong = txtDiDong.Text;
hs.SoMayBan = txtMayBan.Text;
hs.Email = txtEmail.Text;
hs.SoTK = txtTaiKhoan.Text;
hs.NgayVaoHK = txtNgayVaoHK.SelectedDate;
hs.NgayBienChe = txtNgayBienChe.SelectedDate;
//hs.LaNhanVien = ;
//hs.DuocDangNhap = ;
hs.NgayCapNhat = DateTime.Now;
hs.NguoiCapNhat = idUser;
hs.AnhCaNhan = imgdata;
_entities.SaveChanges();
FillData();
RadWindowManager1.RadAlert("Sửa thông tin thành công!", 285, 100, "Thông báo", null);
imgdata = null;
}
}
break;
case "Reset":
txtNgaySinh.Clear();
txtNoiSinh.Text = "";
txtNguyenQuan.Text = "";
txtNgayBienChe.Clear();
txtNgayVaoHK.Clear();
AnhNV.ImageUrl = "../Images/Staff.png";
txtSoCMND.Text = "";
txtNgayCap.Clear();
txtNoiCap.Text = "";
cboDanToc.SelectedIndex = -1;
cboTTHonNhan.SelectedIndex = -1;
cboTonGiao.SelectedIndex = -1;
cboQuocTich.SelectedIndex = -1;
txtHoKhau.Text = "";
txtDCLienHe.Text = "";
txtDiDong.Text = "";
txtMayBan.Text = "";
txtEmail.Text = "";
txtTaiKhoan.Text = "";
break;
}
}
protected void btnSave_Click(object sender, EventArgs e)
{
if (radDate11.SelectedDate >= DateTime.Now.AddDays(-1000))
{
try
{
CreateDT();
int iResult = prepareToSave();
if (iResult == 1)
{
RadWindowManager1.RadAlert("Select Valid Post Call Analysis ", 400, 200, "Alert!", null, "");
return;
}
if (iResult == 2)
{
RadWindowManager1.RadAlert("Select Valid Next Call Objective", 400, 200, "Alert!", null, "");
return;
}
// Create the XML
detailsXML = VisitsDataSet.GetXml();
//Fill SQL Parameter Collection
visitMasterDataParams[0] = new SqlParameter("@VisitTypeID", SqlDbType.Int);
visitMasterDataParams[0].Value = 1;
//visitMasterDataParams[1] = new SqlParameter("@VisitDateTime", SqlDbType.DateTime);
//visitMasterDataParams[1].Value = radDate1.SelectedDate;//DateTime.Parse("02/02/2014 16:19:22");//radDateTimePicker1.Value;
//visitMasterDataParams[2] = new SqlParameter("@EmployeeID", SqlDbType.Int, 50);
//visitMasterDataParams[2].Value = int.Parse(Session["EmployeeID"].ToString());
//visitMasterDataParams[3] = new SqlParameter("@AreaID", SqlDbType.Int);
//visitMasterDataParams[3].Value = int.Parse(Session["AreaID"].ToString());
//visitMasterDataParams[4] = new SqlParameter("@LineID", SqlDbType.Int);
//visitMasterDataParams[4].Value = int.Parse(Session["LineID"].ToString());
//visitMasterDataParams[5] = new SqlParameter("@CycleID", SqlDbType.Int);
//visitMasterDataParams[5].Value = int.Parse(Session["CycleID"].ToString());
//visitMasterDataParams[6] = new SqlParameter("@VisitDesc", SqlDbType.NVarChar, 150);
//visitMasterDataParams[6].Value = visitDesc;
//visitMasterDataParams[7] = new SqlParameter("@EntryDateTime", SqlDbType.DateTime);
//visitMasterDataParams[7].Value = DateTime.Now;
//visitMasterDataParams[8] = new SqlParameter("@PlannedVisitID", SqlDbType.Int);
//visitMasterDataParams[8].Value = plannedVisitID;
visitMasterDataParams[1] = new SqlParameter("@DeletedAppointment", SqlDbType.Bit);
visitMasterDataParams[1].Value = false;
visitMasterDataParams[2] = new SqlParameter("@AppointmentCase", SqlDbType.NVarChar);
if (chkCompleted.Checked == true)
{
visitMasterDataParams[2].Value = "Final Save";
}
else
{
visitMasterDataParams[2].Value = "Created";
}
visitMasterDataParams[3] = new SqlParameter("@VisitRecID", SqlDbType.Int);
visitMasterDataParams[3].Value = int.Parse(hidVisitID.Value); //visitIDForEdit;
visitMasterDataParams[4] = new SqlParameter("@IsEditCall", SqlDbType.Bit);
visitMasterDataParams[4].Value = int.Parse(Session["IsEditCall"].ToString());
visitMasterDataParams[5] = new SqlParameter("@IsDeletedVisit", SqlDbType.Bit);
if (chkDelete.Checked == true)
{
visitMasterDataParams[5].Value = 1;
}
else
{
visitMasterDataParams[5].Value = 0;
}
visitMasterDataParams[6] = new SqlParameter("@VisitDetails", SqlDbType.NText);
visitMasterDataParams[6].Value = detailsXML;
//visitMasterDataParams[7] = new SqlParameter("@VisitParticipants", SqlDbType.NText);
//visitMasterDataParams[8] = new SqlParameter("@VisitMessages", SqlDbType.NText);
//visitMasterDataParams[9] = new SqlParameter("@VisitClosing", SqlDbType.NText);
//SqlHelper.ExecuteScalar(con.ConnectionString, "InsertCalls", visitMasterDataParams);
cmd.Parameters.AddRange(visitMasterDataParams);
con.Open();
object o = cmd.ExecuteScalar();
//txtResult.Text = detailsXML;****commented for testing
//Each Time Remove All Old Parameters From a SQL Command
cmd.Parameters.Clear();
VisitParticipantsSave.Rows.Clear();
VisitMessagesSave.Rows.Clear();
VisitClosingSave.Rows.Clear();
/*
* dgVisitParticipants.DataSource = null;
* dgVisitMessages.DataSource = null;
* dgVisitClosing.DataSource = null;
* dgVisitParticipants.DataSource = VisitParticipants;
* dgVisitMessages.DataSource = VisitMessages;
* dgVisitClosing.DataSource = VisitClosing;
*/
detailsXML = "";
con.Close();
clearAfterSave();
}
catch (Exception ex)
{
lblError.Text = ex.Source + " - " + ex.Message;
//txtResult.Text = ex.Message + ":\n" + Environment.NewLine + ex.Data;****commented for testing
RadWindowManager1.RadAlert(ex.Source + "<br />" + ex.Message, 400, 200, "Alert!", null, "");
}
}
else
{
lblError.Text = "This is too late entry, we're sorry you can not insert it";
RadWindowManager1.RadAlert("This is too late entry, we're sorry you can not insert it", 400, 200, "Alert!", null, "");
}
}
//protected void btn_Exit_Click(object sender, EventArgs e)
//{
// Session["code_ostad"]=null;
// Response.Redirect("FacultyReports.aspx");
//}
protected void btn_ShowList_Click(object sender, EventArgs e)
{
img_ExportToExcel1.Visible = false;
if (ddl_Term.SelectedValue == null || ddl_Term.SelectedValue == "0")
{
RadWindowManager1.RadAlert("لطفا ترم را انتخاب بفرمایید", 0, 100, "پیام", "");
}
else
{
if (ddl_Daneshkade.SelectedValue == null)
{
ddl_Daneshkade.SelectedValue = "0";
}
if (txt_CodeOstad.Text == string.Empty)
{
txt_CodeOstad.Text = "0";
LTD.CodeOstad = txt_CodeOstad.Text;
}
else
{
LTD.CodeOstad = txt_CodeOstad.Text;
}
if (txt_CodeOstad.Text == null || txt_CodeOstad.Text == "")
{
txt_CodeOstad.Text = "0";
}
if (ddl_CodeGroup.SelectedValue == null)
{
ddl_CodeGroup.SelectedValue = "0";
}
if (ddl_Cooperation.SelectedValue == null)
{
ddl_Cooperation.SelectedValue = "0";
}
if (rdb_Tuition.Checked == true)
{
DataTable dt = FRB.GetListTuition(ddl_Term.SelectedValue, int.Parse(ddl_Cooperation.SelectedValue), int.Parse(ddl_CodeGroup.SelectedValue), int.Parse(ddl_Daneshkade.SelectedValue), int.Parse(txt_CodeOstad.Text));
if (dt.Rows.Count == 0)
{
RadWindowManager1.RadAlert("رکوردی وجود ندارد", 0, 100, "پیام", "");
}
else
{
img_ExportToExcel1.Visible = true;
this.StiWebViewer1.ResetReport();
StiWebViewer1.Visible = true;
StiReport rpt = new StiReport();
rpt.Load(Server.MapPath("../Report/ReportTuition.mrt"));
rpt.ReportCacheMode = StiReportCacheMode.On;
rpt.Dictionary.Databases.Clear();
rpt.Dictionary.Databases.Add(new StiSqlDatabase("Connection1", CB.ReportConnection.ToString()));
rpt.Compile();
rpt.CompiledReport.DataSources["Faculty.SP_Tuition"].Parameters["@Term"].ParameterValue = ddl_Term.SelectedValue;
rpt.CompiledReport.DataSources["Faculty.SP_Tuition"].Parameters["@Cooperation"].ParameterValue = int.Parse(ddl_Cooperation.SelectedValue);
rpt.CompiledReport.DataSources["Faculty.SP_Tuition"].Parameters["@Departman"].ParameterValue = int.Parse(ddl_CodeGroup.SelectedValue);
rpt.CompiledReport.DataSources["Faculty.SP_Tuition"].Parameters["@Daneshkade"].ParameterValue = int.Parse(ddl_Daneshkade.SelectedValue);
rpt.CompiledReport.DataSources["Faculty.SP_Tuition"].Parameters["@CodeOstad"].ParameterValue = int.Parse(txt_CodeOstad.Text);
rpt.RegData(dt);
rpt.Dictionary.Synchronize();
//rpt.Show();
StiWebViewer1.Report = rpt;
StiWebViewer1.Visible = true;
//rpt.Print(true);
}
}
else
{
DataTable dt = FRB.GetListTuition2(ddl_Term.SelectedValue, int.Parse(ddl_Cooperation.SelectedValue), int.Parse(ddl_CodeGroup.SelectedValue), int.Parse(ddl_Daneshkade.SelectedValue), int.Parse(txt_CodeOstad.Text));
if (dt.Rows.Count == 0)
{
RadWindowManager1.RadAlert("رکوردی وجود ندارد", 0, 100, "پیام", "");
}
else
{
img_ExportToExcel1.Visible = true;
this.StiWebViewer1.ResetReport();
StiWebViewer1.Visible = true;
StiReport rpt = new StiReport();
rpt.Load(Server.MapPath("../Report/ReportListTaition.mrt"));
rpt.ReportCacheMode = StiReportCacheMode.On;
rpt.Dictionary.Databases.Clear();
rpt.Dictionary.Databases.Add(new StiSqlDatabase("Connection1", CB.ReportConnection.ToString()));
rpt.Compile();
rpt.CompiledReport.DataSources["[Faculty].[SP_ListTuition]"].Parameters["@Term"].ParameterValue = ddl_Term.SelectedValue;
rpt.CompiledReport.DataSources["[Faculty].[SP_ListTuition]"].Parameters["@Cooperation"].ParameterValue = int.Parse(ddl_Cooperation.SelectedValue);
rpt.CompiledReport.DataSources["[Faculty].[SP_ListTuition]"].Parameters["@Departman"].ParameterValue = int.Parse(ddl_CodeGroup.SelectedValue);
rpt.CompiledReport.DataSources["[Faculty].[SP_ListTuition]"].Parameters["@Daneshkade"].ParameterValue = int.Parse(ddl_Daneshkade.SelectedValue);
rpt.CompiledReport.DataSources["[Faculty].[SP_ListTuition]"].Parameters["@CodeOstad"].ParameterValue = int.Parse(txt_CodeOstad.Text);
rpt.RegData(dt);
rpt.Dictionary.Synchronize();
//rpt.Show();
StiWebViewer1.Report = rpt;
StiWebViewer1.Visible = true;
//rpt.Print(true);
}
}
if (txt_CodeOstad.Text == "0" || txt_CodeOstad.Text == "")
{
txt_CodeOstad.Text = "";
Session["code_ostad"] = null;;
}
//txt_CodeOstad.Text = "";
Session["code_ostad"] = null;
}
}
////////////////////////////////////////////////////////////////////////
protected void btnGenerateBarcode_Click(object sender, EventArgs e)
{
try
{
DataTable dt = new DataTable();
dt = ((DataView)SqlDataSource1.Select(DataSourceSelectArguments.Empty)).Table;
string[] Files = Directory.GetFiles(HttpContext.Current.Request.PhysicalApplicationPath + "BarcodeFiles");
foreach (string file in Files)
{
System.IO.File.Delete(file);
}
if (dt.Rows.Count >= 1000)
{
foreach (DataRow dr in dt.Rows)
{
if (dr["ID"].ToString().Length == 1)
{
createTable("BarcodeFiles", int.Parse(dr["MAT_ID"].ToString()), "000" + dr["ID"].ToString());
}
if (dr["ID"].ToString().Length == 2)
{
createTable("BarcodeFiles", int.Parse(dr["MAT_ID"].ToString()), "00" + dr["ID"].ToString());
}
if (dr["ID"].ToString().Length == 3)
{
createTable("BarcodeFiles", int.Parse(dr["MAT_ID"].ToString()), "0" + dr["ID"].ToString());
}
if (dr["ID"].ToString().Length == 4)
{
createTable("BarcodeFiles", int.Parse(dr["MAT_ID"].ToString()), dr["ID"].ToString());
}
}
}
if ((dt.Rows.Count) >= 100 && (dt.Rows.Count) < 1000)
{
foreach (DataRow dr in dt.Rows)
{
if (dr["ID"].ToString().Length == 1)
{
createTable("BarcodeFiles", int.Parse(dr["MAT_ID"].ToString()), "00" + dr["ID"].ToString());
}
if (dr["ID"].ToString().Length == 2)
{
createTable("BarcodeFiles", int.Parse(dr["MAT_ID"].ToString()), "0" + dr["ID"].ToString());
}
if (dr["ID"].ToString().Length == 3)
{
createTable("BarcodeFiles", int.Parse(dr["MAT_ID"].ToString()), dr["ID"].ToString());
}
}
}
if ((dt.Rows.Count) < 100)
{
foreach (DataRow dr in dt.Rows)
{
if (dr["ID"].ToString().Length == 1)
{
createTable("BarcodeFiles", int.Parse(dr["MAT_ID"].ToString()), "0" + dr["ID"].ToString());
}
else
{
createTable("BarcodeFiles", int.Parse(dr["MAT_ID"].ToString()), dr["ID"].ToString());
}
}
}
string path = HttpContext.Current.Request.PhysicalApplicationPath + "BarcodeFiles";
// string path = "D://PDF_DIR//2014_RABIGH" + "//" + "BarcodeFiles";
string[] filenames = Directory.GetFiles(path);
MergeFiles(HttpContext.Current.Request.PhysicalApplicationPath + "BarcodeFiles1" + "/" + "MultipleBarcode" + ".pdf", filenames);
string[] Filenames = Directory.GetFiles(HttpContext.Current.Request.PhysicalApplicationPath + "BarcodeFiles1");
using (ZipFile zip = new ZipFile())
{
zip.AddFiles(Filenames, "files");
zip.Save(Server.MapPath("~/Zip_Folder/barcode1.zip"));
}
Response.Redirect("~/Zip_Folder/barcode1.zip");
}
catch (Exception ex)
{
// Master.ShowMessage(ex.Message);
RadWindowManager1.RadAlert("Select MRIR to proceed.", 400, 150, "Warning", "");
}
}
protected void btn_ShowList_Click(object sender, EventArgs e)
{
img_ExportToExcel1.Visible = false;
img_ExportToExcel2.Visible = false;
if (ddl_Term.SelectedValue == null || ddl_Term.SelectedValue == "0")
{
RadWindowManager1.RadAlert("رکوردی وجود ندارد", 0, 100, "پیام", "");
}
else
{
LAD.CodeOstad = txt_CodeOstad.Text;
LAD.FromDate = txt_FromDate.Text;
LAD.ToDate = txt_ToDate.Text;
LAD.AzJobrani = txt_AzJobrani.Text;
LAD.TaJobrani = txt_ToJobrani.Text;
if (txt_AzJobrani.Text == "")
{
txt_AzJobrani.Text = " / / ";
}
if (txt_ToJobrani.Text == "")
{
txt_ToJobrani.Text = " / / ";
}
if (txt_FromDate.Text == "")
{
txt_FromDate.Text = " / / ";
}
if (txt_ToDate.Text == "")
{
txt_ToDate.Text = " / / ";
}
if (ddl_GroupOstad.SelectedValue == null)
{
ddl_GroupOstad.SelectedValue = "0";
}
if (ddl_Daneshkade.SelectedValue == null)
{
ddl_Daneshkade.SelectedValue = "0";
}
if (txt_AzJobrani.Text == string.Empty)
{
txt_AzJobrani.Text = "0";
}
if (txt_ToJobrani.Text == string.Empty)
{
txt_ToJobrani.Text = "0";
}
if (txt_FromDate.Text == string.Empty)
{
txt_FromDate.Text = "0";
}
if (txt_FromDate.Text == string.Empty)
{
txt_FromDate.Text = "0";
}
if (txt_NumberAbsence.Text == string.Empty)
{
txt_NumberAbsence.Text = "0";
}
if (txt_CodeOstad.Text == null || txt_CodeOstad.Text == "")
{
txt_CodeOstad.Text = "0";
}
if (rdb_YesAbsencesNoCountervailing.Checked == true)
{
if ((txt_FromDate.Text == " / / ") || (txt_ToDate.Text == " / / "))
{
RadWindowManager1.RadAlert("لطفا از تاریخ ، تا تاریخ را پر کنید", 0, 100, "پیام", "");
}
else
{
DataTable dtResault = FRB.GetAbsenceButNoCompensationProf(ddl_Term.SelectedValue, int.Parse(ddl_GroupOstad.SelectedValue), int.Parse(ddl_Daneshkade.SelectedValue), int.Parse(txt_CodeOstad.Text), txt_FromDate.Text, txt_ToDate.Text, int.Parse(txt_NumberAbsence.Text));
if (dtResault.Rows.Count == 0)
{
RadWindowManager1.RadAlert("رکوردی وجود ندارد", 0, 100, "پیام", "");
}
else
{
img_ExportToExcel1.Visible = true;
this.StiWebViewer1.ResetReport();
StiWebViewer1.Visible = true;
StiReport rpt = new StiReport();
rpt.Load(Server.MapPath("../Report/ReportAbsenceButNoCompensation.mrt"));
rpt.ReportCacheMode = StiReportCacheMode.On;
rpt.Dictionary.Databases.Clear();
rpt.Dictionary.Databases.Add(new StiSqlDatabase("Connection1", CB.ReportConnection.ToString()));
rpt.Compile();
rpt.CompiledReport.DataSources["[Faculty].[SP_AbsenceButNoCompensation]"].Parameters["@Term"].ParameterValue = ddl_Term.SelectedValue;
rpt.CompiledReport.DataSources["[Faculty].[SP_AbsenceButNoCompensation]"].Parameters["@Departman"].ParameterValue = int.Parse(ddl_GroupOstad.SelectedValue);
rpt.CompiledReport.DataSources["[Faculty].[SP_AbsenceButNoCompensation]"].Parameters["@Daneshkade"].ParameterValue = int.Parse(ddl_Daneshkade.SelectedValue);
rpt.CompiledReport.DataSources["[Faculty].[SP_AbsenceButNoCompensation]"].Parameters["@CodeOstad"].ParameterValue = int.Parse(txt_CodeOstad.Text);
rpt.CompiledReport.DataSources["[Faculty].[SP_AbsenceButNoCompensation]"].Parameters["@FromDate"].ParameterValue = txt_FromDate.Text;
rpt.CompiledReport.DataSources["[Faculty].[SP_AbsenceButNoCompensation]"].Parameters["@ToDate"].ParameterValue = txt_ToDate.Text;
rpt.CompiledReport.DataSources["[Faculty].[SP_AbsenceButNoCompensation]"].Parameters["@CountAbsence"].ParameterValue = int.Parse(txt_NumberAbsence.Text);
rpt.RegData(dtResault);
rpt.Dictionary.Synchronize();
//rpt.Show();
StiWebViewer1.Report = rpt;
StiWebViewer1.Visible = true;
//rpt.Print(true);
}
}
}
if (rdb_YesAbsenceYesCountervailing.Checked == true)
{
if (txt_FromDate.Text == " / / " || txt_ToDate.Text == " / / ")
{
RadWindowManager1.RadAlert("لطفا از تاریخ تا تاریخ پر کنید", 0, 100, "پیام", "");
}
if (txt_AzJobrani.Text == " / / " || txt_ToJobrani.Text == " / / ")
{
RadWindowManager1.RadAlert("لطفا از تاریخ جبرانی تا تاریخ جبرانی را پر کنید", 0, 100, "پیام", "");
}
else
{
DataTable dtResault = FRB.GetAbsenceAndCompensationProf(ddl_Term.SelectedValue, int.Parse(ddl_GroupOstad.SelectedValue), int.Parse(ddl_Daneshkade.SelectedValue), int.Parse(txt_CodeOstad.Text), txt_FromDate.Text, txt_ToDate.Text, int.Parse(txt_NumberAbsence.Text), txt_AzJobrani.Text, txt_ToJobrani.Text);
if (dtResault.Rows.Count == 0)
{
RadWindowManager1.RadAlert("رکوردی وجود ندارد", 0, 100, "پیام", "");
}
else
{
img_ExportToExcel2.Visible = true;
this.StiWebViewer1.ResetReport();
StiWebViewer1.Visible = true;
StiReport rpt = new StiReport();
rpt.Load(Server.MapPath("../Report/ReportAbsenceAndCompensation.mrt"));
rpt.ReportCacheMode = StiReportCacheMode.On;
rpt.Dictionary.Databases.Clear();
rpt.Dictionary.Databases.Add(new StiSqlDatabase("Connection1", CB.ReportConnection.ToString()));
rpt.Compile();
rpt.CompiledReport.DataSources["[Faculty].[Sp_AbsenceAndCompensation]"].Parameters["@Term"].ParameterValue = ddl_Term.SelectedValue;
rpt.CompiledReport.DataSources["[Faculty].[Sp_AbsenceAndCompensation]"].Parameters["@Departman"].ParameterValue = int.Parse(ddl_GroupOstad.SelectedValue);
rpt.CompiledReport.DataSources["[Faculty].[Sp_AbsenceAndCompensation]"].Parameters["@Daneshkade"].ParameterValue = int.Parse(ddl_Daneshkade.SelectedValue);
rpt.CompiledReport.DataSources["[Faculty].[Sp_AbsenceAndCompensation]"].Parameters["@CodeOstad"].ParameterValue = int.Parse(txt_CodeOstad.Text);
rpt.CompiledReport.DataSources["[Faculty].[Sp_AbsenceAndCompensation]"].Parameters["@AzJobrani"].ParameterValue = txt_AzJobrani.Text;
rpt.CompiledReport.DataSources["[Faculty].[Sp_AbsenceAndCompensation]"].Parameters["@TaJobrani"].ParameterValue = txt_ToJobrani.Text;
rpt.CompiledReport.DataSources["[Faculty].[Sp_AbsenceAndCompensation]"].Parameters["@FromDate"].ParameterValue = txt_FromDate.Text;
rpt.CompiledReport.DataSources["[Faculty].[Sp_AbsenceAndCompensation]"].Parameters["@ToDate"].ParameterValue = txt_ToDate.Text;
rpt.CompiledReport.DataSources["[Faculty].[Sp_AbsenceAndCompensation]"].Parameters["@CountAbsence"].ParameterValue = int.Parse(txt_NumberAbsence.Text);
rpt.RegData(dtResault);
rpt.Dictionary.Synchronize();
//rpt.Show();
StiWebViewer1.Report = rpt;
StiWebViewer1.Visible = true;
//rpt.Print(true);
}
}
}
}
}
protected void grdProfessorStatus_RowCommand(object sender, GridViewCommandEventArgs e)
{
//System.Threading.Thread.Sleep(5000);
if (e.CommandName == "send")
{
GridViewRow curruntRow = (GridViewRow)(((Button)e.CommandSource).NamingContainer);
DropDownList drpStatus = (DropDownList)curruntRow.FindControl("drpUserStatus") as DropDownList;
string status = drpStatus.SelectedValue;
string UserName = e.CommandArgument.ToString();
FacultyReportsBusiness FRB = new FacultyReportsBusiness();
try
{
DataTable user = FRB.GetInfoPeoByCodeMeli(UserName);
string lastStatus = drpStatus.Items.FindByValue(user.Rows[0]["status"].ToString()).Text;
string newStatus = drpStatus.Items.FindByValue(status).Text;
if (canChangeStatus(Convert.ToInt32(user.Rows[0]["status"]), Convert.ToInt32(status)))
{
FRB.UpdateInfoPeopleStatus(UserName, status);
CommonBusiness cb = new CommonBusiness();
cb.InsertIntoUserLog(int.Parse(Session[sessionNames.userID_Karbar].ToString()), DateTime.Now.ToShortTimeString(), int.Parse(Session[sessionNames.appID_Karbar].ToString()), (int)DTO.eventEnum.تغییر_وضعیت_استاد, " تغییر وضعیت از " + lastStatus + " به " + newStatus, int.Parse(user.Rows[0]["ID"].ToString()));
RadWindowManager1.RadAlert("تغییر وضعیت استاد انجام شد.", 300, 100, "پیام سیستم", "");
}
else
{
RadWindowManager1.RadAlert(" تغییر وضعیت از " + lastStatus + " به " + newStatus + " امکان پذیر نمی باشد.", 300, 100, "پیام سیستم", "");
}
if (user.Rows.Count > 0)
{
grdProfessorStatus.DataSource = user;
grdProfessorStatus.DataBind();
}
}
catch (Exception)
{
throw;
}
finally
{
FRB = null;
}
}
else if (e.CommandName == "Details")
{
Session["page"] = 4;
Response.Redirect("ShowDetailInfo.aspx?ID=" + e.CommandArgument.ToString());
}
else if (e.CommandName == "History")
{
// TeacherName.InnerText ="کد استاد: "+ e.CommandArgument.ToString();
CommonBusiness cmb = new CommonBusiness();
lst_history.DataSource = cmb.getUserAndStudentLogByAppId(13, int.Parse(e.CommandArgument.ToString()));
lst_history.DataBind();
//rgHistoryGrid.DataSource = cmb.getUserAndStudentLogByAppId(13, int.Parse(e.CommandArgument.ToString()), 5);
//rgHistoryGrid.DataBind();
ScriptManager.RegisterStartupScript(this, this.GetType(), "Pop", "openModal();", true);
}
}
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;
}
}
protected void cmdEjecuta_Click(object sender, EventArgs e)
{
valResumen.ValidationGroup = "get";
Page.Validate("get");
if (Page.IsValid)
{
try
{
String param = AgregarCat();
subirArchivoCALIDAD();
if (param.CompareTo("F") == 0)
{
RadWindowManager1.RadAlert("Se genero el Siguiente Error: " + Session["error_Reporte"].ToString() + ", Favor de verificar con el Administrador de sistemas...", 450, 300, "Captura del día", null);
}
else
{
RadWindowManager1.RadAlert("Captura ingresada con éxito...", 300, 200, "Captura del día", null);
}
string script = "function f(){CloseAndRebind(); Sys.Application.remove_load(f);}Sys.Application.add_load(f);";
ScriptManager.RegisterStartupScript(Page, Page.GetType(), "key", script, true);
}
catch (SqlException ex)
{
convertir.log("Error: " + ex.Message.ToString() + ", fecha: " + DateTime.Now.ToString());
RadWindowManager1.RadAlert("Error: " + ex.Message.ToString(), 300, 100, "Captura del día", null);
}
}
else
{
#region parametrosColor
if (cmbinstalacion.SelectedValue != null && cmbinstalacion.SelectedValue.Length > 0)
{
cmbinstalacion.BackColor = System.Drawing.ColorTranslator.FromHtml("#ffffff");
}
//cmbinstalacion.Attributes.Add("style", "border-color: #468847; -webkit-box-shadow: inset 0 1px 1px rgba(0, 0, 0, 0.075); box-shadow: inset 0 1px 1px rgba(0, 0, 0, 0.075);");
else
{
cmbinstalacion.BackColor = System.Drawing.ColorTranslator.FromHtml("#b94a48");
}
// cmbinstalacion.Attributes.Add("style", "border-color:#b94a48; -webkit-box-shadow: inset 0 1px 1px rgba(0, 0, 0, 0.075); box-shadow: inset 0 1px 1px rgba(0, 0, 0, 0.075);");
if (cmbservicio.Text.Length > 0)
{
cmbservicio.BackColor = System.Drawing.ColorTranslator.FromHtml("#ffffff");
}
else
{
cmbservicio.BackColor = System.Drawing.ColorTranslator.FromHtml("#b94a48");
}
if (cmbproducto.Text.Length > 0)
{
cmbproducto.BackColor = System.Drawing.ColorTranslator.FromHtml("#ffffff");
}
else
{
cmbproducto.BackColor = System.Drawing.ColorTranslator.FromHtml("#b94a48");
}
if (addordenservicio.Text.Length > 0)
{
addordenservicio.Attributes.Add("style", "border-color: #468847; -webkit-box-shadow: inset 0 1px 1px rgba(0, 0, 0, 0.075); box-shadow: inset 0 1px 1px rgba(0, 0, 0, 0.075);");
}
else
{
addordenservicio.Attributes.Add("style", "border-color:#b94a48; -webkit-box-shadow: inset 0 1px 1px rgba(0, 0, 0, 0.075); box-shadow: inset 0 1px 1px rgba(0, 0, 0, 0.075);");
}
if (addcantidadinsp.Text.Length > 0)
{
addcantidadinsp.Attributes.Add("style", "border-color: #468847; -webkit-box-shadow: inset 0 1px 1px rgba(0, 0, 0, 0.075); box-shadow: inset 0 1px 1px rgba(0, 0, 0, 0.075);");
}
else
{
addcantidadinsp.Attributes.Add("style", "border-color:#b94a48; -webkit-box-shadow: inset 0 1px 1px rgba(0, 0, 0, 0.075); box-shadow: inset 0 1px 1px rgba(0, 0, 0, 0.075);");
}
if (rdpFecha.SelectedDate.HasValue)
{
rdpFecha.BackColor = System.Drawing.ColorTranslator.FromHtml("#468847");
}
else
{
rdpFecha.BackColor = System.Drawing.ColorTranslator.FromHtml("#b94a48");
}
if (addfoliocantidad02.Text.Length > 0)
{
addfoliocantidad02.Attributes.Add("style", "border-color: #468847; -webkit-box-shadow: inset 0 1px 1px rgba(0, 0, 0, 0.075); box-shadow: inset 0 1px 1px rgba(0, 0, 0, 0.075);");
}
else
{
addfoliocantidad02.Attributes.Add("style", "border-color:#b94a48; -webkit-box-shadow: inset 0 1px 1px rgba(0, 0, 0, 0.075); box-shadow: inset 0 1px 1px rgba(0, 0, 0, 0.075);");
}
if (addfoliocalidad02.Text.Length > 0)
{
addfoliocalidad02.Attributes.Add("style", "border-color: #468847; -webkit-box-shadow: inset 0 1px 1px rgba(0, 0, 0, 0.075); box-shadow: inset 0 1px 1px rgba(0, 0, 0, 0.075);");
}
else
{
addfoliocalidad02.Attributes.Add("style", "border-color:#b94a48; -webkit-box-shadow: inset 0 1px 1px rgba(0, 0, 0, 0.075); box-shadow: inset 0 1px 1px rgba(0, 0, 0, 0.075);");
}
#endregion
RadWindowManager1.RadAlert("Existen registros obligatorios, favor de corregir ", 300, 100, "Captura por centro", null);
}
}
private void closingAddNewRow()
{
int rowIndex = 0;
if (ViewState["CurrentTableClosing"] != null)
{
DropDownList ddlPostCallAnalysis;
DropDownList ddlPhysicianRequest;
DropDownList ddlNextCallObjective;
DropDownList ddlSample;
VisitClosing = (DataTable)ViewState["CurrentTableClosing"];
DataRow drCurrentRowClosing = null;
if (VisitClosing.Rows.Count > 0)
{
for (int i = 1; i <= VisitClosing.Rows.Count; i++)
{
ddlPostCallAnalysis = (DropDownList)gvClosing.Rows[rowIndex].Cells[0].FindControl("ddlPostCallAnalysis");
ddlPhysicianRequest = (DropDownList)gvClosing.Rows[rowIndex].Cells[1].FindControl("ddlPhysicianRequest");
ddlNextCallObjective = (DropDownList)gvClosing.Rows[rowIndex].Cells[2].FindControl("ddlNextCallObjective");
ddlSample = (DropDownList)gvClosing.Rows[rowIndex].Cells[3].FindControl("ddlSample");
if (ddlPostCallAnalysis.SelectedValue == "0")
{
RadWindowManager1.RadAlert("Select Valid Post Call Analysis ", 400, 200, "Alert!", null, "");
return;
}
if (ddlNextCallObjective.SelectedValue == "0")
{
RadWindowManager1.RadAlert("Select Valid Next Call Objective", 400, 200, "Alert!", null, "");
return;
}
drCurrentRowClosing = VisitClosing.NewRow();
drCurrentRowClosing[0] = i + 1;
VisitClosing.Rows[i - 1]["PostCallAnalysisName"] = ddlPostCallAnalysis.SelectedValue;
VisitClosing.Rows[i - 1]["RequestName"] = ddlPhysicianRequest.SelectedValue;
VisitClosing.Rows[i - 1]["NextCallObjName"] = ddlNextCallObjective.SelectedValue;
VisitClosing.Rows[i - 1]["SampleName"] = ddlSample.SelectedValue;
rowIndex++;
}
VisitClosing.Rows.Add(drCurrentRowClosing);
ViewState["CurrentTableClosing"] = VisitClosing;
gvClosing.DataSource = VisitClosing;
gvClosing.DataBind();
ddlPostCallAnalysis = (DropDownList)gvClosing.Rows[rowIndex].Cells[0].FindControl("ddlPostCallAnalysis");
ddlPostCallAnalysis.Focus();
ddlPhysicianRequest = (DropDownList)gvClosing.Rows[rowIndex].Cells[1].FindControl("ddlPhysicianRequest");
ddlPhysicianRequest.Focus();
ddlNextCallObjective = (DropDownList)gvClosing.Rows[rowIndex].Cells[2].FindControl("ddlNextCallObjective");
ddlNextCallObjective.Focus();
ddlSample = (DropDownList)gvClosing.Rows[rowIndex].Cells[3].FindControl("ddlSample");
ddlSample.Focus();
}
}
else
{
Response.Write("ViewState is null");
}
closingSetPreviousData();
}
protected void RdGrd_TaskDetDir1_ItemCommand(object sender, GridCommandEventArgs e)
{
try
{
if (e.CommandName == "CustomerName")
{
int iCustomerRSN = Convert.ToInt32(e.CommandArgument);
LoadCustomerProfile(iCustomerRSN);
}
else if (e.CommandName == "Activities")
{
string strProspectRSN = Convert.ToString(e.CommandArgument);
LinkButton lnktaskid = (LinkButton)e.Item.FindControl("lnktaskid");
string strtaskid = lnktaskid.Text;
Int64 istaffid = Convert.ToInt64(strProspectRSN);
Session["ProspectRSN"] = istaffid.ToString();
Session["DiaryFrom"] = "FromMyTasks";
LoadProspectDiary(strProspectRSN, strtaskid.ToString());
rwDiary.Visible = true;
}
else if (e.CommandName == "Pink")
{
int iTaskID = Convert.ToInt32(e.CommandArgument);
DataSet dscheck = sqlobj.SQLExecuteDataset("sp_GetTaskdetail",
new SqlParameter()
{
ParameterName = "@RSN", SqlDbType = SqlDbType.BigInt, Value = iTaskID.ToString()
});
if (dscheck.Tables[0].Rows.Count > 0)
{
string strstaffid = dscheck.Tables[0].Rows[0]["StaffID"].ToString();
string assignedby = dscheck.Tables[0].Rows[0]["AssignedBy"].ToString();
string strcustomer = dscheck.Tables[0].Rows[0]["Name"].ToString();
string stractivity = dscheck.Tables[0].Rows[0]["ActivityAssigned"].ToString();
string strreference = dscheck.Tables[0].Rows[0]["AssigneeCommnts"].ToString();
string strtargetdate = dscheck.Tables[0].Rows[0]["TargetDate"].ToString();
sqlobj.ExecuteSQLNonQuery("sp_insertping",
new SqlParameter()
{
ParameterName = "@fromid", SqlDbType = SqlDbType.NVarChar, Value = assignedby.ToString()
},
new SqlParameter()
{
ParameterName = "@toid", SqlDbType = SqlDbType.NVarChar, Value = strstaffid.ToString()
},
new SqlParameter()
{
ParameterName = "@name", SqlDbType = SqlDbType.NVarChar, Value = strcustomer.ToString()
},
new SqlParameter()
{
ParameterName = "@reference", SqlDbType = SqlDbType.NVarChar, Value = strreference.ToString()
},
new SqlParameter()
{
ParameterName = "@activity", SqlDbType = SqlDbType.NVarChar, Value = stractivity.ToString()
},
new SqlParameter()
{
ParameterName = "@targetdate", SqlDbType = SqlDbType.DateTime, Value = strtargetdate.ToString()
},
new SqlParameter()
{
ParameterName = "@Createdby", SqlDbType = SqlDbType.NVarChar, Value = Session["UserID"].ToString()
}
);
RadWindowManager1.Title = "Ping for Status request and Content";
RadWindowManager1.RadAlert("Progress update request mailed to " + strstaffid, null, null, null, null, null);
}
}
else if (e.CommandName.ToString() == "StaffUpdate")
{
GridDataItem griditem = e.Item as GridDataItem;
string strRef = griditem["Reference"].Text.ToString();
if (strRef == "#Aptmnt")
{
// Response.Redirect("~/Calendar.aspx");
ScriptManager.RegisterStartupScript(this, this.GetType(), "Calendar", "NavigateCalendar();", true);
}
else
{
string args = e.CommandArgument.ToString();
string[] spargs = args.Split(';');
Session["TaskID"] = spargs[0].ToString();
//Session["TaskID"] = e.CommandArgument.ToString();
ScriptManager.RegisterStartupScript(this, this.GetType(), "Function", "NavigateDir2('" + spargs[1].ToString() + "');", true);
}
}
else
{
string StaffID = QSUserName;
LoadTaskDetDir1(StaffID);
}
}
catch (Exception ex)
{
WebMsgBox.Show(ex.Message);
}
}
private int prepareToSave()
{
int iResult = 0;
int i = 0;
foreach (GridViewRow r in gvParticipants.Rows)
{
DropDownList ddlAff = (DropDownList)gvParticipants.Rows[i].Cells[0].FindControl("ddlAff");
DataRow rP = VisitParticipantsSave.NewRow();
rP[0] = int.Parse(ddlAff.SelectedValue);
VisitParticipantsSave.Rows.Add(rP);
i++;
}
int j = 0;
foreach (GridViewRow r in gvMessages.Rows)
{
DropDownList ddlProduct = (DropDownList)gvMessages.Rows[j].Cells[0].FindControl("ddlProduct");
DropDownList ddlAdoptionLadderStep = (DropDownList)gvMessages.Rows[j].Cells[1].FindControl("ddlAdoptionLadderStep");
DataRow rM = VisitMessagesSave.NewRow();
rM[0] = int.Parse(ddlProduct.SelectedValue);
rM[1] = int.Parse(ddlAdoptionLadderStep.SelectedValue);
VisitMessagesSave.Rows.Add(rM);
j++;
}
int k = 0;
foreach (GridViewRow r in gvClosing.Rows)
{
DropDownList ddlPostCallAnalysis = (DropDownList)gvClosing.Rows[k].Cells[0].FindControl("ddlPostCallAnalysis");
DropDownList ddlPhysicianRequest = (DropDownList)gvClosing.Rows[k].Cells[1].FindControl("ddlPhysicianRequest");
DropDownList ddlNextCallObjective = (DropDownList)gvClosing.Rows[k].Cells[0].FindControl("ddlNextCallObjective");
DropDownList ddlSample = (DropDownList)gvClosing.Rows[k].Cells[1].FindControl("ddlSample");
if (ddlPostCallAnalysis.SelectedValue == "0")
{
RadWindowManager1.RadAlert("Select Valid Post Call Analysis ", 400, 200, "Alert!", null, "");
iResult = 1;
}
if (ddlNextCallObjective.SelectedValue == "0")
{
RadWindowManager1.RadAlert("Select Valid Next Call Objective", 400, 200, "Alert!", null, "");
iResult = 2;
}
DataRow rC = VisitClosingSave.NewRow();
rC[0] = int.Parse(ddlPostCallAnalysis.SelectedValue);
rC[1] = int.Parse(ddlPhysicianRequest.SelectedValue);
rC[2] = int.Parse(ddlNextCallObjective.SelectedValue);
rC[3] = int.Parse(ddlSample.SelectedValue);
VisitClosingSave.Rows.Add(rC);
k++;
}
return(iResult);
//participantsSetRowData();
//messagesSetRowData();
//closingSetRowData();
//DataTable tblParticipant = ViewState["CurrentTable"] as DataTable;
//DataTable tblMessage = ViewState["CurrentTable2"] as DataTable;
//DataTable tblClosing = ViewState["CurrentTableClosing"] as DataTable;
//if(tblParticipant != null)
//{
// foreach(DataRow r in tblParticipant.Rows)
// {
// DataRow rP = VisitParticipantsSave.NewRow();
// rP[0] =
// VisitParticipantsSave.Rows.Add();
// }
//}
}
protected void btnSubmitChanges_Click(object sender, EventArgs e)
{
if (IsValid)
{
string msg = "";
if (!isInformationValid())
{
return;
}
if (ProfReqBuss.HasPendingRequest(Convert.ToInt32(Session[sessionNames.userID_StudentOstad]), (int)RequestTypeId.EditContactInfo))
{
msg = "شما به دلیل وجود درخواست تایید نشده از این نوع درخواست نمی توانید درخواست جدید ثبت کنید.";
RadWindowManager1.RadAlert(msg, 400, 200, "پیام سیستم", "RedirectToMain");
return;
}
List <ChangedInfoDTO> oFullChangeList = (List <ChangedInfoDTO>)ViewState["ChangeList"];
foreach (Control item in dvAddressFileds.Controls)
{
if (item is TextBox)
{
TextBox txt = (TextBox)item;
ChangedInfoDTO result = oFullChangeList.Find(i => i.ControlId == txt.ID);
if (result.OldValue != txt.Text)
{
result.NewValue = txt.Text;
result.State = FieldChangeState.Submitted;
}
}
}
ChangedInfoDTO resultDrp;
resultDrp = oFullChangeList.Find(i => i.ControlId == drpLivingCity.ID + "value");
if (resultDrp?.OldValue != drpLivingCity.SelectedValue && drpLivingCity.SelectedItem.Value != "0")
{
resultDrp.NewValue = drpLivingCity.SelectedValue;
resultDrp.State = FieldChangeState.Submitted;
}
//------------------------------
resultDrp = oFullChangeList.Find(i => i.ControlId == drpProvince1.ID + "value");
if (resultDrp?.OldValue != drpProvince1.SelectedValue && drpProvince1.SelectedItem.Value != "0")
{
resultDrp.NewValue = drpProvince1.SelectedValue;
resultDrp.State = FieldChangeState.Submitted;
}
//------------------------------
resultDrp = oFullChangeList.Find(i => i.ControlId == drpProvince2.ID + "value");
if (resultDrp?.OldValue != drpProvince2.SelectedValue && drpProvince2.SelectedItem.Value != "0")
{
resultDrp.NewValue = drpProvince2.SelectedValue;
resultDrp.State = FieldChangeState.Submitted;
}
//------------------------------
resultDrp = oFullChangeList.Find(i => i.ControlId == drpWorkingCity.ID + "value");
if (resultDrp?.OldValue != drpWorkingCity.SelectedValue && drpWorkingCity.SelectedItem.Value != "0")
{
resultDrp.NewValue = drpWorkingCity.SelectedValue;
resultDrp.State = FieldChangeState.Submitted;
}
//------------------------------
ProfessorEditRequestDTO oEditDTO = new ProfessorEditRequestDTO();
oEditDTO.Code_Ostad = Convert.ToInt32(Session[sessionNames.userID_StudentOstad]);
oEditDTO.Createdate = DateTime.Now.ToPeString();
oEditDTO.RequestTypeID = (int)RequestTypeId.EditContactInfo; // درخواست ویرایش اطلاعات تماس
oEditDTO.RequestLogID = (int)RequestLogId.submitted; // در حال بررسی
oEditDTO.HR_InfoPeople_Id = Convert.ToInt32(Session["hrInfoPeopleId"]);
oEditDTO.ChangeSet = 1;
oEditDTO.ChangeList = new List <ChangedInfoDTO>();
foreach (ChangedInfoDTO item in oFullChangeList)
{
if (!string.IsNullOrWhiteSpace(item.NewValue) && item.NewValue != item.OldValue)
{
item.State = FieldChangeState.Submitted;
oEditDTO.ChangeList.Add(item);
}
}
if (oEditDTO.ChangeList.Count == 0)
{
msg = "شما هیچ تغییری در این بخش به وجود نیاورده اید.";
RadWindowManager1.RadAlert(msg, 400, 100, "پیام سیستم", "");
return;
}
int Id = ProfReqBuss.AddNewEditRequest(oEditDTO);
msg = null;
if (Id > 0)
{
CB.InsertIntoStudentLog(oEditDTO.HR_InfoPeople_Id.ToString(), DateTime.Now.ToString("HH:mm"), 13, 32, Id.ToString());
msg = "درخواست شما با شماره " + Id.ToString() + "با موفقیت ثبت گردید.";
Session["hrInfoPeopleId"] = null;
}
else
{
msg = "خطا در هنگام ثبت درخواست ، لطفا مجددا تلاش کنید.";
}
RadWindowManager1.RadAlert(msg, 400, 100, "پیام سیستم", "RedirectToMain");
}
}
protected void RadAsyncUpload1_FileUploaded(object sender, Telerik.Web.UI.FileUploadedEventArgs e)
{
string SavedDoc = string.Empty;
string fileName = string.Empty;
// try
{
int i = RadAsyncUpload1.InitialFileInputsCount;
try
{
using (Stream str = e.File.InputStream);
}
catch
{
string strError = "<Script>FileTimedOut()</script>";
this.Page.ClientScript.RegisterStartupScript(this.Page.GetType(), "strError", strError);
return;
}
using (Stream str = e.File.InputStream)
{
byte[] content = new byte[str.Length];
content = ReadFully(str);
uploadedFiles.Add(content);
fileName = e.File.FileName.Replace("'", "");
Oracle.DataAccess.Client.OracleConnection conn = SQLStatic.SQL.OracleConnection();
try
{
SQLStatic.Sessions.SetSessionValue(session_id, "UPLOAD_MESSAGE", txtmsgUpload.Text);
Data.SavePDF(session_id, fileName, content);
hidUpload.Value = "1";
}
catch
{
}
str.Read(content, 0, content.Length);
ViewState["Docs"] = ViewState["Docs"].ToString() + "<li>" + fileName + "</li>";
}
}
//catch
//{
// ViewState["Error"] = "T";
//}
if (hidcount.Value.Length > 0)
{
hidcount.Value = hidcount.Value.Remove(0, 1);
}
if (hidcount.Value.Length == 0)
{
if (!string.IsNullOrEmpty(ViewState["Docs"].ToString()))
{
SavedDoc = "<br/><u><b>Documents Uploaded Successfully</b></u><ul>" + ViewState["Docs"].ToString() + "</ul>";
}
if (ViewState["Error"].ToString().Equals("F"))
{
ConfromSave(SavedDoc);
}
else
{
if (string.IsNullOrEmpty(ViewState["Docs"].ToString()))
{
SavedDoc = "<br/><br/><u><b>Documents Uploaded Successfully</b></u><ul> None</ul>";
}
else
{
SavedDoc = "<br/><br/><u><b>Documents Uploaded Successfully</b></u><ul>" + ViewState["Docs"].ToString() + "</ul>";
}
RadWindowManager1.RadAlert("Upload Failed. Please Try Again." + SavedDoc, 300, 200, "Upload Failed", null);
}
ViewState["Docs"] = string.Empty;
//btnSubmit.Enabled = false;
}
txtmsgUpload.Text = string.Empty;
rgDoc.Rebind();
string strLE_EE_ID = SQLStatic.Sessions.GetSessionValue(session_id, "LE_EE_ID");
string strGp = "<Script>Go('" + strLE_EE_ID + "')</script>";
this.Page.ClientScript.RegisterStartupScript(this.Page.GetType(), "strGp", strGp);
}
protected void btnRegister_OnClick(object sender, EventArgs e)
{
// lblCommitmentValidate.Visible = false;
if (!Page.IsValid)
{
return; //اینجا باید رد الرت باشه
}
// sadegh saryazdi
//DateTime dateTime = new DateTime(2020, 04, 20);//اول اردیبهشت 1399
//if (DateTime.Now > dateTime&&!CheckRequest()) return;//بررسی سه دفاع
//این شرط را داخل در جاییی که شرط ها بررسی میشوند بگذار
var userId = Session[sessionNames.userID_StudentOstad].ToString();
StudentDefenceRequest request = new StudentDefenceRequest();
var defInfo = _requestHandler.GetDefenceInformation(userId);
if (userId == "99900999")
{
request = new StudentDefenceRequest
{
CategoryId = 2,
Subject = "ارزیابی عملکرد تلفیقی فرایند بیولوژیکی و فیزیکوشیم",
Location = "2",
Status = 0,
IssuerId = 99900999,
IssuerName = "محمد سرگزی",
Capacity = 1,
DefenceSubject = "ارزیابی عملکرد تلفیقی فرایند بیولوژیکی و فیزیکوشیم",
DaneshId = 3,
CourseName = "ارزیابی عملکرد تلفیقی فرایند بیولوژیکی و فیزیکوشیم",
RequestDate = txtDate.Text,
RequestStartTime = txtTime.SelectedTime.Value.Ticks,
OnlineTeacherRole = ckbAprroveOnline.Checked ? drpRoleTeacher.SelectedValue : string.Empty,
OnlineFirstTeacherName = ckbAprroveOnline.Checked && rcbOnlineTeacher.Items[0].Checked ? rcbOnlineTeacher.Items[0].Text : string.Empty,
OnlineFirstTeacherId = ckbAprroveOnline.Checked && rcbOnlineTeacher.Items[0].Checked ? rcbOnlineTeacher.Items[0].Value.Substring(3) : string.Empty,
//sadeghsaryazdi
FlagDoingMeetingOnline = chkDoingOnlineDefence.Checked ? true : false,
// = ckbAprroveOnline.Checked ? drpRoleTeacher.SelectedItem.Text : string.Empty,
UseOwnPc = rdbOwnSystem.Checked,
UserId = Session[sessionNames.userID_StudentOstad].ToString(),
Gender = "1"
};
request.AcceptPropDate = "1397/11/27";
}
else
{
request = new StudentDefenceRequest
{
CategoryId = (int)Category.InPersonClass,
Subject = StudentDefenceRequest.StaticStudentRequest().Subject,
Location = ((int)Location.Raam).ToString(),
Status = (int)RequestStatus.submitted,
IssuerId = Convert.ToInt32(Session[sessionNames.userID_StudentOstad].ToString()),
IssuerName = defInfo.StudentFullName,
Capacity = StudentDefenceRequest.StaticStudentRequest().Capacity,
DefenceSubject = defInfo.DefenceSubject,
DaneshId = Convert.ToInt32(defInfo.CollegeId),
CourseName = defInfo.DefenceSubject,
RequestDate = txtDate.Text,
RequestStartTime = txtTime.SelectedTime.Value.Ticks,
OnlineTeacherRole = ckbAprroveOnline.Checked ? drpRoleTeacher.SelectedValue : string.Empty,
OnlineFirstTeacherName = ckbAprroveOnline.Checked && rcbOnlineTeacher.Items[0].Checked ? rcbOnlineTeacher.Items[0].Text : string.Empty,
OnlineFirstTeacherId = ckbAprroveOnline.Checked && rcbOnlineTeacher.Items[0].Checked ? rcbOnlineTeacher.Items[0].Value.Substring(3) : string.Empty,
//sadeghsaryazdi
FlagDoingMeetingOnline = chkDoingOnlineDefence.Checked ? true : false,
// = ckbAprroveOnline.Checked ? drpRoleTeacher.SelectedItem.Text : string.Empty,
UseOwnPc = rdbOwnSystem.Checked,
UserId = Session[sessionNames.userID_StudentOstad].ToString(),
Gender = defInfo.studentGender
};
request.AcceptPropDate = defInfo.GroupAcceptDate;
}
if (rcbOnlineTeacher.Items.Count > 1)
{
request.OnlineSecondTeacherName = ckbAprroveOnline.Checked && rcbOnlineTeacher.Items[1].Checked
? rcbOnlineTeacher.Items[1].Text
: string.Empty;
request.OnlineSecondTeacherId = ckbAprroveOnline.Checked && rcbOnlineTeacher.Items[1].Checked
? rcbOnlineTeacher.Items[1].Value.Substring(3)
: string.Empty;
}
request.RequestEndTime = request.RequestStartTime + _requestHandler.GetDefenceInMeetingLength(Convert.ToInt32(defInfo.CollegeId));
var reqId = 0;
request.IsRequestEducation = false;
var message = _requestHandler.CreateStudentRequestV2(out reqId, request);
if (message.Contains("ok"))
{
defInfo.RequestDate = request.RequestDate;
defInfo.StartTime = request.RequestStartTime;
defInfo.EndTime = request.RequestEndTime;
string scrp = message.Substring(2);
//PrevPage = ViewState["PrevPage"].ToString();
//var uri = Request.UrlReferrer.ToString();
// _prevPage = uri.Replace("StudentAddRequest.aspx", "StudentReview.aspx");
//var requestRawUrl = Request.RawUrl;
CommonBusiness CommonBusiness = new CommonBusiness();
CommonBusiness.InsertIntoStudentLog(Session[sessionNames.userID_StudentOstad].ToString(), DateTime.Now.ToString("HH:mm"), 11, 40, "ثبت درخواست رزرو جلسه دفاع توسط دانشجو", reqId);
string address = "../Forms/StudentReview.aspx";
string resdirectFunc = "function redirectToLast(){ window.location= '" + address + "' ; }";
RadWindowManager1.RadAlert(scrp, 500, 100, "پیام سیستم", resdirectFunc);
//DateTime dateTimeEnd = RequestHandler.WorkingDays24h(DateTime.Now);
DateTime dateTimeEnd = RequestHandler.WorkingDays12h(DateTime.Now);
SendSmsContactBuisnes.SendSmsOsForOstadsDefence(userId, request.IssuerName,
request.RequestDate, dateTimeEnd.Date.ToPeString(), txtTime.SelectedTime.Value.ToString().Substring(0, 5), dateTimeEnd.Hour + ":" + dateTimeEnd.Minute);
}
else
{
RadWindowManager1.RadAlert(message, 500, 100, "خطا", "");
}
}
protected void RadToolBar1_ButtonClick(object sender, RadToolBarEventArgs e)
{
switch (e.Item.Value)
{
case "Save":
if (txtDenNgay.SelectedDate == null || txtTuNgay.SelectedDate <= txtDenNgay.SelectedDate)
{
if (iDNghi == null)
{
Nghi ng = new Nghi();
ng.IDNhanVien = userid;
ng.IDLoaiNghi = Convert.ToInt32(cboLoaiNghi.SelectedValue);
ng.TuNgay = txtTuNgay.SelectedDate;
ng.DenNgay = txtDenNgay.SelectedDate;
if (lbSoNgayXinNghi.Text != "")
{
ng.SoNgayDaNghi = Convert.ToInt32(lbSoNgayXinNghi.Text);
}
ng.LyDoNghi = txtLyDo.Text;
ng.DuocNghi = null;
if (cboNhanVienBanGiao.SelectedValue == "")
{
ng.IDNhanVienBanGiao = null;
}
else
{
ng.IDNhanVienBanGiao = Convert.ToInt32(cboNhanVienBanGiao.SelectedValue);
}
ng.NguoiTao = ng.NguoiCapNhat = userid;
ng.NgayTao = ng.NgayCapNhat = DateTime.Now;
_entities.AddToNghis(ng);
_entities.SaveChanges();
grvNghi.Rebind();
RadWindowManager1.RadAlert("Thêm thông tin thành công", 285, 100, "Thông báo", null);
}
else
{
Nghi ng = _entities.Nghis.Where(d => d.IDNghiPhep == iDNghi).First();
if (ng.DuocNghi == null)
{
ng.IDLoaiNghi = Convert.ToInt32(cboLoaiNghi.SelectedValue);
ng.TuNgay = txtTuNgay.SelectedDate;
ng.DenNgay = txtDenNgay.SelectedDate;
if (lbSoNgayXinNghi.Text != "")
{
ng.SoNgayDaNghi = Convert.ToInt32(lbSoNgayXinNghi.Text);
}
ng.LyDoNghi = txtLyDo.Text;
if (cboNhanVienBanGiao.SelectedValue == "")
{
ng.IDNhanVienBanGiao = null;
}
else
{
ng.IDNhanVienBanGiao = Convert.ToInt32(cboNhanVienBanGiao.SelectedValue);
}
ng.NguoiCapNhat = userid;
ng.NgayCapNhat = DateTime.Now;
_entities.SaveChanges();
grvNghi.Rebind();
RadWindowManager1.RadAlert("Sửa thông tin thành công", 285, 100, "Thông báo", null);
}
}
}
else
{
lbSoNgayXinNghi.Text = "Lỗi: thời gian xin nghỉ không hợp lý";
}
break;
case "Reset":
cboLoaiNghi.SelectedIndex = -1;
cboNhanVienBanGiao.SelectedIndex = -1;
txtTuNgay.Clear();
txtDenNgay.Clear();
lbSoNgayXinNghi.Text = "";
txtLyDo.Text = "";
lbSoNgayXinNghi.Text = "";
iDNghi = null;
ToogleControl(null);
break;
case "Report":
RadWindowManager1.RadAlert("Chức năng chưa hoàn thiện", 285, 100, "Lỗi", "");
break;
}
}
protected void RadAjaxManager1_AjaxRequest(object sender, AjaxRequestEventArgs e)
{
string valor = e.Argument;
string tipo = valor.Substring(0, 1);
valor = valor.Substring(1);
switch (tipo)
{
case "A":
DateTime fechaBaja;
if (DateTime.TryParse(valor, out fechaBaja))
{
revision.Dispositivo.Caducado = true;
revision.Dispositivo.FechaBaja = fechaBaja;
ctx.SaveChanges();
CntLainsaSci.EliminarRevisionesPendientes(revision.Dispositivo, ctx, revision);
string mensaje = String.Format("El dispositivo ha sido dado de baja con fecha {0:dd/MM/yyyy}", fechaBaja);
RadWindowManager1.RadAlert(mensaje, 330, 110, "DADO DE BAJA", "retornoAlert");
RadAjaxManager1.ResponseScripts.Add(String.Format("closeWindowRefreshGrid('{0}', 'edit');", caller));
//string jCommand = String.Format("radalert('{0}');", mensaje);
//RadAjaxManager1.ResponseScripts.Add(jCommand);
}
else
{
string mensaje = (string)GetGlobalResourceObject("ResourceLainsaSci", "DateNeeded");
mensaje = "La fecha introducida es incorrecta";
RadWindowManager1.RadAlert(mensaje, 330, 110, "AVISO", "retornoAlert");
//string jCommand = String.Format("radalert('{0}');", mensaje);
//RadAjaxManager1.ResponseScripts.Add(jCommand);
}
break;
case "B":
if (valor == "true")
{
// quiere descambiar
Sustitucion s = revision.Sustitucions[0]; // solo tiene que estar el cambio inicial
Sustitucion ns = new Sustitucion()
{
DispositivoOriginal = s.DispositivoSustituto,
DispositivoSustituto = s.DispositivoOriginal,
Fecha = DateTime.Now,
Revision = revision
};
ns.Estado = "REALIZADA"; // si llega aquí es realizada fijo.
// control de estados
Dispositivo dspo = ns.DispositivoOriginal;
Dispositivo dsps = ns.DispositivoSustituto;
dspo.Estado = "A";
if (dsps.Funcion == "R")
{
dsps.Estado = "S";
}
else
{
dsps.Estado = "N";
}
dsps.Posicion = dsps.Posicion;
dspo.Posicion = "SUSTITUIDOS";
ctx.Add(ns);
}
else
{
Sustitucion s = revision.Sustitucions[0]; // solo tiene que estar el cambio inicial
s.DispositivoOriginal.Funcion = "R";
}
// Como si hubiera pulsado el botón.
UnloadData(revision);
CntLainsaSci.CTXGuardar(ctx);
CntLainsaSci.EliminarInferiores(revision, ctx);
CntLainsaSci.ProgramarSiguienteRevision(revision, ctx, true);
CntLainsaSci.ProgramarInferiores(revision, ctx);
RadAjaxManager1.ResponseScripts.Add(String.Format("closeWindowRefreshGrid('{0}', 'edit');", caller));
break;
}
}
protected void btn_ShowInfo_Click(object sender, EventArgs e)
{
img_ExportToExcel1.Visible = false;
img_ExportToExcel2.Visible = false;
if (ddl_Term.SelectedValue == null || ddl_Term.SelectedValue == "0")
{
RadWindowManager1.RadAlert("لطفا ترم را انتخاب نمایید", 0, 100, "پیام", "");
}
else if (ddl_Degree.SelectedValue == null || ddl_Degree.SelectedValue == "0")
{
RadWindowManager1.RadAlert("لطفا مقطع را انتخاب نمایید", 0, 100, "پیام", "");
}
else
{
if (rdb_Mardudi.Checked == true)
{
PSD.Percent = txt_Percent.Text;
if (txt_Percent.Text == null || txt_Percent.Text == "")
{
txt_Percent.Text = "0";
}
dtResault = FRB.GetStudentsProbation(ddl_Term.SelectedValue, int.Parse(ddl_Degree.SelectedValue), int.Parse(txt_Percent.Text));
if (dtResault.Rows.Count == 0)
{
RadWindowManager1.RadAlert("رکوردی وجود ندارد", 0, 100, "پیام", "");
}
else
{
//Report
img_ExportToExcel1.Visible = true;
this.StiWebViewer1.ResetReport();
StiWebViewer1.Visible = true;
StiReport rpt = new StiReport();
rpt.Load(Server.MapPath("../Report/ReportStudentProbation.mrt"));
rpt.ReportCacheMode = StiReportCacheMode.On;
rpt.Dictionary.Databases.Clear();
rpt.Dictionary.Databases.Add(new StiSqlDatabase("Connection1", CB.ReportConnection.ToString()));
rpt.Compile();
rpt.CompiledReport.DataSources["[Faculty].[SP_StudentsProbation]"].Parameters["@Term"].ParameterValue = ddl_Term.SelectedValue;
rpt.CompiledReport.DataSources["[Faculty].[SP_StudentsProbation]"].Parameters["@Degree"].ParameterValue = int.Parse(ddl_Degree.SelectedValue);
rpt.CompiledReport.DataSources["[Faculty].[SP_StudentsProbation]"].Parameters["@Percent"].ParameterValue = int.Parse(txt_Percent.Text);
rpt.RegData(dtResault);
rpt.Dictionary.Synchronize();
//rpt.Show();
StiWebViewer1.Report = rpt;
StiWebViewer1.Visible = true;
//rpt.Print(true);
}
}
else
{
PSD.Percent = txt_PercentGhabul.Text;
if (txt_PercentGhabul.Text == null || txt_PercentGhabul.Text == "")
{
txt_PercentGhabul.Text = "0";
}
dtResault = FRB.GetStudentsProbationAcceptance(ddl_Term.SelectedValue, int.Parse(ddl_Degree.SelectedValue), int.Parse(txt_PercentGhabul.Text));
if (dtResault.Rows.Count == 0)
{
RadWindowManager1.RadAlert("رکوردی وجود ندارد", 0, 100, "پیام", "");
}
else
{
//Report
img_ExportToExcel2.Visible = true;
this.StiWebViewer1.ResetReport();
StiWebViewer1.Visible = true;
StiReport rpt = new StiReport();
rpt.Load(Server.MapPath("../Report/ReportStudentProbationAcceptance.mrt"));
rpt.ReportCacheMode = StiReportCacheMode.On;
rpt.Dictionary.Databases.Clear();
rpt.Dictionary.Databases.Add(new StiSqlDatabase("Connection1", CB.ReportConnection.ToString()));
rpt.Compile();
rpt.CompiledReport.DataSources["[Faculty].[SP_StudentsProbationAcceptance]"].Parameters["@Term"].ParameterValue = ddl_Term.SelectedValue;
rpt.CompiledReport.DataSources["[Faculty].[SP_StudentsProbationAcceptance]"].Parameters["@Degree"].ParameterValue = int.Parse(ddl_Degree.SelectedValue);
rpt.CompiledReport.DataSources["[Faculty].[SP_StudentsProbationAcceptance]"].Parameters["@Percent"].ParameterValue = int.Parse(txt_PercentGhabul.Text);
rpt.RegData(dtResault);
rpt.Dictionary.Synchronize();
//rpt.Show();
StiWebViewer1.Report = rpt;
StiWebViewer1.Visible = true;
//rpt.Print(true);
}
}
}
}
protected void RadToolBar1_ButtonClick(object sender, RadToolBarEventArgs e)
{
switch (e.Item.Value)
{
case "Save":
if (idHopDong == null)
{
HopDongLD hd = new HopDongLD();
if (idNhanVien == null)
{
hd.IDNhanVien = Convert.ToInt32(cboNguoiLD.SelectedValue);
}
else
{
hd.IDNhanVien = idNhanVien;
}
if (_entities.HopDongLDs.Where(h => h.SoHD == txtSoHD.Text).FirstOrDefault() == null)
{
hd.SoHD = txtSoHD.Text;
hd.NgayKyHD = txtNgayKyHD.SelectedDate;
hd.IDLoaiHD = Convert.ToInt32(cboLoaiHD.SelectedValue);
hd.TuNgay = txtTuNgayKyHD.SelectedDate;
hd.DenNgay = txtDenNgayKyHD.SelectedDate;
hd.IDNguoiDaiDien = Convert.ToInt32(cboNguoiDaiDien.SelectedValue);
hd.IDCoCauToChuc = Convert.ToInt32(cboDonViLamViec.SelectedValue);
hd.DiaDiemLamViec = txtDiaDiemLamViec.Text;
hd.TrinhDoChuyenMon = txtTrinhDoChuyenMon.Text;
hd.IDChucDanhNghiepVu = Convert.ToInt32(cboChucDanhNghiepVu.SelectedValue);
hd.IDChucDanhCongViec = Convert.ToInt32(cboChucDanhCongViec.SelectedValue);
hd.MucHuong = Convert.ToInt32(txtMucHuong.Text);
hd.IDBacNgach = Convert.ToInt32(cboBac.SelectedValue);
if (txtPhuCapCV.Text != "")
{
hd.PhuCapCV = Convert.ToDecimal(txtPhuCapCV.Text);
}
else
{
hd.PhuCapCV = null;
}
if (txtMucLuongToiThieu.Text != "")
{
hd.MucLuongToiThieu = Convert.ToDecimal(txtMucLuongToiThieu.Text);
}
else
{
hd.MucLuongToiThieu = null;
}
if (txtTepDinhKem.UploadedFiles.Count > 0)
{
string targetFolder = txtTepDinhKem.TargetFolder;
hd.TepDinhKem = Path.Combine(Server.MapPath(targetFolder), txtSoHD.Text.Replace("/", "_") + "_" + txtTepDinhKem.UploadedFiles[0].FileName.Replace(" ", "_"));
}
hd.GhiChu = txtGhiChu.Text;
hd.NguoiTao = hd.NguoiCapNhat = idUser;
hd.NgayTao = hd.NgayCapNhat = DateTime.Now;
_entities.AddToHopDongLDs(hd);
try
{
_entities.SaveChanges();
LoadGrid();
RadWindowManager1.RadAlert("Thêm thông tin thành công", 285, 100, "Thông báo", "");
}
catch (Exception ex)
{
RadWindowManager1.RadAlert("Thêm thông tin thất bại", 285, 100, "Lỗi", "");
throw ex;
}
}
else
{
RadWindowManager1.RadAlert("Đã tồn tại số hợp đồng này", 285, 100, "Lỗi", "");
}
}
else
{
cboNguoiLD.ShowDropDownOnTextboxClick = false;
cboNguoiLD.ShowToggleImage = false;
HopDongLD hopDongLD = _entities.HopDongLDs.Where(h => h.IDHopDongLD == idHopDong).FirstOrDefault();
hopDongLD.SoHD = txtSoHD.Text;
hopDongLD.NgayKyHD = txtNgayKyHD.SelectedDate;
hopDongLD.IDLoaiHD = Convert.ToInt32(cboLoaiHD.SelectedValue);
hopDongLD.TuNgay = txtTuNgayKyHD.SelectedDate;
hopDongLD.DenNgay = txtDenNgayKyHD.SelectedDate;
hopDongLD.IDNguoiDaiDien = Convert.ToInt32(cboNguoiDaiDien.SelectedValue);
hopDongLD.IDCoCauToChuc = Convert.ToInt32(cboDonViLamViec.SelectedValue);
hopDongLD.DiaDiemLamViec = txtDiaDiemLamViec.Text;
hopDongLD.TrinhDoChuyenMon = txtTrinhDoChuyenMon.Text;
hopDongLD.IDChucDanhNghiepVu = Convert.ToInt32(cboChucDanhNghiepVu.SelectedValue);
hopDongLD.IDChucDanhCongViec = Convert.ToInt32(cboChucDanhCongViec.SelectedValue);
hopDongLD.MucHuong = Convert.ToInt32(txtMucHuong.Text);
hopDongLD.IDBacNgach = Convert.ToInt32(cboBac.SelectedValue);
if (txtPhuCapCV.Text != "")
{
hopDongLD.PhuCapCV = Convert.ToDecimal(txtPhuCapCV.Text);
}
if (txtMucLuongToiThieu.Text != "")
{
hopDongLD.MucLuongToiThieu = Convert.ToDecimal(txtMucLuongToiThieu.Text);
}
hopDongLD.GhiChu = txtGhiChu.Text;
if (txtTepDinhKem.UploadedFiles.Count > 0)
{
string targetFolder = txtTepDinhKem.TargetFolder;
hopDongLD.TepDinhKem = Path.Combine(Server.MapPath(targetFolder), txtSoHD.Text.Replace("/", "_") + "_" + txtTepDinhKem.UploadedFiles[0].FileName.Replace(" ", "_"));
}
hopDongLD.NgayCapNhat = DateTime.Now;
hopDongLD.NguoiCapNhat = idUser;
try
{
_entities.SaveChanges();
RadWindowManager1.RadAlert("Sửa thông tin thành công", 285, 100, "Thông báo", "");
LoadGrid();
}
catch (Exception ex)
{
RadWindowManager1.RadAlert("Sửa thông tin thất bại", 285, 100, "Lỗi", "");
throw ex;
}
}
break;
case "Reset":
txtSoHD.Text = "/" + DateTime.Now.Year.ToString() + "/HĐLĐ/AITS.";
txtNgayKyHD.Clear();
cboLoaiHD.SelectedIndex = -1;
txtTuNgayKyHD.Clear();
txtDenNgayKyHD.Clear();
cboNguoiLD.SelectedIndex = -1;
cboChucDanhNghiepVu.SelectedIndex = -1;
cboChucDanhCongViec.SelectedIndex = -1;
cboNgach.SelectedIndex = -1;
LoadBacNgach(Convert.ToInt32(cboNgach.SelectedValue));
LoadHeSoBacNgach();
txtTrinhDoChuyenMon.Text = "";
cboDonViLamViec.SelectedIndex = -1;
txtMucLuongBHXH.Text = "";
txtMucHuong.Text = "100";
txtPhuCapCV.Text = "";
txtMucLuongToiThieu.Text = "";
cboNguoiDaiDien.SelectedIndex = -1;
txtGhiChu.Text = "";
txtTepDinhKem.UploadedFiles.Clear();
idHopDong = null;
break;
case "Report":
Session["PrintType"] = "HopDong";
Response.Redirect("InHD.aspx");
break;
case "PhuLuc":
if (Session["idHD"] != null)
{
Response.Redirect("ThemPhuLucHD.aspx");
}
else
{
RadWindowManager1.RadAlert("Chưa chọn hợp đồng", 285, 100, "Lưu ý", null);
}
break;
}
}
protected void btnRegister_OnClick(object sender, EventArgs e)
{
string message;
if (!Page.IsValid)
{
return; //اینجا باید رد الرت باشه
}
var defenceInformation = _requestHandler.GetDefenceInformation(hdnUserId.Value.ToString());
var request = new StudentDefenceRequest
{
CategoryId = (int)Category.InPersonClass,
Subject = StudentDefenceRequest.StaticStudentRequest().Subject,
Location = ((int)Location.Raam).ToString(),
Status = (int)RequestStatus.sent,
IssuerId = Convert.ToInt32(hdnUserId.Value.ToString()),
IssuerName = defenceInformation.StudentFullName,
Capacity = StudentDefenceRequest.StaticStudentRequest().Capacity,
DefenceSubject = defenceInformation.DefenceSubject,
DaneshId = Convert.ToInt32(defenceInformation.CollegeId),
CourseName = defenceInformation.DefenceSubject,
RequestDate = txtDate.Text,
RequestStartTime = txtTime.SelectedTime.Value.Ticks,
OnlineTeacherRole = ckbAprroveOnline.Checked ? drpRoleTeacher.SelectedValue : string.Empty,
OnlineFirstTeacherName = ckbAprroveOnline.Checked && rcbOnlineTeacher.Items[0].Checked ? rcbOnlineTeacher.Items[0].Text : string.Empty,
OnlineFirstTeacherId = ckbAprroveOnline.Checked && rcbOnlineTeacher.Items[0].Checked ? rcbOnlineTeacher.Items[0].Value.Substring(3) : string.Empty,
IsEquippingResource = ckbOnlineShow.Checked,
// = ckbAprroveOnline.Checked ? drpRoleTeacher.SelectedItem.Text : string.Empty,
UseOwnPc = rdbOwnSystem.Checked,
UserId = Session[sessionNames.userID_Karbar].ToString(),
Gender = defenceInformation.studentGender,
//sadeghsaryazdi
FlagDoingMeetingOnline = chkDoingOnlineDefence.Checked ? true : false,
};
if (rcbOnlineTeacher.Items.Count > 1)
{
request.OnlineSecondTeacherName = ckbAprroveOnline.Checked && rcbOnlineTeacher.Items[1].Checked
? rcbOnlineTeacher.Items[1].Text
: string.Empty;
request.OnlineSecondTeacherId = ckbAprroveOnline.Checked && rcbOnlineTeacher.Items[1].Checked
? rcbOnlineTeacher.Items[1].Value.Substring(3)
: string.Empty;
}
request.RequestEndTime = request.RequestStartTime + _requestHandler.GetDefenceInMeetingLength(Convert.ToInt32(defenceInformation.CollegeId));
request.AcceptPropDate = defenceInformation.GroupAcceptDate;
request.Id = Convert.ToInt32(hdnrequestId.Value);
request.IsRequestEducation = true;
message = _requestHandler.UpdateStudentRequestForEducation(request);
if (message.Contains("ok"))
{
defenceInformation.RequestDate = request.RequestDate;
defenceInformation.StartTime = request.RequestStartTime;
defenceInformation.EndTime = request.RequestEndTime;
string scrp = message.Substring(2);
string address = "EducationStudentReview.aspx" + "?id=" + generaterandomstr() + "@A" + "0" + "-" + generaterandomstr();
var userID = Convert.ToInt32(Session[sessionNames.userID_Karbar]);
var comman = new CommonBusiness();
comman.InsertIntoUserLog(userID, DateTime.Now.ToString("HH:mm"), 11, 166, string.Format("{0}", "ویرایش درخواست جلسه دفاع توسط دانشکده"), Convert.ToInt32(request.Id));
//sadegh saryazdy
// _requestHandler.UpdateRequest_LinkMeeting(stcode,"")
string resdirectFunc = "function redirectToLast(){ window.location= '" + address + "' ; }";
RadWindowManager1.RadAlert(scrp, 500, 100, "پیام سیستم", resdirectFunc);
}
else
{
RadWindowManager1.RadAlert(message, 500, 100, "خطا", "");
}
}
void ShowMessage(string msg)
{
//ClientScript.RegisterStartupScript(Page.GetType(), "validation", "<script language = 'javascript' > alert('" + msg + "');</ script > ");
RadWindowManager1.RadAlert(msg, 300, 200, "My Alert", "callBackFn", "myAlertImage.png");
}
protected void gridcccmex_ItemCommand(object sender, GridCommandEventArgs e)
{
int _idCampo = 0;
//Int64? _idCampo2 = null;
string _nombre = "";
bool bit = false;
if (e.CommandName == "updGrid")
{
cargarcentros();
limpiarRegistros();
bit = true;
}
else if (e.CommandName == "editGrid")
{
foreach (GridDataItem item in gridcccmex.MasterTableView.Items)
{
if (item.Selected == true)
{
_idCampo = Convert.ToInt32(item.GetDataKeyValue("IdInst"));
//_idCampo2 = convertir.toNInt64(item.GetDataKeyValue("IdCentro"));
_nombre = item.GetDataKeyValue("Nombre").ToString();
addcentro.Text = _nombre.ToString();
addidCentro.Text = _idCampo.ToString();
addidCentro.ReadOnly = true;
cmdcentro.Text = "Actualizar";
Session["opTipo"] = 2;
bit = true;
break;
}
}
}
else if (e.CommandName == "delGrid")
{
foreach (GridDataItem item in gridcccmex.MasterTableView.Items)
{
if (item.Selected == true)
{
_idCampo = convertir.toInt32(item.GetDataKeyValue("IdInst"));
String param = eliminarCat(_idCampo);
if (param.CompareTo("F") == 0)
{
RadWindowManager1.RadAlert("Se genero el Siguiente Error: " + Session["error_Reporte"].ToString() + ", Favor de verificar con el Administrador de sistemas...", 450, 300, "Eliminando Centro", null);
}
else
{
RadWindowManager1.RadAlert("Centro eliminado con éxito...", 300, 150, "Eliminando Centro", null);
gridcccmex.MasterTableView.SortExpressions.Clear();
gridcccmex.MasterTableView.GroupByExpressions.Clear();
cargarcentros();
}
bit = true;
break;
}
}
}
if (bit == false)
{
RadWindowManager1.RadAlert("Debe seleccionar un registro....", 300, 100, "Registros", null);
}
}
protected void LanzarAviso(string aviso)
{
RadWindowManager1.RadAlert(aviso, null, null, "AVISO", "noHaceNada");
}
protected void Btn_Show_Click(object sender, EventArgs e)
{
if (ddl_Term.SelectedValue == null)
{
ddl_Term.SelectedValue = "0";
}
if (ddl_Degree.SelectedValue == null)
{
ddl_Degree.SelectedValue = "0";
}
if (ddl_Sex.SelectedValue == null)
{
ddl_Sex.SelectedValue = "0";
}
if (txt_SalVorud.Text == null || txt_SalVorud.Text == "")
{
txt_SalVorud.Text = "0";
}
if (ddl_Education.SelectedValue == null)
{
ddl_Education.SelectedValue = "0";
}
if (txt_StCode.Text == string.Empty || txt_StCode.Text == "")
{
txt_StCode.Text = "0";
Session["stcode"] = txt_StCode.Text;
}
if (LDD.Field == null)
{
LDD.Field = "0";
}
dtResault = ERB.GetLisAdamSabtenam(ddl_Term.SelectedValue.ToString(), txt_StCode.Text, int.Parse(ddl_Degree.SelectedValue.ToString()), int.Parse(ddl_Education.SelectedValue.ToString()), int.Parse(ddl_Sex.SelectedValue.ToString()), txt_SalVorud.Text.ToString(), int.Parse(ddl_Field.SelectedValue));
if (dtResault.Rows.Count == 0)
{
RadWindowManager1.RadAlert("رکوردی وجود ندارد", 0, 100, "پیغام", "");
}
else
{
img_ExportToExcel1.Visible = true;
this.StiWebViewer1.ResetReport();
StiWebViewer1.Visible = true;
StiReport rpt = new StiReport();
rpt.Load(Server.MapPath("../Report/ReportNotRegistrationLicense.mrt"));
rpt.Dictionary.Databases.Clear();
rpt.Dictionary.Databases.Add(new StiSqlDatabase("Connection1", cb.ReportConnection.ToString()));
rpt.Compile();
rpt.CompiledReport.DataSources["[Education].[SP_NotRegistrationLicense]"].Parameters["@StCode"].ParameterValue = txt_StCode.Text;
rpt.CompiledReport.DataSources["[Education].[SP_NotRegistrationLicense]"].Parameters["@Degree"].ParameterValue = int.Parse(ddl_Degree.SelectedValue);
rpt.CompiledReport.DataSources["[Education].[SP_NotRegistrationLicense]"].Parameters["@Education"].ParameterValue = int.Parse(ddl_Education.SelectedValue);
rpt.CompiledReport.DataSources["[Education].[SP_NotRegistrationLicense]"].Parameters["@Sex"].ParameterValue = int.Parse(ddl_Sex.SelectedValue);
rpt.CompiledReport.DataSources["[Education].[SP_NotRegistrationLicense]"].Parameters["@SalVorud"].ParameterValue = txt_SalVorud.Text;
rpt.CompiledReport.DataSources["[Education].[SP_NotRegistrationLicense]"].Parameters["@Field"].ParameterValue = int.Parse(ddl_Field.SelectedValue);
rpt.CompiledReport.DataSources["[Education].[SP_NotRegistrationLicense]"].Parameters["@Term"].ParameterValue = ddl_Term.SelectedValue;
rpt.RegData(dtResault);
rpt.Dictionary.Synchronize();
//rpt.Show();
StiWebViewer1.Report = rpt;
StiWebViewer1.ProcessExcel2007Request();
StiWebViewer1.ShowExportToExcel.ToString();
StiWebViewer1.Visible = true;
//rpt.Print(true);
}
Session["stcode"] = null;
}
