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