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);
}
