public DataSet GetTextModuleAreas() { DataSet dsTextModuleAreas = new DataSet(); try { using (SqlCommand cmd = new SqlCommand()) { cmd.Connection = SQLCon.Sqlconn(); cmd.CommandType = CommandType.StoredProcedure; cmd.CommandText = "[P_Get_TextModuleAreas]"; using (SqlDataAdapter da = new SqlDataAdapter(cmd)) { da.Fill(dsTextModuleAreas); } } } catch (Exception ex) { if (System.Threading.Thread.CurrentThread.CurrentCulture.Name.ToString() == "de-DE") { // throw new Exception("Fehler beim Laden des Kunden"); } else { throw new Exception("Error Occured While Retreiving the data"); } } finally { SQLCon.Sqlconn().Close(); } return(dsTextModuleAreas); }
public DataSet GetCategories(int _textID) { DataSet dsCategory = new DataSet(); try { using (SqlCommand cmd = new SqlCommand()) { cmd.Connection = SQLCon.Sqlconn(); cmd.CommandType = CommandType.StoredProcedure; cmd.CommandText = "[P_Get_Category]"; cmd.Parameters.AddWithValue("@TextareaID", _textID); using (SqlDataAdapter da = new SqlDataAdapter(cmd)) { da.Fill(dsCategory); } } } catch (Exception ex) { if (System.Threading.Thread.CurrentThread.CurrentCulture.Name.ToString() == "de-DE") { // throw new Exception("Fehler beim Laden des Kunden"); } else { throw new Exception("Error Occured While Retreiving the data"); } } finally { SQLCon.Sqlconn().Close(); } return(dsCategory); }
public DataSet GetOTTODetails() { DataSet dsOTTO = new DataSet(); try { using (SqlCommand cmd = new SqlCommand()) { cmd.Connection = SQLCon.Sqlconn(); cmd.CommandType = CommandType.StoredProcedure; cmd.CommandText = "[P_Get_OTTODetails]"; using (SqlDataAdapter da = new SqlDataAdapter(cmd)) { da.Fill(dsOTTO); } } } catch (Exception ex) { if (System.Threading.Thread.CurrentThread.CurrentCulture.Name.ToString() == "de-DE") { throw new Exception("Fehler beim Laden der Daten zu OTTO"); } else { throw new Exception("Error Occured While Retreiving OTTO details"); } } finally { SQLCon.Sqlconn().Close(); } return(dsOTTO); }
public int SaveCategory(XmlDocument XmlDoc) { int CategoryID = -1; try { string innerxml = XmlDoc.InnerXml.Replace(',', '.'); using (SqlCommand cmd = new SqlCommand()) { cmd.Connection = SQLCon.Sqlconn(); cmd.CommandType = CommandType.StoredProcedure; cmd.CommandText = "[P_Ins_Category]"; SqlParameter param = new SqlParameter("@XMLCategory", SqlDbType.Xml); param.Value = innerxml; cmd.Parameters.Add(param); object returnObj = cmd.ExecuteScalar(); if (returnObj != null) { if (!int.TryParse(returnObj.ToString(), out CategoryID)) { throw new Exception(returnObj.ToString()); } } } } catch (Exception ex) { throw; } finally { SQLCon.Sqlconn().Close(); } return(CategoryID); }