private void crystalReportsViewer1_Loaded(object sender, RoutedEventArgs e)
{
if (CurrentTender.StageId < (int)Stages.TenderingMeeting)
{
ErrorHandler.NotifyUser("ایجاد صورتجلسه توجیهی تا قبل از تایید نهایی درخواست مناقصه امکان پذیر نیست");
return;
}
var report = new RTM.Report.Report3.Report3_Main();
report.SetDatabaseLogon("ratec", "ratec");
report.SetParameterValue("IdParam", CurrentMeet.MeetingId);
report.SetParameterValue("MeetNumParam", CurrentMeet.MeetingId.ToString());
report.SetParameterValue(1, DateConverter.ConvertDate((DateTime)(CurrentTender.BriefingSessionDate).Value.Date).Substring(4));
report.SetParameterValue(2, DateConverter.ConvertDate((DateTime)(CurrentTender.RecievingDocumentsDate).Value.Date).Substring(4));
report.SetParameterValue(3, DateConverter.ConvertDate((DateTime)(CurrentTender.RecievingDocumentDeadline).Value.Date).Substring(4));
report.SetParameterValue(4, DateConverter.ConvertDate((DateTime)(CurrentTender.SuggestionRecieveDate).Value.Date).Substring(4));
report.SetParameterValue(5, DateConverter.ConvertDate((DateTime)(CurrentTender.SuggestionOpenDate).Value.Date).Substring(4));
string GarantyType;
if (CurrentTender.StockWarranty == true)
{
GarantyType = "اوراق مشارکت";
}
else if (CurrentTender.LcWarranty == true)
{
GarantyType = "ضمانتنامه بانکی";
}
else if (CurrentTender.DraftWarranty == true)
{
GarantyType = "فیش واریزی";
}
else
{
GarantyType = "";
}
report.SetParameterValue(6, GarantyType);
report.SetParameterValue("LocParam", CurrentTender.Location);
report.SetParameterValue("PriceParam", CurrentTender.GuarantyPrice.ToString().Split('.')[0]);
if (CurrentTender.TenderingNumber != null)
{
report.SetParameterValue("TenderNumParam", CurrentTender.TenderingNumber);
}
else
{
report.SetParameterValue("TenderNumParam", "ندارد");
}
if (CurrentMeet.MeetingDescription.Trim() == "" || CurrentMeet.MeetingDescription == null)
{
report.SetParameterValue("NoteParam", "");
}
else
{
report.SetParameterValue("NoteParam", CurrentMeet.MeetingDescription);
}
crystalReportsViewer1.ViewerCore.ReportSource = report;
}
private void crystalReportsViewer1_Loaded(object sender, RoutedEventArgs e)
{
var report = new RTM.Report.PriceEvalReport.PriceEval_Main();
report.SetDatabaseLogon("ratec", "ratec");
report.SetParameterValue("TenderId", CurrentTender.TenderingId);
report.SetParameterValue("EvalId", CurrentEval.EvaluationId);
report.SetParameterValue("Date", DateConverter.ConvertDate((DateTime)(CurrentEval.MeetingDate).Value.Date).Substring(4));
crystalReportsViewer1.ViewerCore.ReportSource = report;
}
private CarData GetCarData(ISearchContext car)
{
var name = car.FindElement(LblChildCarName).Text;
var price = StringUtils.CutNonDigitCharacters(car.FindElement(LblChildCarPrice).Text);
var year = StringUtils.CutNonDigitCharacters(car.FindElement(LblChildCarYear).Text);
var date = StringUtils.CutCharactersAfterComma(car.FindElement(LblChildCarDate).Text);
var carData = new CarData(name, int.Parse(price), year, DateConverter.ConvertDate(date));
return(carData);
}
private CarData GetCarData(ISearchContext car)
{
var name = car.FindElement(LblChildCarName).Text;
var price = car.FindElement(LblChildCarPrice).Text;
var year = car.FindElement(LblChildCarYear).Text;
var date = GetCarDate(car);
return(new CarData(name, int.Parse(price.Substring(0, price.Length - 3).Replace(" ", string.Empty)), year,
DateConverter.ConvertDate(date)));
}
private void crystalReportsViewer1_Loaded(object sender, RoutedEventArgs e)
{
var report = new RTM.Report.Report5.Report5_Main();
report.SetDatabaseLogon("ratec", "ratec");
report.SetParameterValue(1, DateConverter.ConvertDate((DateTime)(CurrentMeet.MeetingDate)));
report.SetParameterValue(2, DateConverter.ConvertDate((DateTime)(CurrentTender.RecievingDocumentsDate)));
report.SetParameterValue(3, DateConverter.ConvertDate((DateTime)(CurrentTender.RecievingDocumentDeadline)));
report.SetParameterValue(4, DateConverter.ConvertDate((DateTime)(CurrentTender.SuggestionRecieveDate)));
report.SetParameterValue(5, DateConverter.ConvertDate((DateTime)(CurrentTender.SuggestionOpenDate)));
string GarantyType;
string RefrenceType;
if (CurrentTender.StockWarranty == true)
{
GarantyType = "اوراق مشارکت";
}
else if (CurrentTender.LcWarranty == true)
{
GarantyType = "ضمانتنامه بانکی";
}
else if (CurrentTender.DraftWarranty == true)
{
GarantyType = "فیش واریزی";
}
else
{
GarantyType = "";
}
report.SetParameterValue(6, GarantyType);
if (CurrentMeet.ExtendByApplicant == true)
{
RefrenceType = "درخواست واحد متقاضی";
}
else if (CurrentMeet.ExtendByCommittee == true)
{
RefrenceType = "نظر کمیسیون";
}
else
{
RefrenceType = "";
}
report.SetParameterValue(7, RefrenceType);
report.SetParameterValue(8, DateConverter.ConvertDate((DateTime)(CurrentMeet.ExtendedRecieveDate)));
crystalReportsViewer1.ViewerCore.ReportSource = report;
}
private void crystalReportsViewer1_Loaded(object sender, RoutedEventArgs e)
{
var report = new RTM.Report.Report6.Report6_Main();
report.SetDatabaseLogon("ratec", "ratec");
if (CurrentTender.TenderingNumber != null)
{
report.SetParameterValue("TenderingNumParam", CurrentTender.TenderingNumber.ToString());
}
else
{
report.SetParameterValue("TenderingNumParam", "ندارد");
}
report.SetParameterValue("TenderTitleParam", CurrentTender.TenderingTitle);
report.SetParameterValue("OpenDateParam", DateConverter.ConvertDate((DateTime)(CurrentTender.SuggestionOpenDate).Value.Date).Substring(4));
report.SetParameterValue("EstimateParam", CurrentReq.Estimatation);
report.SetParameterValue("MeetId", CurrentMeet.MeetingId);
crystalReportsViewer1.ViewerCore.ReportSource = report;
}
private void crystalReportsViewer1_Loaded(object sender, RoutedEventArgs e)
{
var report = new RTM.Report.Report2.Report2_Main();
try
{
report.SetDatabaseLogon("ratec", "ratec");
report.SetParameterValue(0, Current.ContractorRequestId);
report.SetParameterValue(1, DateConverter.ConvertDate((DateTime)(((Current.RequestDate).Value).Date)).Substring(4));
if (Current.HasCEOAccepted == true)
{
report.SetParameterValue(2, "موافقت");
}
else
{
report.SetParameterValue(2, "مخالفت");
}
if (Current.CeoNote != null)
{
report.SetParameterValue("NoteParam", Current.CeoNote);
}
else
{
report.SetParameterValue("NoteParam", " ");
}
if (Current.Estimatation != null)
{
report.SetParameterValue("EstimateParam", Current.Estimatation);
}
else
{
report.SetParameterValue("EstimateParam", "0");
}
crystalReportsViewer1.ViewerCore.ReportSource = report;
}
catch
{
return;
}
}
private void crystalReportsViewer1_Loaded(object sender, RoutedEventArgs e)
{
var report = new RTM.Report.GenralRep.WebDocRecieve();
//report.SetDatabaseLogon("ratec", "ratec");
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);
}
foreach (TenderingFileDownload t in MyList)
{
t.PersianDate = DateConverter.ConvertDate(t.date);
}
report.SetDataSource(MyList);
crystalReportsViewer1.ViewerCore.ReportSource = report;
}
private void crystalReportsViewer1_Loaded(object sender, RoutedEventArgs e)
{
var report = new RTM.Report.Report1.Report1_Main();
try
{
report.SetDatabaseLogon("ratec", "ratec");
report.SetParameterValue("MeetingDateParam", DateConverter.ConvertDate((DateTime)(CurrentTender.TenderingRecordDate).Value.Date).ToString().Substring(4));
report.SetParameterValue("ReqNumParam", CurrentReq.RequestNumber.ToString());
report.SetParameterValue("ReqDateParam", DateConverter.ConvertDate((DateTime)(CurrentReq.RequestDate).Value.Date).ToString().Substring(4));
report.SetParameterValue("TitleParam", CurrentReq.ProjectTitle);
report.SetParameterValue("LocParam", CurrentReq.Location);
report.SetParameterValue("EstimateParam", CurrentReq.Estimatation);
if (CurrentReq.IsPriceList == true)
{
report.SetParameterValue("PriceListParam", CurrentReq.Year);
}
else
{
report.SetParameterValue("PriceListParam", "ندارد");
}
report.SetParameterValue("FieldParam", CurrentReq.RequiredField);
report.SetParameterValue("MinRankParam", CurrentReq.RequiredMinRank);
report.SetParameterValue("TenderTypeParam", CurrentReq.TenderingType);
if (CurrentTender.AdvertisingAlternationCount == null || CurrentTender.AdvertisingAlternationCount == 0)
{
report.SetParameterValue("AdParam", "ندارد");
}
else
{
report.SetParameterValue("AdParam", CurrentTender.AdvertisingAlternationCount.ToString());
}
string GarantyType;
if (CurrentTender.StockWarranty == true)
{
GarantyType = "اوراق مشارکت";
}
else if (CurrentTender.LcWarranty == true)
{
GarantyType = "ضمانتنامه بانکی";
}
else if (CurrentTender.DraftWarranty == true)
{
GarantyType = "فیش واریزی";
}
else
{
GarantyType = "";
}
report.SetParameterValue("GarantyTypeParam", GarantyType);
report.SetParameterValue("GarantyPriceParam", CurrentTender.GuarantyPrice);
report.SetParameterValue("RecParam", DateConverter.ConvertDate((DateTime)(CurrentTender.RecievingDocumentsDate).Value.Date).ToString().Substring(4));
report.SetParameterValue("RecEndParam", DateConverter.ConvertDate((DateTime)(CurrentTender.RecievingDocumentDeadline).Value.Date).ToString().Substring(4));
report.SetParameterValue("OfferParam", DateConverter.ConvertDate((DateTime)(CurrentTender.SuggestionRecieveDate).Value.Date).ToString().Substring(4));
report.SetParameterValue("OfferEndParam", DateConverter.ConvertDate((DateTime)(CurrentTender.SuggestionOpenDate).Value.Date).ToString().Substring(4));
if (CurrentTender.IsDocForSale == true && CurrentTender.DocumentSalePrice != null)
{
report.SetParameterValue("SalePriceParam", CurrentTender.DocumentSalePrice);
}
else
{
report.SetParameterValue("SalePriceParam", "0");
}
if (CurrentTender.HasQualityEvaluation == true)
{
report.SetParameterValue("QualityParam", "دارد");
}
else
{
report.SetParameterValue("QualityParam", "ندارد");
}
if (CurrentTender.HasBriefingSession == true)
{
report.SetParameterValue("JustiParam", "دارد");
report.SetParameterValue("JustiDateParam", DateConverter.ConvertDate((DateTime)(CurrentTender.BriefingSessionDate).Value.Date).ToString().Substring(4));
}
else
{
report.SetParameterValue("JustiParam", "ندارد");
report.SetParameterValue("JustiDateParam", "-");
}
if (CurrentTender.Description == null || CurrentTender.Description.Trim() == "")
{
report.SetParameterValue("NoteParam", "");
}
else
{
report.SetParameterValue("NoteParam", CurrentTender.Description);
}
report.SetParameterValue("TenderId", CurrentTender.TenderingId);
crystalReportsViewer1.ViewerCore.ReportSource = report;
}
catch
{
return;
}
}
private void crystalReportsViewer1_Loaded(object sender, RoutedEventArgs e)
{
if (CurrentTender.StageId < (int)Stages.TenderingMeeting)
{
ErrorHandler.NotifyUser("ایجاد صورتجلسه توجیهی تا قبل از تایید نهایی درخواست مناقصه امکان پذیر نیست");
return;
}
var report = new RTM.Report.Report4.Report4_Main();
report.SetDatabaseLogon("ratec", "ratec");
report.SetParameterValue("MeetNumParam", CurrentMeet.MeetingId);
report.SetParameterValue("MeetingDateParam", DateConverter.ConvertDate((DateTime)(CurrentMeet.MeetingDate).Value.Date).ToString().Substring(4));
report.SetParameterValue("RecParam", DateConverter.ConvertDate((DateTime)(CurrentTender.RecievingDocumentsDate).Value.Date).ToString().Substring(4));
report.SetParameterValue("RecEndParam", DateConverter.ConvertDate((DateTime)(CurrentTender.RecievingDocumentDeadline).Value.Date).ToString().Substring(4));
report.SetParameterValue("OfferParam", DateConverter.ConvertDate((DateTime)(CurrentTender.SuggestionRecieveDate).Value.Date).ToString().Substring(4));
report.SetParameterValue("OfferEndParam", DateConverter.ConvertDate((DateTime)(CurrentTender.SuggestionOpenDate).Value.Date).ToString().Substring(4));
string GarantyType;
if (CurrentTender.StockWarranty == true)
{
GarantyType = "اوراق مشارکت";
}
else if (CurrentTender.LcWarranty == true)
{
GarantyType = "ضمانتنامه بانکی";
}
else if (CurrentTender.DraftWarranty == true)
{
GarantyType = "فیش واریزی";
}
else
{
GarantyType = "";
}
report.SetParameterValue("GarantyTypeParam", GarantyType);
report.SetParameterValue("LocParam", CurrentTender.Location);
report.SetParameterValue("PriceParam", CurrentTender.GuarantyPrice.ToString().Split('.')[0]);
if (CurrentTender.TenderingNumber != null)
{
report.SetParameterValue("TenderNumParam", CurrentTender.TenderingNumber);
}
else
{
report.SetParameterValue("TenderNumParam", "ندارد");
}
if (CurrentMeet.MeetingDescription.Trim() == "" || CurrentMeet.MeetingDescription == null)
{
report.SetParameterValue("NoteParam", "");
}
else
{
report.SetParameterValue("NoteParam", CurrentMeet.MeetingDescription);
}
string RefrenceType;
if (CurrentMeet.ExtendByApplicant == true)
{
RefrenceType = "درخواست واحد متقاضی";
}
else if (CurrentMeet.ExtendByCommittee == true)
{
RefrenceType = "نظر کمیسیون";
}
else
{
RefrenceType = "";
}
report.SetParameterValue("RefrenceParam", RefrenceType);
report.SetParameterValue("ExtendDateParam", DateConverter.ConvertDate((DateTime)(CurrentMeet.ExtendedRecieveDate).Value.Date).ToString().Substring(4));
report.SetParameterValue("TenderId", CurrentTender.TenderingId);
report.SetParameterValue("MeetId", CurrentMeet.MeetingId);
string SessionType;
if (CurrentMeet.MeetingType == (int)MeetingTypes.DocExtendingMeeting)
{
SessionType = "ارائه اسناد";
}
else if (CurrentMeet.MeetingType == (int)MeetingTypes.PacketExtendingMeeting)
{
SessionType = "تسلیم پاکات";
}
else
{
SessionType = "";
}
report.SetParameterValue("MeetTypeParam", SessionType);
crystalReportsViewer1.ViewerCore.ReportSource = report;
}
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 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;
}
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);
}
}
