private string randomString() { SqlConnection con1 = new SqlConnection(PublicVar.ConnectionString); DataTable dt = new DataTable(); con1.Open(); SqlCommand MainDaramadCMD = new SqlCommand("Select Sum(MemberCharge) from Members where MemberStartDate = '" + String.Format("{0:yyyy/MM/dd}", Convert.ToDateTime(NowTime.Text)) + "'", con1); object resultsstt = MainDaramadCMD.ExecuteScalar(); MainDaramad = Convert.ToString(resultsstt) + " : درامد امروز شما"; SqlCommand LastSubmiter = new SqlCommand("Select (UserName + ' ' + UserFamily) from Users where UserID = (SELECT MAX(UserID) FROM Users)", con1); object LastSubmiterObj = LastSubmiter.ExecuteScalar(); LastSubmiterString = "آخرین نفر ثبت نام کننده : " + Convert.ToString(LastSubmiterObj); Cal_Mount.SelectedDate = PersianDate.Today.AddDays(-30); SqlCommand FactorCode = new SqlCommand("Select Count(MemberFactorCode) from Members where MemberStartDate = '" + String.Format("{0:yyyy/MM/dd}", Convert.ToDateTime(NowTime.Text)) + "'", con1); object FactorCodeObj = FactorCode.ExecuteScalar(); FactorCodeString = Convert.ToString(FactorCodeObj) + " : تعداد فاکتور های ثبت شده ی امروز "; SqlCommand Submiters = new SqlCommand("Select count(UserID) from Users where UserRegDate between '" + String.Format("{0:yyyy/MM/dd}", Convert.ToDateTime(Cal_Mount.Text)) + "' And '" + String.Format("{0:yyyy/MM/dd}", Convert.ToDateTime(NowTime.Text)) + "'", con1); object SubmitersObj = Submiters.ExecuteScalar(); SubmitersString = Convert.ToString(SubmitersObj) + " : تعداد افرادی که این ماه ثبت نام کرده اند"; SqlCommand DeActives = new SqlCommand("Select count(UserID) from Users where UserActive = 2", con1); object DeActivesObj = DeActives.ExecuteScalar(); DeActivesString = Convert.ToString(DeActivesObj) + " : افراد غیر فعال "; SqlCommand PriceFinder = new SqlCommand("Select Sum(MemberCharge) from Members", con1); object PriceFinderObj = PriceFinder.ExecuteScalar(); string PriceFinderString = Convert.ToString(PriceFinderObj) + " : کل درامد شما "; Module.PNumberTString farsi = new PNumberTString(); SqlCommand PriceFinders = new SqlCommand("Select Sum(MemberCharge) from Members where MemberStartDate = '" + String.Format("{0:yyyy/MM/dd}", Convert.ToDateTime(NowTime.Text)) + "'", con1); object PriceFinderObjs = PriceFinders.ExecuteScalar(); FarsiDaramad = "درامد امروز شما : " + farsi.num2str(PriceFinderObjs.ToString()) + " تومان "; var names = new List <string> { FarsiDaramad, MainDaramad, LastSubmiterString, FactorCodeString, SubmitersString, DeActivesString, PriceFinderString }; Random random = new Random(); int index = random.Next(names.Count); var name = names[index]; names.RemoveAt(index); return(name); }
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; }