public ActionResult PreviousWorkDescriptions(string from)
{
RateSettings model = new RateSettings();
model.Items = new RateSettingsRepository().GetPreviousWorkDescriptions(from);
return(PartialView("_grid", model));
}
public ActionResult WorkDescriptions(int type = 0)
{
RateSettings model = new RateSettings();
model.Items = new RateSettingsRepository().GetWorkDescriptions(type);
return(PartialView("_grid", model));
}
public ActionResult Index(RateSettings model)
{
try
{
if (new RateSettingsRepository().InsertRateSettings(model, UserID.ToString()) == 0)
{
TempData["error"] = "Date period conflicts with previous date periods. Please change the dates and try again.";
return(View(model));
}
TempData["success"] = "Saved successfully";
return(RedirectToAction("Index"));
}
catch (Exception ex)
{
TempData["success"] = "";
TempData["error"] = "Some error occurred. Please try again.|" + ex.Message;
return(View(model));
}
}
public int InsertRateSettings(RateSettings model, string CreatedBy)
{
using (IDbConnection connection = OpenConnection(dataConnection))
{
IDbTransaction txn = connection.BeginTransaction();
try
{
string validationQuery = @"IF EXISTS(SELECT * FROM RateSettings WHERE FromDate BETWEEN CONVERT(DATETIME, @FromDate, 106) AND CONVERT(DATETIME, @ToDate, 106)
OR ToDate BETWEEN CONVERT(DATETIME, @FromDate, 106) AND CONVERT(DATETIME, @ToDate, 106))
SELECT 0 --failed
ELSE
BEGIN
IF EXISTS(SELECT * FROM RateSettings WHERE CONVERT(DATETIME, @FromDate, 106) BETWEEN FromDate AND ToDate
OR CONVERT(DATETIME, @ToDate, 106) BETWEEN FromDate AND ToDate)
SELECT 0--failed
ELSE
SELECT 1
END";
int fail = connection.Query <int>(validationQuery, model, transaction: txn).First();
if (fail == 0)
{
return(0);
}
string query1 = @"IF EXISTS(SELECT TOP 1 RateSettingsId FROM RateSettings WHERE FromDate = @FromDate AND ToDate = @ToDate)
DELETE FROM RateSettings WHERE FromDate = @FromDate AND ToDate = @ToDate;" ;
connection.Execute(query1, new { FromDate = model.FromDate, ToDate = model.ToDate }, transaction: txn);
string query = @"INSERT INTO RateSettings
(
[WorkDescriptionId],
[MinRate],
[MediumRate],
[MaxRate],
[FromDate],
[ToDate]
)
VALUES
(
@WorkDescriptionId,
@MinRate,
@MediumRate,
@MaxRate,
@FromDate,
@ToDate
);";
foreach (var item in model.Items)
{
if (item.MinRate != 0 && item.MediumRate != 0 && item.MaxRate != 0)
{
connection.Execute(query, new
{
WorkDescriptionId = item.WorkDescriptionId,
MinRate = item.MinRate,
MediumRate = item.MediumRate,
MaxRate = item.MaxRate,
FromDate = model.FromDate,
ToDate = model.ToDate
}, txn);
}
}
InsertLoginHistory(dataConnection, CreatedBy, "Create", "Rate Settings", "0", "0");
txn.Commit();
return(1);
}
catch (Exception ex)
{
txn.Rollback();
throw ex;
}
}
}
private void Delete()
{
m_Success = false;
MessageDisplay msgDisplay = CreateMessageDisplay();
int nodeID = _Request.Get <int>("nodeID", Method.Get, 0);
if (CurrentRateSet.NodeID != nodeID)
{
msgDisplay.AddError("当前版块评分设置继承至上级版块，不能进行删除操作，如要修改请修改上级版块评分设置或者把评分设置设为自定义");
return;
}
if (PointType == null)
{
msgDisplay.AddError(new InvalidParamError("pointtype"));
return;
}
int sortOrder = _Request.Get <int>("sortorder", Method.Get, 0);
RateSettings setting = new RateSettings();
setting.RateSets = new RateSetCollection();
foreach (RateSet set in AllSettings.Current.RateSettings.RateSets)
{
if (set.NodeID != nodeID)
{
setting.RateSets.Add(set);
}
else
{
RateSet tempSet = new RateSet();
tempSet.NodeID = nodeID;
tempSet.RateItems = new RateSetItemCollection();
for (int i = 0; i < set.RateItems.Count; i++)
{
RateSetItem item = set.RateItems[i];
if (item.PointType == PointType.Value && sortOrder == item.RoleSortOrder && item.RoleID != Guid.Empty)
{
}
else
{
tempSet.RateItems.Add(item);
}
}
setting.RateSets.Add(tempSet);
}
}
try
{
if (!SettingManager.SaveSettings(setting))
{
CatchError <ErrorInfo>(delegate(ErrorInfo error)
{
msgDisplay.AddError(error);
});
}
else
{
string urlRef = Request.UrlReferrer.ToString();
string query;
int index = urlRef.IndexOf('?');
if (index > 0)
{
query = urlRef.Substring(index + 1);
}
else
{
query = string.Empty;
}
string url = Request.RawUrl;
if (url.IndexOf('?') > -1)
{
url = url.Substring(0, url.IndexOf('?'));
}
url = url + "?" + query;
BbsRouter.JumpToUrl(url, "success=true");
}
//Response.Redirect(Request.UrlReferrer.ToString());
}
catch (Exception ex)
{
msgDisplay.AddError(ex.Message);
}
}
public bool saveSettings()
{
m_Success = false;
MessageDisplay msgDisplay = null;
if (_Request.Get("inheritType", Method.Post, "False").ToLower() == "true")
{
msgDisplay = CreateMessageDisplay();
RateSettings tempSetting = new RateSettings();
tempSetting.RateSets = new RateSetCollection();
foreach (RateSet set in AllSettings.Current.RateSettings.RateSets)
{
if (set.NodeID != ForumID)
{
tempSetting.RateSets.Add(set);
}
}
try
{
if (!SettingManager.SaveSettings(tempSetting))
{
CatchError <ErrorInfo>(delegate(ErrorInfo error)
{
msgDisplay.AddError(error);
});
}
else
{
BbsRouter.JumpToUrl(Request.RawUrl, "success=true");
}
}
catch (Exception ex)
{
msgDisplay.AddError(ex.Message);
}
return(true);
}
string[] errorNames = new string[EnabledUserPointList.Count * 2];
int i = 0;
foreach (UserPoint point in EnabledUserPointList)
{
errorNames[i] = point.Type.ToString();
i++;
errorNames[i] = "new_" + point.Type.ToString();
i++;
}
msgDisplay = CreateMessageDisplay(errorNames);
RateSetItemCollection tempRankItems = new RateSetItemCollection();
foreach (UserPoint point in EnabledUserPointList)
{
int[] tempIds = StringUtil.Split <int>(_Request.Get("id_" + point.Type.ToString(), Method.Post, string.Empty));
List <int> sortOrdes = new List <int>();
RateSetItem item;
foreach (int id in tempIds)
{
item = GetRankSetItem(point.Type, id, false, msgDisplay);
if (item != null)
{
if (id != 0 && sortOrdes.Contains(item.RoleSortOrder) && msgDisplay.HasAnyError() == false)
{
msgDisplay.AddError(point.Type.ToString(), id, "排序数字不能重复");
}
else
{
if (id != 0)
{
sortOrdes.Add(item.RoleSortOrder);
}
tempRankItems.Add(item);
}
}
}
item = GetRankSetItem(point.Type, 0, true, msgDisplay);
if (item != null)
{
if (sortOrdes.Contains(item.RoleSortOrder) && msgDisplay.HasAnyError() == false)
{
msgDisplay.AddError("new_" + point.Type.ToString(), "排序数字不能重复");
}
tempRankItems.Add(item);
}
}
if (msgDisplay.HasAnyError())
{
return(false);
}
RateSet rateSet = new RateSet();
rateSet.NodeID = ForumID;
rateSet.RateItems = tempRankItems;
RateSettings setting = new RateSettings();
setting.RateSets = new RateSetCollection();
foreach (RateSet set in AllSettings.Current.RateSettings.RateSets)
{
if (set.NodeID != ForumID)
{
setting.RateSets.Add(set);
}
}
setting.RateSets.Add(rateSet);
try
{
if (!SettingManager.SaveSettings(setting))
{
CatchError <ErrorInfo>(delegate(ErrorInfo error)
{
msgDisplay.AddError(error);
});
}
else
{
BbsRouter.JumpToUrl(Request.RawUrl, "success=true");
}
}
catch (Exception ex)
{
msgDisplay.AddError(ex.Message);
}
return(true);
}
