public int UpdateAttributeByC3andAID(CategoryAttributeInfo oParam)
{
string sql = @"UPDATE Category_Attribute SET
AttributeName=@AttributeName,
OrderNum=@OrderNum, Status=@Status
WHERE C3SysNo=@C3SysNo and AttributeID=@AttributeID ";
SqlCommand cmd = new SqlCommand(sql);
SqlParameter paramC3SysNo = new SqlParameter("@C3SysNo", SqlDbType.Int, 4);
SqlParameter paramAttributeID = new SqlParameter("@AttributeID", SqlDbType.NVarChar, 20);
SqlParameter paramAttributeName = new SqlParameter("@AttributeName", SqlDbType.NVarChar, 50);
SqlParameter paramOrderNum = new SqlParameter("@OrderNum", SqlDbType.Int, 4);
SqlParameter paramStatus = new SqlParameter("@Status", SqlDbType.Int, 4);
SqlParameter paramAttributeType = new SqlParameter("@AttributeType", SqlDbType.Int, 4);
paramC3SysNo.Value = oParam.C3SysNo;
paramAttributeID.Value = oParam.AttributeID;
paramAttributeName.Value = oParam.AttributeName;
paramOrderNum.Value = oParam.OrderNum;
paramStatus.Value = oParam.Status;
paramAttributeType.Value = oParam.AttributeType;
cmd.Parameters.Add(paramC3SysNo);
cmd.Parameters.Add(paramAttributeID);
cmd.Parameters.Add(paramAttributeName);
cmd.Parameters.Add(paramOrderNum);
cmd.Parameters.Add(paramStatus);
cmd.Parameters.Add(paramAttributeType);
return(SqlHelper.ExecuteNonQuery(cmd));
}
public int SetOrderNum(CategoryAttributeInfo oParam)
{
string sql = "update category_attribute set ordernum = " + oParam.OrderNum + " where sysno = " + oParam.SysNo;
SqlCommand cmd = new SqlCommand(sql);
return(SqlHelper.ExecuteNonQuery(cmd));
}
public int InsertAttribute(CategoryAttributeInfo oParam)
{
string sql = @"INSERT INTO Category_Attribute
(
C3SysNo, AttributeID, AttributeName,
OrderNum, Status, AttributeType
)
VALUES (
@C3SysNo, @AttributeID, @AttributeName,
@OrderNum, @Status, @AttributeType
)";
SqlCommand cmd = new SqlCommand(sql);
SqlParameter paramC3SysNo = new SqlParameter("@C3SysNo", SqlDbType.Int, 4);
SqlParameter paramAttributeID = new SqlParameter("@AttributeID", SqlDbType.NVarChar, 20);
SqlParameter paramAttributeName = new SqlParameter("@AttributeName", SqlDbType.NVarChar, 50);
SqlParameter paramOrderNum = new SqlParameter("@OrderNum", SqlDbType.Int, 4);
SqlParameter paramStatus = new SqlParameter("@Status", SqlDbType.Int, 4);
SqlParameter paramAttributeType = new SqlParameter("@AttributeType", SqlDbType.Int, 4);
paramC3SysNo.Value = oParam.C3SysNo;
paramAttributeID.Value = oParam.AttributeID;
paramAttributeName.Value = oParam.AttributeName;
paramOrderNum.Value = oParam.OrderNum;
paramStatus.Value = oParam.Status;
paramAttributeType.Value = oParam.AttributeType;
cmd.Parameters.Add(paramC3SysNo);
cmd.Parameters.Add(paramAttributeID);
cmd.Parameters.Add(paramAttributeName);
cmd.Parameters.Add(paramOrderNum);
cmd.Parameters.Add(paramStatus);
cmd.Parameters.Add(paramAttributeType);
return(SqlHelper.ExecuteNonQuery(cmd));
}
public CategoryInfo SaveCategory(Int32 storeID, Int32 portalID, Int32 categoryID, Int32 parentID, ASPXNameValue[] formVars, string selectedItems, string userName, string culture, int categoryLargeThumbImage, int categoryMediumThumbImage, int categorySmallThumbImage)
{
try
{
CategoryInfo categoryInfo = new CategoryInfo();
FormValidation formValidation = new FormValidation();
List<CategoryAttributeInfo> listCategoryAttributes = new List<CategoryAttributeInfo>();
categoryInfo.CategoryID = categoryID;
categoryInfo.ParentID = parentID;
categoryInfo.IsShowInCatalog = true;
categoryInfo.IsShowInMenu = true;
categoryInfo.IsShowInSearch = true;
categoryInfo.PortalID = portalID;
categoryInfo.StoreID = storeID;
categoryInfo.ActiveFrom = new DateTime(1970, 1, 1);
categoryInfo.ActiveTo = new DateTime(2999, 12, 30);
bool toInsertIntoDB = true;
bool isFormValid = true;
//int _imageCounter = 0;
string _imageVar = string.Empty;
int _imageCounterFirst = 0;
for (int i = 0; i < formVars.Length; i++)
{
int inputTypeID;
int validationTypeID;
string attribName = formVars[i].name;
string attribValue = formVars[i].value;
string jsonResult = formVars[i].name.Replace('-', ' ');
string[] jsonVar = jsonResult.Split('_');
CategoryAttributeInfo categoryAttribute = new CategoryAttributeInfo();
categoryAttribute.AttributeID = int.Parse(jsonVar[0]);
inputTypeID = int.Parse(jsonVar[1]);
validationTypeID = int.Parse(jsonVar[2]);
if (inputTypeID == 1)
{
if (validationTypeID == 3)
{
if (formValidation.ValidateValue(attribName, validationTypeID, attribValue))
{
categoryAttribute.InputTypeID = inputTypeID;
categoryAttribute.ValidationTypeID = validationTypeID;
categoryAttribute.DECIMALValue = decimal.Parse(attribValue);
}
else
{
isFormValid = false;
break;
}
}
else if (validationTypeID == 5)
{
if (formValidation.ValidateValue(attribName, validationTypeID, attribValue))
{
categoryAttribute.InputTypeID = inputTypeID;
categoryAttribute.ValidationTypeID = validationTypeID;
categoryAttribute.INTValue = Int32.Parse(attribValue);
}
else
{
isFormValid = false;
break;
}
}
else
{
if (formValidation.ValidateValue(attribName, validationTypeID, attribValue))
{
categoryAttribute.InputTypeID = inputTypeID;
categoryAttribute.ValidationTypeID = validationTypeID;
categoryAttribute.NVARCHARValue = attribValue;
}
else
{
isFormValid = false;
break;
}
}
}
else if (inputTypeID == 2)
{
if (formValidation.ValidateValue(attribName, validationTypeID, attribValue))
{
categoryAttribute.InputTypeID = inputTypeID;
categoryAttribute.ValidationTypeID = validationTypeID;
categoryAttribute.TEXTValue = attribValue;
}
else
{
isFormValid = false;
break;
}
}
else if (inputTypeID == 3)
{
if (formValidation.ValidateValue(attribName, validationTypeID, attribValue))
{
categoryAttribute.InputTypeID = inputTypeID;
categoryAttribute.ValidationTypeID = validationTypeID;
if (!string.IsNullOrEmpty(attribValue))
{
categoryAttribute.DATEValue = DateTime.Parse(attribValue);
}
}
else
{
isFormValid = false;
break;
}
}
else if (inputTypeID == 4)
{
if (formValidation.ValidateValue(attribName, validationTypeID, attribValue))
{
categoryAttribute.InputTypeID = inputTypeID;
categoryAttribute.ValidationTypeID = validationTypeID;
if (!string.IsNullOrEmpty(attribValue))
{
categoryAttribute.BooleanValue = (attribValue == "1" ||
attribValue.ToLower() == "true")
? true
: false;
}
else
{
categoryAttribute.BooleanValue = false;
}
}
else
{
isFormValid = false;
break;
}
}
else if (inputTypeID == 5 || inputTypeID == 6 || inputTypeID == 9 || inputTypeID == 10 ||
inputTypeID == 11 || inputTypeID == 12)
{
if (formValidation.ValidateValue(attribName, validationTypeID, attribValue))
{
categoryAttribute.InputTypeID = inputTypeID;
categoryAttribute.ValidationTypeID = validationTypeID;
categoryAttribute.OPTIONValues = attribValue;
}
else
{
isFormValid = false;
break;
}
}
else if (inputTypeID == 7)
{
if (formValidation.ValidateValue(attribName, validationTypeID, attribValue))
{
categoryAttribute.InputTypeID = inputTypeID;
categoryAttribute.ValidationTypeID = validationTypeID;
categoryAttribute.DECIMALValue = decimal.Parse(attribValue);
}
else
{
isFormValid = false;
break;
}
}
else if (inputTypeID == 8)
{
if (_imageCounterFirst % 2 == 0)
{
toInsertIntoDB = false;
if (!string.IsNullOrEmpty(attribValue) && attribValue.ToLower() != "undefined")
{
if (formValidation.ValidateValue(attribName, validationTypeID, attribValue))
{
_imageVar = attribValue;
}
else
{
isFormValid = false;
break;
}
}
else
{
_imageVar = "";
}
}
else
{
toInsertIntoDB = true;
categoryAttribute.InputTypeID = inputTypeID;
categoryAttribute.ValidationTypeID = validationTypeID;
//_imageVar = _imageVar.Replace("../", "");
if (attribValue != _imageVar)
{
_imageVar = _imageVar.Replace("/", "\\");
//attribValue = attribValue.Replace("../", "");
attribValue = attribValue.Replace("/", "\\");
string tempFolder = @"Upload\temp";
FileHelperController fileObj = new FileHelperController();
attribValue = fileObj.MoveFileToModuleFolder(tempFolder, attribValue, _imageVar,categoryLargeThumbImage,categoryMediumThumbImage,categorySmallThumbImage,
@"Modules\ASPXCommerce\ASPXCategoryManagement\uploads\",
categoryID, "cat_");
categoryAttribute.FILEValue = attribValue;
}
//else if (_imageVar == "")
//{
// categoryAttribute.FILEValue = _imageVar;
//}
else
{
categoryAttribute.FILEValue = attribValue;
}
}
_imageCounterFirst++;
}
if (toInsertIntoDB)
{
listCategoryAttributes.Add(categoryAttribute);
}
}
if (isFormValid)
{
CategorySqlProvider categorySqlProvider = new CategorySqlProvider();
categoryInfo = categorySqlProvider.CategoryAddUpdate(categoryInfo, selectedItems, listCategoryAttributes, userName, culture);
}
else
{
throw new Exception("Form is not valid one");
}
return categoryInfo;
}
catch (Exception ex)
{
throw ex;
}
}
