private List <SYS_COMPANY> MapSYS_COMPANY(DataTable dt)
{
List <SYS_COMPANY> rs = new List <SYS_COMPANY>();
for (int i = 0; i < dt.Rows.Count; i++)
{
SYS_COMPANY obj = new SYS_COMPANY();
if (dt.Columns.Contains("Company_Id"))
{
obj.Company_Id = dt.Rows[i]["Company_Id"].ToString();
}
if (dt.Columns.Contains("Company"))
{
obj.Company = dt.Rows[i]["Company"].ToString();
}
if (dt.Columns.Contains("Address"))
{
obj.Address = dt.Rows[i]["Address"].ToString();
}
if (dt.Columns.Contains("Tel"))
{
obj.Tel = dt.Rows[i]["Tel"].ToString();
}
if (dt.Columns.Contains("Fax"))
{
obj.Fax = dt.Rows[i]["Fax"].ToString();
}
if (dt.Columns.Contains("WebSite"))
{
obj.WebSite = dt.Rows[i]["WebSite"].ToString();
}
if (dt.Columns.Contains("Email"))
{
obj.Email = dt.Rows[i]["Email"].ToString();
}
if (dt.Columns.Contains("Tax"))
{
obj.Tax = dt.Rows[i]["Tax"].ToString();
}
if (dt.Columns.Contains("Licence"))
{
obj.Licence = dt.Rows[i]["Licence"].ToString();
}
if (dt.Columns.Contains("Photo"))
{
obj.Photo = (byte[])(dt.Rows[i]["Photo"]);
}
rs.Add(obj);
}
return(rs);
}
private void frmThongTin_Load(object sender, EventArgs e)
{
objsyscompany = new SYS_COMPANYController().SYS_COMPANY_Get("01");
if (objsyscompany.Company_Id == "01")
{
MemoryStream fs1 = new MemoryStream(objsyscompany.Photo, true);
pictureEdit1.Image = Image.FromStream(fs1);
pictureEdit1.Refresh();
txtTen.Text = objsyscompany.Company;
txtDiaChi.Text = objsyscompany.Address;
txtDienthoai.Text = objsyscompany.Tel;
txtEmail.Text = objsyscompany.Email;
txtFax.Text = objsyscompany.Fax;
txtMST.Text = objsyscompany.Tax;
txtWebsite.Text = objsyscompany.WebSite;
txtGP.Text = objsyscompany.Licence;
}
}
public int SYS_COMPANY_Insert(SYS_COMPANY obj)
{
try
{
return(DataProvider.ExecuteNonquery(DataProvider.ConnectionString, "SYS_COMPANY_Insert",
obj.Company_Id,
obj.Company,
obj.Address,
obj.Tel,
obj.Fax,
obj.WebSite,
obj.Email,
obj.Tax,
obj.Licence,
obj.Photo
));
}
catch
{
//throw ex;
return(-1);
}
}
private void simpleButton1_Click(object sender, EventArgs e)
{
objsyscompany = new SYS_COMPANYController().SYS_COMPANY_Get("01");
if (objsyscompany.Company_Id != "01")
{
int rs = -1;
FileStream frm;
frm = new FileStream(Pathname, FileMode.Open, FileAccess.Read);
byte[] picbyte = new byte[frm.Length];
frm.Read(picbyte, 0, System.Convert.ToInt32(frm.Length));
frm.Close();
objsyscompany.Company_Id = "01";
objsyscompany.Company = txtTen.Text;
objsyscompany.Address = txtDiaChi.Text;
objsyscompany.Fax = txtFax.Text;
objsyscompany.Email = txtEmail.Text;
objsyscompany.Tel = txtDienthoai.Text;
objsyscompany.Tax = txtMST.Text;
objsyscompany.WebSite = txtWebsite.Text;
objsyscompany.Licence = txtMST.Text;
objsyscompany.Photo = picbyte;
rs = new SYS_COMPANYController().SYS_COMPANY_Insert(objsyscompany);
if (rs < 1)
{
MessageBox.Show("Công ty đã tồn tại", "Thông báo");
}
else
{
MessageBox.Show("Công ty mới đã được lưu", "Thông báo");
}
}
else
{
int rs = -1;
if (Pathname != null)
{
FileStream frm;
frm = new FileStream(Pathname, FileMode.Open, FileAccess.Read);
byte[] picbyte = new byte[frm.Length];
frm.Read(picbyte, 0, System.Convert.ToInt32(frm.Length));
frm.Close();
objsyscompany.Photo = picbyte;
}
objsyscompany.Company_Id = "01";
objsyscompany.Company = txtTen.Text;
objsyscompany.Address = txtDiaChi.Text;
objsyscompany.Fax = txtFax.Text;
objsyscompany.Email = txtEmail.Text;
objsyscompany.Tel = txtDienthoai.Text;
objsyscompany.Tax = txtMST.Text;
objsyscompany.WebSite = txtWebsite.Text;
objsyscompany.Licence = txtMST.Text;
rs = new SYS_COMPANYController().SYS_COMPANY_Update(objsyscompany, objsyscompany.Company_Id);
if (rs < 1)
{
MessageBox.Show("Công ty đã tồn tại", "Thông báo");
}
else
{
MessageBox.Show("Công ty đã cập nhật", "Thông báo");
}
}
}
