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