public IActionResult Add(TechnologyEntity technology, string StatusRemarks, bool isSubcategoryInQuery)
{
int errorCode = 0;
string nextID = "";
try
{
nextID = SequenceHelper.GetNextSequence(Constants.ID, Constants.TABLE_TECHNOLOGY, Constants.PADDING_TECHNOLOGYID);
technology.RowKey = technology.RowKey + "_" + nextID;
technology.Description = technology.Description ?? "";
technology.Tag = InsertTag(technology.NewTag, technology.Tag);
DuplicateCheckEntity duplicateCheck = new DuplicateCheckEntity(technology.PartitionKey, technology.SubcategoryID + "_" + technology.NameHash);
TechnologyStatusEntity technologyStatus = GetTechnologyStatusEntity(technology.PartitionKey, nextID, technology.Status, StatusRemarks);
TableStorageHelper.InsertBatchAsync(Constants.TABLE_TECHNOLOGY, duplicateCheck, technology, technologyStatus).Wait();
}
catch (Exception ex)
{
nextID = "";
if (!TableStorageHelper.IsStorageException(ex, out errorCode))
{
errorCode = Constants.ERROR_CODE_COMMON;
}
}
return(RedirectToAction("Index", new { errorCode = errorCode, category = technology.PartitionKey, subcategory = ((isSubcategoryInQuery) ? technology.SubcategoryID : ""), technology = nextID }));
}
public IActionResult Edit(TechnologyEntity technology, string OriginalNameHash, bool isSubcategoryInQuery)
{
int errorCode = 0;
try
{
technology.Description = technology.Description ?? "";
technology.Tag = InsertTag(technology.NewTag, technology.Tag);
if (OriginalNameHash.Equals(technology.NameHash))
{
TableStorageHelper.MergeAsync(Constants.TABLE_TECHNOLOGY, technology).Wait();
}
else
{
DuplicateCheckEntity duplicateCheckOriginalDelete = new DuplicateCheckEntity(technology.PartitionKey, technology.SubcategoryID + "_" + OriginalNameHash);
duplicateCheckOriginalDelete.ETag = "*";
DuplicateCheckEntity duplicateCheckNewAdd = new DuplicateCheckEntity(technology.PartitionKey, technology.SubcategoryID + "_" + technology.NameHash);
TableStorageHelper.BatchAsync(Constants.TABLE_TECHNOLOGY, new DuplicateCheckEntity[] { duplicateCheckOriginalDelete }, new DuplicateCheckEntity[] { duplicateCheckNewAdd }, new TechnologyEntity[] { technology }).Wait();
}
}
catch (Exception ex)
{
if (!TableStorageHelper.IsStorageException(ex, out errorCode))
{
errorCode = Constants.ERROR_CODE_COMMON;
}
}
return(RedirectToAction("Index", new { errorCode = errorCode, category = technology.PartitionKey, subcategory = ((isSubcategoryInQuery) ? technology.SubcategoryID : ""), technology = technology.ID }));
}
public IActionResult Edit(UserEntity user)
{
int errorCode = 0;
try
{
if ((HttpContext?.User?.Identity?.Name ?? "").Trim().ToLower().Equals((user?.RowKey?.Trim()?.ToLower() ?? "Q!@QQW@!")) ||
(HttpContext?.User?.Identity?.Name ?? "") == "sachin")
{
user.ETag = "*";
TableStorageHelper.MergeAsync(Constants.TABLE_USER, user).Wait();
CacheHelper.ClearUsersCache();
}
else
{
errorCode = Constants.ERROR_CODE_ACCESS_DENIED;
}
}
catch (Exception ex)
{
if (!TableStorageHelper.IsStorageException(ex, out errorCode))
{
errorCode = Constants.ERROR_CODE_COMMON;
}
}
return(RedirectToAction("Index", new { errorCode = errorCode }));
}
public IActionResult Edit(CategoryEntity entity)
{
int errorCode = 0;
try
{
if (CacheHelper.GetCategoryList(entity.PartitionKey).Count(cat => cat.NameHash.Equals(entity.NameHash) && !cat.ID.Equals(entity.ID)) > 0)
{
errorCode = Constants.ERROR_CODE_ENTITY_ALREADY_EXISTS;
}
else
{
TableStorageHelper.MergeAsync(Constants.TABLE_CATEGORY, entity).Wait();
CacheHelper.ClearCategoryListCache();
}
}
catch (Exception ex)
{
if (!TableStorageHelper.IsStorageException(ex, out errorCode))
{
errorCode = Constants.ERROR_CODE_COMMON;
}
}
return(RedirectToAction("Index", new { category = entity.PartitionKey, errorCode = errorCode }));
}
public IActionResult Add(CategoryEntity entity)
{
int errorCode = 0;
try
{
if (CacheHelper.GetCategoryList(entity.PartitionKey).Count(cat => cat.NameHash.Equals(entity.NameHash)) > 0)
{
errorCode = Constants.ERROR_CODE_ENTITY_ALREADY_EXISTS;
}
else
{
string nextSortNumber = SequenceHelper.GetNextSequence(Constants.SORT, Constants.TABLE_CATEGORY + "_" + entity.PartitionKey, Constants.PADDING_SORT);
string nextID = SequenceHelper.GetNextSequence(Constants.ID, Constants.TABLE_CATEGORY, Constants.PADDING_CATEGORYID);
entity.RowKey = nextSortNumber + "_" + nextID;
TableStorageHelper.InsertOrMergeAsync(Constants.TABLE_CATEGORY, entity).Wait();
CacheHelper.ClearCategoryListCache();
}
}
catch (Exception ex)
{
if (!TableStorageHelper.IsStorageException(ex, out errorCode))
{
errorCode = Constants.ERROR_CODE_COMMON;
}
}
return(RedirectToAction("Index", new { category = entity.PartitionKey, errorCode = errorCode }));
}
//public IActionResult Delete(CategoryEntity entity)
//{
// int errorCode = 0;
// try
// {
// entity.Visibility = false;
// TableStorageHelper.MergeAsync(Constants.TABLE_CATEGORY, entity).Wait();
// CacheHelper.ClearCategoryListCache();
// }
// catch (Exception ex)
// {
// if (!TableStorageHelper.IsStorageException(ex, out errorCode))
// {
// errorCode = Constants.ERROR_CODE_COMMON;
// }
// }
// return RedirectToAction("Index", new { category = entity.PartitionKey, errorCode = errorCode });
//}
public IActionResult Sort(CategoryEntity up, CategoryEntity down)
{
int errorCode = 0;
try
{
CategoryEntity newUp = new CategoryEntity(up.PartitionKey, up.RowKey);
CategoryEntity newDown = new CategoryEntity(down.PartitionKey, down.RowKey);
up.CopyTo(newUp, false);
down.CopyTo(newDown, false);
string upSortNumber = up.RowKey.Split('_')[0];
string downSortNumber = down.RowKey.Split('_')[0];
newUp.RowKey = downSortNumber + "_" + newUp.ID;
newDown.RowKey = upSortNumber + "_" + newDown.ID;
TableStorageHelper.BatchAsync(Constants.TABLE_CATEGORY, new CategoryEntity[] { up, down }, new CategoryEntity[] { newUp, newDown }, null).Wait();
CacheHelper.ClearCategoryListCache();
}
catch (Exception ex)
{
if (!TableStorageHelper.IsStorageException(ex, out errorCode))
{
errorCode = Constants.ERROR_CODE_COMMON;
}
}
return(RedirectToAction("Index", new { category = up.PartitionKey, errorCode = errorCode }));
}
public IActionResult Add(UserEntity user)
{
int errorCode = 0;
try
{
TableStorageHelper.InsertAsync(Constants.TABLE_USER, user).Wait();
CacheHelper.ClearUsersCache();
}
catch (Exception ex)
{
if (!TableStorageHelper.IsStorageException(ex, out errorCode))
{
errorCode = Constants.ERROR_CODE_COMMON;
}
}
return(RedirectToAction("Index", new { errorCode = errorCode }));
}
public IActionResult UpdateStatus(TechnologyEntity technology, string StatusRemarks, bool isSubcategoryInQuery)
{
int errorCode = 0;
try
{
technology.Description = technology.Description ?? "";
TechnologyStatusEntity technologyStatus = GetTechnologyStatusEntity(technology.PartitionKey, technology.ID, technology.Status, StatusRemarks);
TableStorageHelper.BatchAsync(Constants.TABLE_TECHNOLOGY, null, new TechnologyStatusEntity[] { technologyStatus }, new TechnologyEntity[] { technology }).Wait();
}
catch (Exception ex)
{
if (!TableStorageHelper.IsStorageException(ex, out errorCode))
{
errorCode = Constants.ERROR_CODE_COMMON;
}
}
return(RedirectToAction("Index", new { errorCode = errorCode, category = technology.PartitionKey, subcategory = ((isSubcategoryInQuery) ? technology.SubcategoryID : ""), technology = technology.ID }));
}
