public void AddProductHierarchys(XElement XMLProHei) { if (conn.State == System.Data.ConnectionState.Closed) { try { conn.Open(); } catch (Exception ex) { log.Error("Cannot open the Database due to: ", ex); return; } } try { IEnumerable <XElement> Prohei = from phs in XMLProHei.Elements("Statement").Elements("PRODHIERTABLE").Elements("access") select phs; foreach (XElement ph in Prohei) { ProHierarchy Pro = new ProHierarchy(); Pro.BrandCode = ph.Element("BrandCode").Value; Pro.BrandName = ph.Element("BrandName").Value; Pro.SubBrandCode = ph.Element("SubBrandCode").Value; Pro.SubbrandName = ph.Element("SubbrandName").Value; Pro.ProductID = ph.Element("ProductID").Value; Pro.CompanyID = ph.Element("CompanyID").Value; Pro.Status = ph.Element("Status").Value; int result = Pro.Inert_ProHei(Pro, conn); if (result == 1) { log.Info("Insert to PRODHIERTABLE successfull: " + Pro.BrandCode); } else { log.Info("Insert to PRODHIERTABLE failed: " + Pro.BrandCode); } } conn.Close(); } catch (Exception ex) { log.Error("Insert into CUSTMSTTABLE failed due to: " + ex); return; } }
public int Inert_ProHei(ProHierarchy ProH, SqlConnection conn) { using (SqlCommand cmd = new SqlCommand("spr_INSERT_PRODHIERTABLE", conn)) { cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.Add("@BrandCode", SqlDbType.VarChar).Value = ProH.BrandCode; cmd.Parameters.Add("@BrandName", SqlDbType.VarChar).Value = ProH.BrandName; cmd.Parameters.Add("@SubBrandCode", SqlDbType.VarChar).Value = ProH.SubBrandCode; cmd.Parameters.Add("@SubbrandName", SqlDbType.VarChar).Value = ProH.SubbrandName; cmd.Parameters.Add("@ProductID", SqlDbType.VarChar).Value = ProH.ProductID; cmd.Parameters.Add("@CompanyID", SqlDbType.VarChar).Value = ProH.CompanyID; cmd.Parameters.Add("@Status", SqlDbType.Decimal).Value = ProH.Status; int result = cmd.ExecuteNonQuery(); return result; } }
public void AddProductHierarchy(ProHierarchy ProHei) { if (conn.State == System.Data.ConnectionState.Closed) { try { conn.Open(); } catch (Exception ex) { log.Error("Cannot open the Database due to: ", ex); return; } } try { using (SqlCommand cmd = new SqlCommand("spr_INSERT_PRODHIERTABLE", conn)) { cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.Add("@BrandCode", SqlDbType.VarChar).Value = ProHei.BrandCode; cmd.Parameters.Add("@BrandName", SqlDbType.VarChar).Value = ProHei.BrandName; cmd.Parameters.Add("@SubBrandCode", SqlDbType.VarChar).Value = ProHei.SubBrandCode; cmd.Parameters.Add("@SubbrandName", SqlDbType.VarChar).Value = ProHei.SubbrandName; cmd.Parameters.Add("@ProductID", SqlDbType.VarChar).Value = ProHei.ProductID; cmd.Parameters.Add("@CompanyID", SqlDbType.VarChar).Value = ProHei.CompanyID; cmd.Parameters.Add("@Status", SqlDbType.Decimal).Value = ProHei.Status; int result = cmd.ExecuteNonQuery(); conn.Close(); if (result == 1) { log.Info(ProHei.BrandCode.ToString() + " - Insert to PRODHIERTABLE successfull"); return; } else { log.Error(ProHei.BrandCode.ToString() + " - Insert to PRODHIERTABLE failed"); return; } } } catch (Exception ex) { //throw ex; log.Error(ProHei.BrandCode.ToString() + " - Failed to insert: ", ex); return; } }