public void FetchCompany()
{
CompanyDAL CompDAL = new CompanyDAL {
ConnectionString = ConfigurationManager.ConnectionStrings["MySQLTest"].ToString()
};
GVCompany.DataSource = CompDAL.GetCompany(null);
GVCompany.DataBind();
}
public IActionResult Review()
{
var aesUserData = User.FindFirst(ClaimTypes.UserData).Value;
var UserData = JsonConvert.DeserializeObject <B2dAccount>(AesCryptHelper.aesDecryptBase64(aesUserData, Website.Instance.AesCryptKey));
var xid = UserData.COMPANY_XID;
B2dCompany model = CompanyDAL.GetCompany(xid);
return(View(model));
}
public B2dCompany GetCompany(Int64 xid)
{
var comp = CompanyDAL.GetCompany(xid);
//狀態語系文字對應
comp.STATUS_DESC = GetFieldStatus(comp.STATUS);
return(comp);
}
private void FillCompany(String Name)
{
CompanyDAL Compdal = new CompanyDAL();
Compdal.ConnectionString = ConfigurationManager.ConnectionStrings["MySQLConn"].ToString();
List <Company> CompanyList = Compdal.GetCompany(Name);
gvCompany.DataSource = CompanyList;
gvCompany.DataBind();
}
private void SetAdditionalData()
{
if (CompanyID != 0)
{
CompanyDAL comp = new CompanyDAL();
_CompanyInfo = comp.GetCompany(CompanyID);
PropertyDAL prop = new PropertyDAL();
_PropertyInfo = prop.GetProperties(CompanyID);
}
}
protected void BtnExport_Click(object sender, EventArgs e)
{
CompanyDAL Compdal = new CompanyDAL();
Compdal.ConnectionString = ConfigurationManager.ConnectionStrings["MySQLConn"].ToString();
List <Company> CompanyList = Compdal.GetCompany(null);
var mem = new MemoryStream();
var writer = new StreamWriter(mem, Encoding.UTF8, 1024, true);
var csvWriter = new CsvWriter(writer);
csvWriter.Configuration.Delimiter = ",";
csvWriter.WriteField("Name");
csvWriter.WriteField("Country");
csvWriter.WriteField("NameAr");
csvWriter.WriteField("Site");
csvWriter.NextRecord();
int lenght = CompanyList.Count - 1;
for (int i = 0; i <= lenght; i++)
{
csvWriter.WriteField(CompanyList[i].Name);
csvWriter.WriteField(CompanyList[i].Country);
csvWriter.WriteField(CompanyList[i].NameAr);
csvWriter.WriteField(CompanyList[i].Site);
csvWriter.NextRecord();
}
writer.Flush();
var data = Encoding.UTF8.GetString(mem.ToArray());
Response.Clear();
Response.AddHeader("content-disposition", "attachment; filename=Company.csv");
Response.Charset = "";
Response.ContentType = "text/csv";
Response.Write(data.ToString());
Response.End();
}
protected void FetchCompaniesList()
{
//MySqlConnection connection = new MySqlConnection
//{
//ConnectionString = ConfigurationManager.ConnectionStrings["MySQLTest"].ToString()
//};
//MySqlCommand command = new MySqlCommand("SELECT Name FROM `shobingg_P2M_Operations`.`Clients Invoices` group by Company", connection)
//{
//CommandType = System.Data.CommandType.Text
//};
//MySqlDataAdapter dataAdapter = new MySqlDataAdapter("SELECT ID,Name FROM `shobingg_P2M_Operations`.`Company` ", connection);
//DataTable dataTable = new DataTable();
//dataAdapter.Fill(dataTable);
//connection.Open();
//CompaniesList.DataSource = dataTable;
//CompaniesList.DataTextField = "Name";
//CompaniesList.DataValueField = "ID";
//CompaniesList.DataBind();
//connection.Close();
CompanyDAL companies = new CompanyDAL
{
ConnectionString = ConfigurationManager.ConnectionStrings["MySQLTest"].ToString()
};
CompaniesList.DataSource = companies.GetCompany(null);
CompaniesList.DataTextField = "Name";
CompaniesList.DataValueField = "ID";
CompaniesList.DataBind();
CompaniesList.Items.Insert(0, new ListItem("--Select Company--", "0"));
}