private void DeleteNodeBtn_Click(object sender, RoutedEventArgs e)
{
int nodeId;
if (!Int32.TryParse(((TreeViewItem)(treeView.SelectedItem)).Tag.ToString(), out nodeId))
{
return;
}
if (organs.Where(s => s.ParentNodeId == nodeId).Count() > 0)
{
ErrorHandler.ShowErrorMessage("تنها امکان حذف برگ ها وجود دارد");
return;
}
var entity = new RTMEntities();
try
{
RTM.OrganizationalChart delete = entity.OrganizationalCharts.Where(s => s.ChartNodeId == nodeId).First();
entity.OrganizationalCharts.DeleteObject(delete);
entity.SaveChanges();
ErrorHandler.NotifyUser(Errors.Deleted);
}
catch (System.Exception ex)
{
ErrorHandler.ShowErrorMessage("در حال حاضر امکان دسترسی به سرور وجود ندارد");
return;
}
RefreshTreeView();
}
private void SearchBtn_Click(object sender, RoutedEventArgs e)
{
var entity = new RTMEntities();
var name = (FNameTxt.Text.Trim() == "")?null :FNameTxt.Text;
var family = (LNameTxt.Text.Trim() == "") ? null : LNameTxt.Text;
var organ = (OrgCom.Text.Trim() == "") ? null : OrgCom.Text;
var position = (PositionTxt.Text.Trim() == "") ? null : PositionTxt.Text;
List <User> results = new List <User>();
var loader = new BusyIndicator();
this.layoutRoot.Children.Add(loader);
Task.Factory.StartNew(delegate
{
try
{
results = DataManagement.SearchUsers(name, family, position, organ);
}
catch (System.Exception ex)
{
MessageBox.Show("تماس با سرور با مشکل مواجه شد");
}
}).ContinueWith(delegate
{
if (results.Count > 0)
{
Grid.ItemsSource = results;
}
else
{
Grid.ItemsSource = null;
}
this.layoutRoot.Children.Remove(loader);
}, TaskScheduler.FromCurrentSynchronizationContext());
}
private void AddNodeBtn_Click(object sender, RoutedEventArgs e)
{
if (string.IsNullOrEmpty(treeView.SelectedValue.ToString()) || string.IsNullOrEmpty(OrganTxt.Text.Trim()))
{
return;
}
var newOrgan = new RTM.OrganizationalChart();
var entity = new RTMEntities();
string selectedNode = ((TreeViewItem)(treeView.SelectedItem)).Header.ToString();
int nodeId = 0;
if (((TreeViewItem)(treeView.SelectedItem)).Tag == null)
{
return;
}
if (!Int32.TryParse(((TreeViewItem)(treeView.SelectedItem)).Tag.ToString(), out nodeId))
{
return;
}
newOrgan.Title = OrganTxt.Text;
newOrgan.ParentNodeId = nodeId;
try
{
entity.OrganizationalCharts.AddObject(newOrgan);
entity.SaveChanges();
ErrorHandler.NotifyUser(Errors.Saved);
}
catch (System.Exception ex)
{
ErrorHandler.ShowErrorMessage("در حال حاضر امکان دسترسی به سرور وجود ندارد");
return;
}
RefreshTreeView();
}
private void crystalReportsViewer1_Loaded(object sender, RoutedEventArgs e)
{
var report = new RTM.Report.GenralRep.Users_();
var en = new RTMEntities();
report.SetDatabaseLogon("ratec", "ratec");
var result = (
from items in list
from orgs in en.OrganizationalCharts
from pos in en.Positions
where orgs.ChartNodeId == items.OrganizationPosition &&
pos.PositionId == items.PositionId
select new us
{
UserId = items.UserId,
Name = (string)items.Name,
Family = (string)items.Family,
SocialNumber = (string)items.SocialNumber,
OrganizationPosition = (int)items.OrganizationPosition,
PositionId = (int)items.PositionId,
Status = (string)items.Status,
PhoneNumber = (string)items.PhoneNumber,
Title = (string)orgs.Title,
PositionTitle = (string)pos.PositionTitle
}).ToList();
report.SetDataSource(result);
crystalReportsViewer1.ViewerCore.ReportSource = report;
}
//public static List<TenderingReport> SearchTenderingReport(List<Tendering> list)
//{
// try
// {
// using (var en = new RTMEntities())
// {
// var res = (
// from tens in list
// from reqs in en.ContractorRequests
// from wins in en.TenderingResults
// from orgs1 in en.OrganizationalCharts
// from orgs2 in en.OrganizationalCharts
// from c in en.Contractors
// where tens.TenderingId == wins.TenderingId &&
// tens.ContractorRequestId == reqs.ContractorRequestId &&
// reqs.RequestingUnit == orgs1.ChartNodeId &&
// reqs.SupervisionId == orgs2.ChartNodeId &&
// wins.FirstContractorWinnerId == c.ContractorId
// select new TenderingReport
// {
// ContractorRequestId = reqs.ContractorRequestId,
// RequestNumber = reqs.RequestNumber,
// RequestDate = (DateTime)reqs.RequestDate,
// TenderingId = tens.TenderingId,
// ChartNodeId = orgs1.ChartNodeId,
// ChartNodeId1 = orgs2.ChartNodeId,
// TenderingNumber = tens.TenderingNumber,
// TenderingType = tens.TenderingType,
// ProjectTitle = reqs.ProjectTitle,
// Title = orgs1.Title,
// tmp1 = orgs1.Title,
// Title1 = orgs2.Title,
// tmp2 = orgs2.Title,
// RequiredField = reqs.RequiredField,
// Renewal = wins.Renewal,
// TenderingResultId = wins.TenderingResultId,
// ContractorId = c.ContractorId,
// CompanyName = c.CompanyName,
// NationalIdNumber = c.NationalIdNumber,
// TenderingRecordDate = (DateTime)tens.TenderingRecordDate,
// Date = (DateTime)wins.Date
// }
// ).ToList();
// //var res2 = (
// // from tens in list
// // //from reqs in en.ContractorRequests
// // //from orgs1 in en.OrganizationalCharts
// // //from orgs2 in en.OrganizationalCharts
// // where true
// // //tens.ContractorRequestId == reqs.ContractorRequestId
// // //reqs.RequestingUnit == orgs1.ChartNodeId &&
// // //reqs.SupervisionId == orgs2.ChartNodeId
// // select new TenderingReport
// // {
// // ContractorRequestId = 0,//reqs.ContractorRequestId,
// // RequestNumber = "",//reqs.RequestNumber,
// // RequestDate = DateTime.Now,//(DateTime)reqs.RequestDate,
// // TenderingId = 0,//tens.TenderingId,
// // ChartNodeId = 0,//orgs1.ChartNodeId,
// // ChartNodeId1 = 0,//orgs2.ChartNodeId,
// // TenderingNumber =tens.TenderingNumber,
// // TenderingType = "",//tens.TenderingType,
// // ProjectTitle = "",//reqs.ProjectTitle,
// // Title = "",//orgs1.Title,
// // Title1 = "",//orgs2.Title,
// // RequiredField = "",//reqs.RequiredField,
// // Renewal = false,
// // TenderingResultId = 0,
// // ContractorId =0,
// // CompanyName = "",
// // NationalIdNumber = "",
// // TenderingRecordDate = DateTime.Now,//(DateTime)tens.TenderingRecordDate,
// // Date =DateTime.Now
// // }
// // );
// var temp = from items in res select items.TenderingId;
// var res2 = (
// from tens in list
// from reqs in en.ContractorRequests
// from orgs1 in en.OrganizationalCharts
// from orgs2 in en.OrganizationalCharts
// where
// tens.ContractorRequestId == reqs.ContractorRequestId &&
// !temp.Contains(tens.TenderingId) &&
// reqs.RequestingUnit == orgs1.ChartNodeId &&
// reqs.SupervisionId == orgs2.ChartNodeId
// select new TenderingReport
// {
// ContractorRequestId = reqs.ContractorRequestId,
// RequestNumber = reqs.RequestNumber,
// RequestDate = (DateTime)reqs.RequestDate,
// TenderingId = tens.TenderingId,
// ChartNodeId = orgs1.ChartNodeId,
// ChartNodeId1 = orgs2.ChartNodeId,
// TenderingNumber = tens.TenderingNumber,
// TenderingType = tens.TenderingType,
// ProjectTitle = reqs.ProjectTitle,
// Title = orgs1.Title,
// tmp1 = orgs1.Title,
// Title1 = orgs2.Title,
// tmp2 = orgs2.Title,
// RequiredField = reqs.RequiredField,
// //Renewal = wins.Renewal,
// //TenderingResultId = tens.TenderingId,
// //ContractorId = tens.TenderingId,
// //CompanyName = c.CompanyName,
// //NationalIdNumber = c.NationalIdNumber,
// TenderingRecordDate = (tens.TenderingRecordDate!=null?(DateTime)tens.TenderingRecordDate:new DateTime()),
// //Date = (DateTime)wins.Date
// });
// var t = res.Union(res2).ToList();
// var x = new DateConverterGrid();
// foreach (var item in t)
// {
// try
// {
// item.PersianDate1 = (x).Convert(item.RequestDate, null, null, null).ToString();
// }
// catch (System.Exception ex)
// {
// item.PersianDate1 = "";
// }
// try
// {
// item.PersianDate2 = (item.TenderingRecordDate!=null?(x).Convert(item.TenderingRecordDate, null, null, null).ToString():"");
// }
// catch (System.Exception ex)
// {
// item.PersianDate2 = "";
// }
// try
// {
// item.PersianDate3 = (x).Convert(item.Date, null, null, null).ToString();
// }
// catch (System.Exception ex)
// {
// item.PersianDate3 = "";
// }
// }
// return t;
// }
// }
// catch (System.Exception ex)
// {
// return null;
// }
//}
public static List <TenderingReport> SearchTenderingReport(List <Tendering> list)
{
try
{
using (var en = new RTMEntities())
{
var res = (
from tens in list
from reqs in en.ContractorRequests
from orgs1 in en.OrganizationalCharts
from orgs2 in en.OrganizationalCharts
where
tens.ContractorRequestId == reqs.ContractorRequestId &&
reqs.RequestingUnit == orgs1.ChartNodeId &&
reqs.SupervisionId == orgs2.ChartNodeId
select new TenderingReport
{
ContractorRequestId = reqs.ContractorRequestId,
RequestNumber = reqs.RequestNumber,
RequestDate = (DateTime)reqs.RequestDate,
TenderingId = tens.TenderingId,
TenderingNumber = tens.TenderingNumber,
TenderingType = tens.TenderingType,
ProjectTitle = reqs.ProjectTitle,
RequiredField = reqs.RequiredField,
Title = orgs1.Title,
tmp1 = orgs1.Title,
Title1 = orgs2.Title,
tmp2 = orgs2.Title,
TenderingRecordDate = (tens.TenderingRecordDate != null ? (DateTime)tens.TenderingRecordDate : new DateTime())
}).ToList();
var x = new DateConverterGrid();
foreach (var item in res)
{
try
{
item.PersianDate1 = (x).Convert(item.RequestDate, null, null, null).ToString();
}
catch (System.Exception ex)
{
item.PersianDate1 = "";
}
try
{
item.PersianDate2 = (item.TenderingRecordDate != null ? (x).Convert(item.TenderingRecordDate, null, null, null).ToString() : "");
}
catch (System.Exception ex)
{
item.PersianDate2 = "";
}
}
return(res);
}
}
catch (System.Exception ex)
{
return(null);
}
}
public static List <EvalReport> SearchEvaluationReport(List <Evaluation> list)
{
try
{
using (var en = new RTMEntities())
{
var res = (
from ev in list
select new EvalReport
{
EvaluationId = ev.EvaluationId,
MeetingType = ev.MeetingType,
TenderingNumber = ev.TenderingNumber,
NoticeNumber = ev.NoticeNumber,
MeetingDate = (DateTime)ev.MeetingDate,
PersianDate = "",
Title = ev.Title
}
).ToList();
var x = new DateConverterGrid();
foreach (var item in res)
{
item.PersianDate = (x).Convert(item.MeetingDate, null, null, null).ToString();
}
return(res);
}
}
catch (System.Exception ex)
{
return(null);
}
}
void bw_DoWork(object sender, DoWorkEventArgs e)
{
var user = e.Argument as UserPackage;
RTM.User users = new RTM.User();
try
{
var entity = new RTMEntities();
users = DataManagement.AuthenticateUser(user.UserName, user.Password);
if (users != null)
{
UserData.CurrentUser = users;
UserData.CurrentPoistion = entity.Positions.Where(s => s.PositionId == UserData.CurrentUser.PositionId).First();
UserData.CurrentAccessRight = entity.AccessRights.Where(s => s.AccessId == UserData.CurrentUser.AccessId).First();
UserData.OrganizationalPosition = entity.OrganizationalCharts.Where(s => s.ChartNodeId == UserData.CurrentUser.OrganizationPosition).First();
entity.Users.Where(s => s.UserId == UserData.CurrentUser.UserId).FirstOrDefault().LastLogin = DateTime.Now;
entity.SaveChanges();
NavigationHandler.NavigateToPageThreadSafe(this, "UserManagement/StartPage.xaml", false);
}
else
{
ErrorHandler.ShowErrorMessage("نام کاربری یا کلمه عبور اشتباه است");
Password.Dispatcher.BeginInvoke((Action) delegate
{
Password.Password = "";
}, System.Windows.Threading.DispatcherPriority.Normal);
}
}
catch (System.Exception ex)
{
ErrorHandler.ShowErrorMessage("ارتباط با سرور امکان پذیر نیست" + ex.Message);
}
}
private void page_Loaded(object sender, RoutedEventArgs e)
{
Header.CurrentRequest = DataManagement.RetrieveTenderingContractorRequest(CurrentTendering);
dataGrid2.Items.Clear();
dataGrid4.Items.Clear();
var d1 = DataManagement.RetrieveMeetingUserParticipant(CurrentMeeting);
foreach (var item in d1)
{
dataGrid2.Items.Add(item);
}
var d2 = DataManagement.RetrieveJustificationMeetingContractor(CurrentMeeting);
var d3 = from items in DataManagement.RetrieveTenderingDocumentRecieve(CurrentTendering) select items.ContractorId;
if (d2.Count > 0)
{
foreach (var item in d2)
{
dataGrid4.Items.Add(item);
}
}
else
{
using (var en = new RTMEntities())
{
var d4 = from items in en.Contractors where d3.Contains(items.ContractorId) select items;
foreach (var item in d4)
{
dataGrid4.Items.Add(item);
}
}
}
}
public object SelectedConntractorInfo(Contractor c)
{
try
{
using (var en = new RTMEntities())
{
var res = (from contractor in en.Contractors
from bid in en.Bids
where contractor.ContractorId == c.ContractorId &&
contractor.ContractorId == bid.ContractorId &&
bid.TenderingId == CurrentTendering.TenderingId
select new
{
//Plus = bid.Plus,
//Minus = bid.Minus,
Coeffecient = bid.Coefficient,
SN = contractor.NationalIdNumber,
Price = bid.Bid1
}
).FirstOrDefault();
return(res);
}
}
catch (System.Exception ex)
{
return(null);
}
}
private void Page_Loaded(object sender, RoutedEventArgs e)
{
bw.DoWork += new DoWorkEventHandler(bw_DoWork);
bw.RunWorkerCompleted += new RunWorkerCompletedEventHandler(bw_RunWorkerCompleted);
DocType.ItemsSource = DataManagement.RetrieveContractorDocuments();
var e2 = new RTMEntities();
dataGrid.ItemsSource = fileList;
}
public object Convert(object value, Type targetType, object parameter, System.Globalization.CultureInfo culture)
{
try
{
using (var en = new RTMEntities())
{
var t = (from items in en.ContractTypes where items.ContractTypeId == (int)value select items).FirstOrDefault();
return(t.ContractType1);
}
}
catch (System.Exception ex)
{
}
return("");
}
public static List <ContractReport> SearchContractReport(List <Contract> list)
{
try
{
using (var en = new RTMEntities())
{
var res = (
from crt in list
from c1 in en.Contractors
from type in en.ContractTypes
from tens in en.Tenderings
where crt.ContractTypeId == type.ContractTypeId &&
c1.ContractorId == crt.ContractorId &&
//c2.ContractorId == crt.ConsultantId &&
tens.TenderingNumber == crt.TenderingSystemCode
select new ContractReport
{
Contractid = crt.Contractid,
ContractorId = c1.ContractorId,
/*ContractorId_1 = c2.ContractorId,*/
ContractTypeId = type.ContractTypeId,
ContractNumber = crt.ContractNumber,
TenderingId = tens.TenderingId,
TenderingSystemCode = crt.TenderingSystemCode,
AgreementDate = (DateTime)crt.AgreementDate,
ContractTtile = crt.ContractTtile,
CompanyName = c1.CompanyName,
//CompanyName1 = c2.CompanyName,
ContractType = type.ContractType1,
PersianDate = "",
//tmp1 = c2.CompanyName,
ContractBudget = (decimal)(crt.ContractBudget)
}).ToList();
var x = new DateConverterGrid();
foreach (var item in res)
{
item.PersianDate = (x).Convert(item.AgreementDate, null, null, null).ToString();
}
return(res);
}
}
catch (System.Exception ex)
{
return(null);
}
}
private void crystalReportsViewer1_Loaded(object sender, RoutedEventArgs e)
{
var Entity = new RTMEntities();
var report = new RTM.Report.GenralRep.Contractors_();
////////Login Info
ConnectionInfo crConnection = new ConnectionInfo();
crConnection.ServerName = @"GIS-SERVER";
crConnection.DatabaseName = "ratec";
crConnection.UserID = "ratec";
crConnection.Password = "******";
CrystalDecisions.CrystalReports.Engine.Tables tables = report.Database.Tables;
foreach (CrystalDecisions.CrystalReports.Engine.Table table in tables)
{
CrystalDecisions.Shared.TableLogOnInfo tableLogonInfo = table.LogOnInfo;
tableLogonInfo.ConnectionInfo = crConnection;
table.ApplyLogOnInfo(tableLogonInfo);
}
////////
//report.SetDatabaseLogon("ratec", "ratec");
var result = (from items in MyList
select new cc
{
CompanyName = items.CompanyName != null?(string)items.CompanyName:"-",
NationalIdNumber = items.NationalIdNumber != null ? (string)items.NationalIdNumber : "-",
CompanyType = items.CompanyType != null ? (string)items.CompanyType : "-",
Telephone = items.Telephone != null?(string)items.Telephone:"-",
Fax = items.Fax != null?(string)items.Fax:"-",
CeoEmailAddress = items.CeoEmailAddress != null?(string)items.CeoEmailAddress:"-",
CompanyField1 = items.CompanyField1 != null?(string)items.CompanyField1:"-",
CompanyBase1 = items.CompanyBase1 != null?(int)items.CompanyBase1:5,
Design = items.Design != null?(bool)items.Design:false,
Procurement = items.Procurement != null?(bool)items.Procurement:false,
BuildAndOperation = items.BuildAndOperation != null?(bool)items.BuildAndOperation:false,
Finance = items.Finance != null?(bool)items.Finance:false,
ContractorId = (int)items.ContractorId,
}).ToList();
report.SetDataSource(result);
crystalReportsViewer1.ViewerCore.ReportSource = report;
}
private void EditNodeBtn_Click(object sender, RoutedEventArgs e)
{
try
{
int nodeId;
if (!Int32.TryParse(((TreeViewItem)(treeView.SelectedItem)).Tag.ToString(), out nodeId))
{
return;
}
var entity = new RTMEntities();
RTM.OrganizationalChart changeItem = entity.OrganizationalCharts.Where(s => s.ChartNodeId == nodeId).First();
changeItem.Title = OrganTxt.Text;
entity.SaveChanges();
ErrorHandler.NotifyUser(Errors.Saved);
}
catch (System.Exception ex)
{
ErrorHandler.ShowErrorMessage("در حال حاضر امکان دسترسی به سرور وجود ندارد");
}
RefreshTreeView();
}
private void SearchBtn_Click(object sender, RoutedEventArgs e)
{
list = DataManagement.SearchTenderings("", TenderTitleTxt.Text, TenderSystemCodeTxt.Text, "", RequestNumber.Text, null, null, null, null, null, null, (RequestUnitCom.SelectedIndex == -1) ? null : (int?)RequestUnitCom.SelectedValue, null, "", null, null, true);
using (var en = new RTMEntities())
{
var t = from tenders in list
from reqs in en.ContractorRequests
where
tenders.ContractorRequestId == reqs.ContractorRequestId
select new
{
RequestNumber = reqs.RequestNumber,
TenderingId = tenders.TenderingId,
NoticeNumber = tenders.TenderingNumber,
ProjectTitle = reqs.ProjectTitle,
RequestingUnit = reqs.RequestingUnit,
};
Grid.ItemsSource = t;
}
}
public static List <RegulReport> SearchRegulationReport(List <Regulation> list)
{
try
{
using (var en = new RTMEntities())
{
var res = (
from r in list
from s in en.OrganizationalCharts
from x2 in en.IssuingReferences
where s.ChartNodeId == r.ActingReferenceId &&
x2.IssuingReferenceId == r.IssuingReferenceId
select new RegulReport
{
RegulationId = r.RegulationId,
Title = r.Title,
tmp1 = s.Title,
tmp2 = x2.Title,
Type = r.Type,
Group = r.Group,
IssuingReferenceId = r.IssuingReferenceId,
IssuingDate = (DateTime)r.IssuingDate,
PersianDate = ""
}
).ToList();
var x = new DateConverterGrid();
foreach (var item in res)
{
item.PersianDate = (x).Convert(item.IssuingDate, null, null, null).ToString();
}
return(res);
}
}
catch (System.Exception ex)
{
return(null);
}
}
private void UpdateGridList()
{
var en = new RTMEntities();
var result = from file in en.TenderingDocumentFiles
from rel in en.TenderingDocumentFileRelations
from doc in en.TenderingDocuments
where file.TenderingDocumentFileId == rel.TenderingDocumentFileId &&
rel.TenderingDocumentId == doc.TenderingDocumentId &&
rel.TenderingId == CurrentTendering.TenderingId
orderby doc.DocumentIndex, file.AttachedDate descending
select new UI5GridItems
{
TenderingDocumentId = rel.TenderingDocumentId,
Version = file.Version,
AttachedDate = file.AttachedDate,
DocumentIndex = doc.DocumentIndex
};
GridList = result.ToList();
Grid.ItemsSource = GridList;
Grid.Items.Refresh();
}
private void page_loaded(object sender, RoutedEventArgs e)
{
Header.CurrentRequest = DataManagement.RetrieveTenderingContractorRequest(CurrentTendering);
if (ResetTenderRadio.IsChecked == false)
{
WinnerRadio.IsChecked = true;
}
FirstWinnerCom.ItemsSource = DataManagement.RetrieveContractorsWhoSubmitPacket(CurrentTendering);
SecondWinnerCom.ItemsSource = DataManagement.RetrieveContractorsWhoSubmitPacket(CurrentTendering);
this.DataContext = CurrentResult;
if (CurrentResult.Renewal == false)
{
WinnerRadio.IsChecked = true;
}
if (CurrentResult.FirstContractorWinnerId == null)
{
using (var en = new RTMEntities())
{
bids = (from items in en.Bids where items.TenderingId == CurrentTendering.TenderingId orderby items.Bid1 select items).ToList();
if (bids.Count == 0)
{
return;
}
int c1 = bids[0].ContractorId;
CurrentResult.FirstContractorWinnerId = c1;
if (bids.Count == 1)
{
return;
}
else if ((bids[1].Bid1 - bids[0].Bid1) > CurrentTendering.GuarantyPrice)
{
return;
}
int c2 = bids[1].ContractorId;
CurrentResult.SecondContractorWinnerId = c2;
}
}
}
private void crystalReportsViewer1_Loaded(object sender, RoutedEventArgs e)
{
var report = new RTM.Report.GenralRep.Log_();
var en = new RTMEntities();
report.SetDatabaseLogon("ratec", "ratec");
var result = (from item in en.Logs
from users in en.Users
from pos in en.Positions
where item.Subsystem == sub &&
item.UserId == users.UserId &&
users.PositionId == pos.PositionId &&
(fromdate == null || item.Date >= fromdate) &&
(todate == null || item.Date <= todate)
select new LogV
{
Date = (DateTime)item.Date,
Action = (string)item.Action,
Description = "",
MachineName = (string)item.MachineName,
Subsystem = (string)item.Subsystem,
UserId = (int)users.UserId,
Name = (string)users.Name,
Family = (string)users.Family,
PositionTitle = (string)pos.PositionTitle,
}).ToList();
foreach (var x in result)
{
x.Description = ((new DateConverterGrid()).Convert((DateTime)x.Date, null, null, null)).ToString();
}
report.SetDataSource(result);
crystalReportsViewer1.ViewerCore.ReportSource = report;
}
public static bool ValidContractNumber(string contractNumber, Contract c)
{
try
{
using (var en = new RTMEntities())
{
var t = (from items in en.Contracts where items.ContractNumber == contractNumber select items).FirstOrDefault();
if (t == null || t.Contractid == c.Contractid)
{
return(true);
}
else
{
return(false);
}
}
}
catch (System.Exception ex)
{
ErrorHandler.ShowErrorMessage(Errors.ConnectionError);
return(false);
}
}
private void UpdateGridList()
{
var en = new RTMEntities();
var result = from file in en.ContractFiles
from rel in en.ContractDocFileRelations
from doc in en.ContractDocuments
where file.FileId == rel.FileId &&
rel.ContractDocId == doc.ContractDocumentId &&
doc.DocumentIndex > 3 &&
rel.ContractId == CurrentContract.Contractid
select new ContractFilesGridItem
{
FileId = file.FileId,
Version = file.Version,
AttachedDate = file.AttachedDate,
DocumentIndex = doc.DocumentIndex
};
GridList = result.ToList();
Grid1.ItemsSource = GridList;
Grid1.Items.Refresh();
}
internal static bool ValidPaymentDraft(string paymentNumber, PaymentDraft p)
{
try
{
using (var en = new RTMEntities())
{
var t = (from items in en.PaymentDrafts where items.PaymentDraftNumber == paymentNumber select items).FirstOrDefault();
if (t == null || t.PaymentDraftId == p.PaymentDraftId)
{
return(true);
}
else
{
return(false);
}
}
}
catch (System.Exception ex)
{
ErrorHandler.ShowErrorMessage(Errors.ConnectionError);
return(false);
}
}
internal static bool ValidSocialSecurityNumber(string p, User u)
{
try
{
using (var en = new RTMEntities())
{
var t = (from items in en.Users where items.SocialNumber == p select items).FirstOrDefault();
if (t == null || t.UserId == u.UserId)
{
return(true);
}
else
{
return(false);
}
}
}
catch (System.Exception ex)
{
ErrorHandler.ShowErrorMessage(Errors.ConnectionError);
return(false);
}
}
internal static Tendering ExistTenderingNumber(string p, Contract c)
{
try
{
using (var en = new RTMEntities())
{
var t = (from items in en.Tenderings where items.TenderingNumber == p select items).FirstOrDefault();
if (t == null || t.TenderingNumber == c.TenderingSystemCode)
{
return(null);
}
else
{
return(t);
}
}
}
catch (System.Exception ex)
{
ErrorHandler.ShowErrorMessage(Errors.ConnectionError);
return(null);
}
}
private void Page_Loaded(object sender, RoutedEventArgs e)
{
var entity = new RTMEntities();
var busy = new BusyIndicator();
this.LayOutRoot.Children.Add(busy);
Task.Factory.StartNew(delegate
{
try
{
var organizationchart = entity.OrganizationalCharts;
organs = organizationchart.Select(s => s).ToList();
root = organs.Where(s => s.ParentNodeId == null).First();
}
catch (System.Exception ex)
{
ErrorHandler.ShowErrorMessage("ارتباط با پایگاه داده امکان پذیر نبود");
Page_Loaded(sender, e);
}
}).ContinueWith(delegate
{
RefreshTreeView();
this.LayOutRoot.Children.Remove(busy);
//string text = "";
//foreach (var item in organs)
//{
// string temp = "";
// var t = item;
// while (t.OrganizationalChart2!=null)
// {
// temp += "\t";
// t = t.OrganizationalChart2;
// }
// text += temp + item.Title+"\n";
//}
}, TaskScheduler.FromCurrentSynchronizationContext());
}
private void crystalReportsViewer1_Loaded(object sender, RoutedEventArgs e)
{
var report = new RTM.Report.Report10.TenderResult();
report.SetDatabaseLogon("ratec", "ratec");
ContractorRequest z = RTM.Classes.DataManagement.RetrieveTenderingContractorRequest(Current);
report.SetParameterValue("ReqID", z.ContractorRequestId);
report.SetParameterValue("DateParam", DateConverter.ConvertDate((DateTime)(((z.RequestDate).Value).Date)).Substring(4));
report.SetParameterValue("DateParam1", DateConverter.ConvertDate((DateTime)(((CurrentResult.Date).Value).Date)).Substring(4));
if (CurrentResult.Renewal == true)
{
report.SetParameterValue("Result", "تجدید مناقصه");
report.SetParameterValue("Co1", "-----");
report.SetParameterValue("Co2", "-----");
report.SetParameterValue("Nat1", "-----");
report.SetParameterValue("Nat2", "-----");
report.SetParameterValue("Bid1", 0);
report.SetParameterValue("Bid2", 0);
if (CurrentResult.RenewalNote == null)
{
report.SetParameterValue("Note", "");
}
else
{
report.SetParameterValue("Note", CurrentResult.RenewalNote);
}
}
else
{
var Entity = new RTMEntities();
var x = (from n in Entity.Contractors where n.ContractorId == CurrentResult.FirstContractorWinnerId select n).FirstOrDefault();
var y = (from n in Entity.Contractors where n.ContractorId == CurrentResult.SecondContractorWinnerId select n).FirstOrDefault();
report.SetParameterValue("Result", "اعلام برنده");
if (x == null)
{
report.SetParameterValue("Co1", "----");
}
else
{
report.SetParameterValue("Co1", x.CompanyName);
}
if (y == null)
{
report.SetParameterValue("Co2", "----");
}
else
{
report.SetParameterValue("Co2", y.CompanyName);
}
if (x == null)
{
report.SetParameterValue("Nat1", "----");
}
else
{
report.SetParameterValue("Nat1", x.NationalIdNumber);
}
if (y == null)
{
report.SetParameterValue("Nat2", "----");
}
else
{
report.SetParameterValue("Nat2", y.NationalIdNumber);
}
if (x == null)
{
report.SetParameterValue("Bid1", 0);
}
else if (CurrentResult.FirstBid == null)
{
RTM.Classes.ErrorHandler.NotifyUser("قیمت ها به درستی ثبت نشده");
return;
}
else
{
report.SetParameterValue("Bid1", CurrentResult.FirstBid);
}
if (y == null)
{
report.SetParameterValue("Bid2", 0);
}
else if (CurrentResult.SecondBid == null)
{
RTM.Classes.ErrorHandler.NotifyUser("قیمت ها به درستی ثبت نشده");
return;
}
else
{
report.SetParameterValue("Bid2", CurrentResult.SecondBid);
}
if (CurrentResult.Notes == null)
{
report.SetParameterValue("Note", "");
}
else
{
report.SetParameterValue("Note", CurrentResult.Notes);
}
}
crystalReportsViewer1.ViewerCore.ReportSource = report;
}
private void CalculateExtrasContract()
{
using (var en = new RTMEntities())
{
var complements = (
from items in en.ContractDocFileRelations
where items.ContractId == CurrentContract.Contractid &&
(items.ContractDocId == 1 || items.ContractDocId == 2)
select items.FileId).ToList();
var lastPercentage = (
from items in en.ContractFiles
where complements.Contains(items.FileId) &&
items.Is25Percent == true
select items).ToList().LastOrDefault();
if (lastPercentage != null)
{
report.SetParameterValue("25Num", lastPercentage.NotificationNumber);
report.SetParameterValue("25Date", DateConverter.ConvertDate((DateTime)(lastPercentage.NotificationDate).Value.Date).Substring(4));
}
else
{
report.SetParameterValue("25Num", "-");
report.SetParameterValue("25Date", "-");
}
double?SumPercentage = (double?)(
from items in en.ContractFiles
where complements.Contains(items.FileId) &&
items.Is25Percent == true
select items.Percent).ToList().Sum();
SumPercentage = SumPercentage * (double?)CurrentContract.ContractBudget / 100;
report.SetParameterValue("25Price", SumPercentage == null?0:SumPercentage);
double?amount = (double?)(
from items in en.ContractFiles
where complements.Contains(items.FileId) &&
items.IsExtend == true
select items.Amount).ToList().Sum();
report.SetParameterValue("CompletePrice", amount == null?0:amount);
var lastComplement = (
from items in en.ContractFiles
where complements.Contains(items.FileId) &&
items.IsExtend == true
select items).ToList().LastOrDefault();
if (lastComplement != null)
{
report.SetParameterValue("CompleteNum", lastComplement.NotificationNumber);
report.SetParameterValue("CompleteDate", DateConverter.ConvertDate((DateTime)(lastComplement.AttachedDate).Value.Date).Substring(4));
}
else
{
report.SetParameterValue("CompleteNum", "-");
report.SetParameterValue("CompleteDate", "-");
}
report.SetParameterValue("PrintDate", DateConverter.ConvertDate((DateTime)(CurrentDraft.Date).Value.Date).Substring(4));
if (CurrentDraft.ModelTitle == null)
{
report.SetParameterValue("ModelTitle", "-");
}
else
{
report.SetParameterValue("ModelTitle", CurrentDraft.ModelTitle);
}
var consultant = (from n in en.Contractors where n.ContractorId == CurrentContract.ConsultantId select n).FirstOrDefault();
if (consultant == null)
{
report.SetParameterValue("Consultant", "-");
}
else
{
report.SetParameterValue("Consultant", consultant.CompanyName);
}
if (CurrentDraft.Notes == null || CurrentDraft.Notes.Trim() == "")
{
report.SetParameterValue("NoteParam", "-");
}
else
{
report.SetParameterValue("NoteParam", CurrentDraft.Notes);
}
if (CurrentContract.ContractTtile == null || CurrentContract.ContractTtile.Trim() == "")
{
report.SetParameterValue("ContractTitle", "-");
}
else
{
report.SetParameterValue("ContractTitle", CurrentContract.ContractTtile);
}
report.SetParameterValue("User", "صادرکننده : " + UserData.CurrentUser.Name + " " + UserData.CurrentUser.Family);
}
}
private void crystalReportsViewer1_Loaded(object sender, RoutedEventArgs e)
{
var Entity = new RTMEntities();
////////Login Info
ConnectionInfo crConnection = new ConnectionInfo();
crConnection.ServerName = @"Gis-Server";
crConnection.DatabaseName = "ratec";
crConnection.UserID = "ratec";
crConnection.Password = "******";
//crConnection.ServerName = @".";
//crConnection.DatabaseName = "ratec";
//crConnection.UserID = "sa";
//crConnection.Password = "******";
CrystalDecisions.CrystalReports.Engine.Tables tables = report.Database.Tables;
foreach (CrystalDecisions.CrystalReports.Engine.Table table in tables)
{
CrystalDecisions.Shared.TableLogOnInfo tableLogonInfo = table.LogOnInfo;
tableLogonInfo.ConnectionInfo = crConnection;
table.ApplyLogOnInfo(tableLogonInfo);
}
////////
var x = (from n in Entity.OrganizationalCharts where n.ChartNodeId == CurrentContract.SupervisingUnitHigher select n).FirstOrDefault();
CalculateExtrasContract();
//report.SetDatabaseLogon("ratec", "ratec");
report.SetParameterValue("ContractId", CurrentContract.Contractid);
report.SetParameterValue("DraftId", CurrentDraft.PaymentDraftId);
report.SetParameterValue("Date", DateConverter.ConvertDate((DateTime)(((CurrentContract.ContractDate).Value).Date)).Substring(4));
if (Convert.ToString(CurrentDraft.PayableAmount) != string.Empty)
{
report.SetParameterValue("Amount", CurrentDraft.PayableAmount);
}
else
{
report.SetParameterValue("Amount", 0);
}
if (x != null)
{
report.SetParameterValue("Supervisor", x.Title);
}
else
{
report.SetParameterValue("Supervisor", "-");
}
////////////////////////////////////////////////////////////////////////// you have a problem here in your code
decimal B;
if (CurrentDraft.EmployerInsurancePercentage != 0 || CurrentDraft.EmployerInsurancePercentage != null)
{
B = ((((decimal)CurrentDraft.CurrentSituationDraft) - ((decimal)CurrentDraft.PerviousSituationDraft)) * (((decimal)(CurrentDraft.EmployerInsurancePercentage)) / 100));
}
else
{
B = ((((decimal)CurrentDraft.CurrentSituationDraft) - ((decimal)CurrentDraft.PerviousSituationDraft)));
}
report.SetParameterValue("Bimeh", B);
report.SetParameterValue("HaveTrans", HaveTrans);
// added by naseri
PNumberTString dd = new PNumberTString();
decimal Subtract = (((decimal)CurrentDraft.CurrentSituationDraft) - ((decimal)CurrentDraft.PerviousSituationDraft));
report.SetParameterValue("Subtract", Subtract);
try
{
report.SetParameterValue("NumToWord", dd.num2str(Convert.ToString(Convert.ToInt64(CurrentDraft.PayableAmount))));
}
catch (Exception)
{}
if (!HaveTrans)
{
report.SetParameterValue("User", string.Empty);
}
// added by naseri
crystalReportsViewer1.ViewerCore.ReportSource = report;
}