bool CreateNewCompanyConfiguration()
{
if (mPkValue == 0)
{
DataSet ldtst = new DataSet(); int lnewcompid = 1;
ldtst.ReadXml(Application.StartupPath + @"\Conn.xml");
if (ldtst.Tables.Count > 0)
{
lnewcompid = Convert.ToInt32(ldtst.Tables[0].Compute("max([compid])", string.Empty)) + 1;
ldtst.Tables[0].Rows.Add(lnewcompid, txtComapanyName.Text, lnewcompid);
}
else
{
ldtst.Tables.Add("configruation");
ldtst.Tables[0].Columns.Add("compid", typeof(string));
ldtst.Tables[0].Columns.Add("compname", typeof(string));
ldtst.Tables[0].Columns.Add("dbname", typeof(string));
ldtst.Tables[0].Rows.Add(lnewcompid, txtComapanyName.Text, lnewcompid);
}
ldtst.WriteXml(Application.StartupPath + @"\Conn.xml");
System.IO.File.Copy(Application.StartupPath + @"\cab\dump.sdf", Application.StartupPath + @"\cab\" + lnewcompid + ".sdf");
AppFun.SetAppConnection(lnewcompid.ToString());
//var config = ConfigurationManager.OpenExeConfiguration(ConfigurationUserLevel.None);
//var connectionStringsSection = (ConnectionStringsSection)config.GetSection("connectionStrings");
//string _connString = connectionStringsSection.ConnectionStrings["Inv_DatabaseEntities"].ConnectionString;
//EntityConnectionStringBuilder ecsb = new EntityConnectionStringBuilder(_connString);
dbx = new Inv_DatabaseEntities(AppInit.AppInfo.EntityConnectionString);
return(true);
}
return(true);
}
public static void GetCompanyInfo()
{
Inv_DatabaseEntities dbx = new Inv_DatabaseEntities();
var lqry = dbx.CompanyMsts.FirstOrDefault();
if (lqry != null)
{
AppInit.CompanyInfo.CompanyName = lqry.CompanyName;
AppInit.CompanyInfo.CompanyStateCode = lqry.StateCode;
}
}
private void btnPrintChallan_Click(object sender, EventArgs e)
{
try
{
DataSet ldts = new DataSet();
Int32 lInvId = 0;
if (mInvId > 0)
{
lInvId = mInvId;
}
else
{
lInvId = Convert.ToInt16(xListDetail.GetRowCellValue(xListDetail.FocusedRowHandle, "InvId").ToString());
}
Inv_DatabaseEntities dbx = new Inv_DatabaseEntities();
var querymst = from c in dbx.InvoiceMsts where c.InvId == lInvId select c;
var querydet = from c in dbx.InvoiceDets where c.InvId == lInvId select c;
var querycustomer = from c in dbx.CustomerMsts where c.CustomerId == querymst.FirstOrDefault().CustomerId select c;
var querycompany = from c in dbx.CompanyMsts select c;
var queryitm = from c in dbx.ItemMsts select c;
ldts.Tables.Add(AppFun.EntityToDataTable(querycompany.ToList()));
ldts.Tables.Add(AppFun.EntityToDataTable(querycustomer.ToList()));
ldts.Tables.Add(AppFun.EntityToDataTable(querydet.ToList()));
ldts.Tables.Add(AppFun.EntityToDataTable(querymst.ToList()));
int netamt = Convert.ToInt32(querymst.FirstOrDefault().NetAmt);
string InrRup = AppFun.NumberToWords(netamt);
ldts.DataSetName = "Source1";
ldts.Tables[0].TableName = "CompanyMst";
ldts.Tables[1].TableName = "CustomerMst";
ldts.Tables[2].TableName = "InvoiceDet";
ldts.Tables[3].TableName = "InvoiceMst";
DevExpress.XtraReports.UI.XtraReport report = DevExpress.XtraReports.UI.XtraReport.FromFile(Environment.CurrentDirectory + @"\Reports\" + AppInit.SoftwareSettings.Inv_challanformatValue, true);
//DevExpress.XtraReports.UI.XtraReport report =new DevExpress.XtraReports.UI.XtraReport();
//report.LoadLayout(Environment.CurrentDirectory + @"\Reports\" + AppInit.SoftwareSettings.Inv_invoiceformateValue);
DevExpress.XtraReports.UI.ReportPrintTool tool = new DevExpress.XtraReports.UI.ReportPrintTool(report);
report.RequestParameters = false;
report.Parameters["Inr"].Value = InrRup;
report.Parameters["Inr"].Visible = false;
if (cmbCopy.Text.Length > 0)
{
report.Parameters["Copy"].Value = cmbCopy.Text;
report.Parameters["Copy"].Visible = false;
}
//report.Parameters.Add(new DevExpress.XtraReports.Parameters.Parameter() { Name = "Inr", Type = typeof(string), Value = InrRup, Description = "Inr" });
report.DataSource = ldts;
report.DataMember = ldts.Tables[2].TableName;
tool.ShowPreviewDialog();
}
catch (Exception ee)
{
MessageBox.Show(ee.Message);
}
}
