/// <summary>
///
/// </summary>
/// <param name="data"></param>
/// <returns></returns>
public bool CheckDuplicate(b2bProductGroup data)
{
try
{
int count = 0;
//if (data.ProductGroupID > 0)
//{
count = qDB.b2bProductGroups
.Where(m => m.CompID == data.CompID && m.ProductGroupName == data.ProductGroupName && m.RowFlag > 0)
.Count();
//}
if (count > 0)
{
var ex = new ArgumentException("can't save this item because item is exist");
MsgError.Add(ex);
IsResult = false;
return(IsResult);
}
else
{
IsResult = true;
return(IsResult);
}
}
catch
{
return(false);
}
}
/// <summary>
///
/// </summary>
/// <param name="model"></param>
/// <returns></returns>
public bool SaveProductGroup(b2bProductGroup model)
{
//default
if (CheckDuplicate(model))
{
var data = new b2bProductGroup();
//Update
if (model.ProductGroupID > 0)
{
data = qDB.b2bProductGroups.Single(m => m.ProductGroupID == model.ProductGroupID);
data.ProductGroupName = model.ProductGroupName;
data.ListNo = data.ListNo;
data.CompID = model.CompID;
}
//Add
else
{
data.ProductGroupName = model.ProductGroupName;
data.CompID = model.CompID;
data.ListNo = model.ListNo;
data.IsShow = true;
data.CreatedBy = "sa";
data.ModifiedBy = "sa";
data.CreatedDate = DateTimeNow;
data.ModifiedDate = DateTimeNow;
}
data.RowFlag = 1;
SaveData <b2bProductGroup>(data, "ProductGroupID");
}
return(IsResult);
}
public ActionResult SaveGroupProduct(string ProductGroupName, int?GroupID, short?RowVersion)
{
if (!CheckIsLogin())
{
return(Redirect(res.Pageviews.PvMemberSignIn));
}
var svProductGroup = new ProductGroupService();
var model = new b2bProductGroup();
try
{
#region Set Model
if (GroupID > 0)
{
model.ProductGroupID = (int)GroupID;
}
else
{
var sqlWhere = "IsDelete = 0 and CompID = " + LogonCompID;
var data = svProductGroup.SelectData <b2bProductGroup>("*", sqlWhere, "ListNo DESC");
if (svProductGroup.TotalRow == 0)
{
model.ListNo = 1;
}
else
{
model.ListNo = data.First().ListNo + 1;
}
}
if (RowVersion > 0)
{
model.RowVersion = (short)RowVersion;
}
model.ProductGroupName = ProductGroupName;
model.CompID = LogonCompID;
model.IsShow = true;
#endregion
svProductGroup.SaveProductGroup(model);
}
catch (Exception ex)
{
CreateLogFiles(ex);
}
return(Json(new { IsResult = svProductGroup.IsResult, MsgError = GenerateMsgError(svProductGroup.MsgError), ID = model.ProductGroupID }));
}
