public static List <DataObject.SysCompany> GetData(Int32 Id) { List <DataObject.SysCompany> lstSysCompany = new List <DataObject.SysCompany>(); String Select = ""; SqlCommand cmd = null; SqlConnection conn = Common.Connection.SqlConnect(); if (Id > 0) { Select = "Select * from SYS_COMPANY Where ID = @ID"; cmd = new SqlCommand(Select); cmd.CommandType = CommandType.Text; cmd.Connection = conn; cmd.Parameters.AddWithValue("@ID", Id); } else { Select = "Select * from SYS_COMPANY"; cmd = new SqlCommand(Select); cmd.CommandType = CommandType.Text; cmd.Connection = conn; } conn.Open(); using (SqlDataReader oReader = cmd.ExecuteReader()) { while (oReader.Read()) { DataObject.SysCompany obj = new DataObject.SysCompany(); obj.ID = Int32.Parse(oReader["ID"].ToString()); obj.Company_Name_EN = oReader["Company_Name_EN"].ToString(); obj.Company_Name_Short = oReader["Company_Name_Short"].ToString(); obj.Company_Name_Vi = oReader["Company_Name_Vi"].ToString(); obj.Tax_Code = oReader["Tax_Code"].ToString(); obj.Bank_Account = oReader["Bank_Account"].ToString(); obj.Amount_Freeship = float.Parse(oReader["Amount_Freeship"].ToString()); obj.Logo = oReader["Logo"].ToString(); obj.Email = oReader["Email"].ToString(); obj.Phone_Number = oReader["Phone_Number"].ToString(); lstSysCompany.Add(obj); } } conn.Close(); return(lstSysCompany); }
public static void InsertData(DataObject.SysCompany obj) { String Insert = "INSERT INTO SYS_COMPANY (Company_Name_EN,Company_Name_Short,Company_Name_Vi,Tax_Code,Bank_Account,Amount_Freeship,Logo,Email,Phone_Number) "; Insert += " VALUES (@Company_Name_EN,@Company_Name_Short,@Company_Name_Vi,@Tax_Code,@Bank_Account,@Amount_Freeship,@Logo,@Email,@Phone_Number)"; SqlConnection conn = Common.Connection.SqlConnect(); SqlCommand cmd = new SqlCommand(Insert); cmd.CommandType = CommandType.Text; cmd.Connection = conn; cmd.Parameters.AddWithValue("@Company_Name_EN", obj.Company_Name_EN); cmd.Parameters.AddWithValue("@Company_Name_Short", obj.Company_Name_Short); cmd.Parameters.AddWithValue("@Company_Name_Vi", obj.Company_Name_Vi); cmd.Parameters.AddWithValue("@Tax_Code", obj.Tax_Code); cmd.Parameters.AddWithValue("@Bank_Account", obj.Bank_Account); cmd.Parameters.AddWithValue("@Amount_Freeship", obj.Amount_Freeship); cmd.Parameters.AddWithValue("@Logo", obj.Logo); cmd.Parameters.AddWithValue("@Email", obj.Email); cmd.Parameters.AddWithValue("@Phone_Number", obj.Phone_Number); conn.Open(); cmd.ExecuteNonQuery(); conn.Close(); }
public static void UpdateData(DataObject.SysCompany obj) { SqlConnection conn = Common.Connection.SqlConnect(); String Update = "UPDATE SYS_COMPANY SET Company_Name_EN = @Company_Name_EN, Company_Name_Short = @Company_Name_Short, Company_Name_Vi =@Company_Name_Vi "; Update += "Tax_Code = @Tax_Code, Bank_Account = @Bank_Account ,Amount_Freeship = @Amount_Freeship,Logo = @Logo, Email =@Email, Phone_Number = @Phone_Number Where ID = @ID"; SqlCommand cmd = new SqlCommand(Update); cmd.CommandType = CommandType.Text; cmd.Connection = conn; cmd.Parameters.AddWithValue("@Company_Name_EN", obj.Company_Name_EN); cmd.Parameters.AddWithValue("@Company_Name_Short", obj.Company_Name_Short); cmd.Parameters.AddWithValue("@Company_Name_Vi", obj.Company_Name_Vi); cmd.Parameters.AddWithValue("@Tax_Code", obj.Tax_Code); cmd.Parameters.AddWithValue("@Bank_Account", obj.Bank_Account); cmd.Parameters.AddWithValue("@Amount_Freeship", obj.Amount_Freeship); cmd.Parameters.AddWithValue("@Logo", obj.Logo); cmd.Parameters.AddWithValue("@Email", obj.Email); cmd.Parameters.AddWithValue("@Phone_Number", obj.Phone_Number); cmd.Parameters.AddWithValue("@ID", obj.ID); conn.Open(); cmd.ExecuteNonQuery(); conn.Close(); }
public void Update(DataObject.SysCompany obj) { Servies.SysCompanyServices.InsertData(obj); }