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);
}
void CompanySelectionDo()
{
string ldbname = string.Empty;
string lcompid = string.Empty;
if (gridCompany.SelectedRowsCount == 0 && gridCompany.FocusedRowHandle < 0)
{
return;
}
if (gridCompany.SelectedRowsCount == 0)
{
gridCompany.FocusedRowHandle = 0;
lcompid = gridCompany.GetFocusedRowCellValue("compid").ToString();
}
else if (gridCompany.FocusedRowHandle < 0)
{
gridCompany.FocusedRowHandle = 0;
lcompid = gridCompany.GetFocusedRowCellValue("compid").ToString();
}
else
{
lcompid = gridCompany.GetFocusedRowCellValue("compid").ToString();
}
if (lcompid.Length > 0)
{
DataTable ltb = (DataTable)xGridCompany.DataSource;
foreach (DataRow dr in ltb.Select(" compid = '" + lcompid + "'"))
{
AppInit.CompanyInfo.CompanyName = dr["compname"].ToString();
AppInit.CompanyInfo.DbName = dr["dbname"].ToString();
}
this.DialogResult = DialogResult.OK;
this.Close();
}
else
{
this.DialogResult = DialogResult.Cancel;
AppInit.CompanyInfo.DbName = "";
}
if (AppInit.CompanyInfo.DbName.Length != 0)
{
//var config = new ConfigurationSettings.ap
AppFun.SetAppConnection(AppInit.CompanyInfo.DbName);
}
}
private void btnSave_Click(object sender, EventArgs e)
{
if (txtTaxName.Text.Length == 0)
{
MessageBox.Show("Kindly enter tax name.");
txtTaxName.Focus();
return;
}
if (mPkValue == 0)
{
TaxMst objtxm = new TaxMst();
objtxm.TaxName = txtTaxName.Text;
//objtxm.IGST = Convert.ToDecimal(Convert.ToDouble(txtIGST.Text));
//objtxm.CGST = Convert.ToDecimal(Convert.ToDouble(txtCGST.Text));
//objtxm.SGST = Convert.ToDecimal(Convert.ToDouble(txtSGST.Text));
objtxm.IGST = AppFun.ToDecimal(txtIGST.Text);
objtxm.CGST = AppFun.ToDecimal(txtCGST.Text);
objtxm.SGST = AppFun.ToDecimal(txtSGST.Text);
dbx.TaxMsts.Add(objtxm);
dbx.SaveChanges();
MessageBox.Show("Tax detail saved..");
}
else
{
var objtxm = dbx.TaxMsts.Where(u => u.TaxId == mPkValue).First();
if (objtxm != null)
{
objtxm.TaxName = txtTaxName.Text;
objtxm.IGST = AppFun.ToDecimal(txtIGST.Text);
objtxm.CGST = AppFun.ToDecimal(txtCGST.Text);
objtxm.SGST = AppFun.ToDecimal(txtSGST.Text);
dbx.SaveChanges();
MessageBox.Show("Item detail updated..");
}
}
ClearControls();
}
private void btnSave_Click(object sender, EventArgs e)
{
if (txtItemName.Text.Length == 0)
{
MessageBox.Show("Kindly enter item name.");
txtItemName.Focus();
return;
}
if (cmbTax.Text.Length == 0)
{
MessageBox.Show("Kindly select tax.");
cmbTax.Focus();
return;
}
cmbTax.Tag = dbx.TaxMsts.Where(u => u.TaxName == cmbTax.Text.Trim()).Select(s => s.TaxId).FirstOrDefault();
if (mPkValue == 0)
{
ItemMst objitm = new ItemMst();
objitm.ItemName = txtItemName.Text;
objitm.ItemCode = txtItemCode.Text;
objitm.Unit = cmbUnit.Text;
objitm.ItemDesc = txtItemDesc.Text;
objitm.TaxId = Convert.ToInt32(cmbTax.Tag);
objitm.IGSTPer = AppFun.ToDecimal(txtIGST.Text);
objitm.CGSTPer = AppFun.ToDecimal(txtCGST.Text);
objitm.SGSTPer = AppFun.ToDecimal(txtSGST.Text);
objitm.PurchasePrice = AppFun.ToDecimal(txtPurchasePrice.Text);
objitm.SalePrice = AppFun.ToDecimal(txtSalePrice.Text);
objitm.HSNCode = txtHSNCode.Text;
dbx.ItemMsts.Add(objitm);
dbx.SaveChanges();
MessageBox.Show("Item detail saved..");
}
else
{
var objitm = dbx.ItemMsts.Where(u => u.ItemId == mPkValue).First();
if (objitm != null)
{
objitm.ItemName = txtItemName.Text;
objitm.ItemCode = txtItemCode.Text;
objitm.Unit = cmbUnit.Text;
objitm.ItemDesc = txtItemDesc.Text;
objitm.TaxId = Convert.ToInt32(cmbTax.Tag);
objitm.IGSTPer = Convert.ToDecimal(txtIGST.Text);
objitm.CGSTPer = Convert.ToDecimal(txtCGST.Text);
objitm.SGSTPer = Convert.ToDecimal(txtSGST.Text);
objitm.PurchasePrice = Convert.ToDecimal(txtPurchasePrice.Text);
objitm.SalePrice = Convert.ToDecimal(txtSalePrice.Text);
objitm.HSNCode = txtHSNCode.Text;
dbx.SaveChanges();
MessageBox.Show("Item detail updated..");
}
}
var lqryu = dbx.UnitMsts.Where(u => u.UnitName == cmbUnit.Text.Trim());
if (lqryu.Count() == 0)
{
UnitMst objumt = new UnitMst();
objumt.UnitName = cmbUnit.Text;
dbx.UnitMsts.Add(objumt);
dbx.SaveChanges();
HelperClass.bCombBox_Unit(cmbUnit);
}
ClearControls();
}
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);
}
}
