public List <ItemGroupModel> Get()
{
con = new SqlConnection(GetConn());
cmd = new SqlCommand("SpParentChild", con);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@Ind", 2);
da = new SqlDataAdapter(cmd);
dt = new DataTable();
dr = cmd.ExecuteReader(CommandBehavior.CloseConnection);
list = new List <ItemGroupModel>();
while (dr.Read())
{
ItemGroupModel obj = new ItemGroupModel()
{
ItemGroup = dr["ItemGroup"].ToString(),
GroupPrimary = dr["GroupPrimary"].ToString(),
ItemUnderGroup = dr["ParentGroupID"].ToString()
};
list.Add(obj);
}
con.Close();
return(list);
}
public JsonResult UpdItemGroup(ItemGroupModel itemGroup)
{
Result data = null;
try
{
data = new Result();
string spName = "UP_ITEM_GROUP_TX_UPD";
string[] spParamName = new string[] {
"@pi_intItemGroupNo", "@pi_strItemGroupName", "@pi_strItemGroupDesc", "@pi_intUseState", "@po_intRetVal",
"@po_strErrMsg"
};
object[] spParamValue = new object[] {
itemGroup.ItemGroupNo, itemGroup.ItemGroupName, itemGroup.ItemGroupDesc, itemGroup.UseState, DBNull.Value,
DBNull.Value
};
data = dbConn.SqlExecuteSPReturnValue(spName, spParamName, spParamValue);
}
catch (Exception ex)
{
data.RetVal = 800;
data.ErrMsg = "Exception in UpdItemGroup : " + ex.Message;
return(Json(data));
}
return(Json(new { data }));
}
public JsonResult InsItemGroup(ItemGroupModel itemGroup)
{
Result data = null;
try
{
strLoginID = HttpContext.Session.GetString("loginid");
data = new Result();
string spName = "UP_ITEM_GROUP_TX_INS";
string[] spParamName = new string[] {
"@pi_strItemGroupName", "@pi_strItemGroupDesc", "@pi_strAdminID", "@po_intRetVal", "@po_strErrMsg"
};
object[] spParamValue = new object[] {
itemGroup.ItemGroupName, itemGroup.ItemGroupDesc ?? "", strLoginID, DBNull.Value, DBNull.Value
};
data = dbConn.SqlExecuteSPReturnValue(spName, spParamName, spParamValue);
}
catch (Exception ex)
{
data.RetVal = 810;
data.ErrMsg = "Exception in InsItemGroup : " + ex.Message;
return(Json(data));
}
return(Json(new { data }));
}
private svssstores_itemgroup ConvertGroupModeltoGroupEntity(ItemGroupModel itemGroupModel)
{
svssstores_itemgroup itemGroupEntity = new svssstores_itemgroup();
itemGroupEntity.itemgroup_id = itemGroupModel.ItemGroupId;
itemGroupEntity.itemgroup_groupname = itemGroupModel.ItemGroupName;
return(itemGroupEntity);
}
private ItemGroupModel ConvertGroupEntitytoGroupGroup(svssstores_itemgroup itemGroupEntity)
{
ItemGroupModel itemGroupModel = new ItemGroupModel();
itemGroupModel.ItemGroupId = itemGroupEntity.itemgroup_id;
itemGroupModel.ItemGroupName = itemGroupEntity.itemgroup_groupname;
return(itemGroupModel);
}
internal void UpdateItemGroup(ItemGroupModel itemGroupModel)
{
List <svssstores_itemgroup> itemGroupEntityLilst = DBHelper.GetItemGroupList();
svssstores_itemgroup findItem = itemGroupEntityLilst.FirstOrDefault(a => a.itemgroup_id == itemGroupModel.ItemGroupId);
if (findItem != null)
{
findItem.itemgroup_groupname = itemGroupModel.ItemGroupName;
DBHelper.SaveItemGroup(findItem);
}
}
public bool SaveItemGroup(ItemGroupModel itemGroupModel)
{
if (itemGroupModel.ItemGroupId > 0)
{
itemRepositry.UpdateItemGroup(itemGroupModel);
}
else
{
itemRepositry.AddItemGroup(itemGroupModel);
}
return true;
}
public bool SaveItemGroup(ItemGroupModel itemGroupModel)
{
if (itemGroupModel.ItemGroupId > 0)
{
itemRepositry.UpdateItemGroup(itemGroupModel);
}
else
{
itemRepositry.AddItemGroup(itemGroupModel);
}
return(true);
}
public ItemMasterViewModel()
{
itemMaster = new ItemMasterModel();
itemMasterManger = new ItemMasterManager();
itemGroup = new ItemGroupModel();
itemMasterList = new ObservableCollection<ItemMasterModel>();
saveItemCmd = new RelayCommand(Save, CanSave);
clearItemCmd = new RelayCommand(ClearItemDetails, CanClearItemDetails);
openGroupCmd = new RelayCommand(OpenPOPupView, CanOpenPOPupView);
addItemGroupCmd = new RelayCommand(SaveGroup, CanSaveGroup);
clearItemGroupCmd = new RelayCommand(SaveGroup, CanSaveGroup);
itemMasterList = itemMasterManger.GetItemList();
itemGroupList = itemMasterManger.GetIemGroupList();
this.UnitPrice = 0;
}
public ItemMasterViewModel()
{
itemMaster = new ItemMasterModel();
itemMasterManger = new ItemMasterManager();
itemGroup = new ItemGroupModel();
itemMasterList = new ObservableCollection <ItemMasterModel>();
saveItemCmd = new RelayCommand(Save, CanSave);
clearItemCmd = new RelayCommand(ClearItemDetails, CanClearItemDetails);
openGroupCmd = new RelayCommand(OpenPOPupView, CanOpenPOPupView);
addItemGroupCmd = new RelayCommand(SaveGroup, CanSaveGroup);
clearItemGroupCmd = new RelayCommand(SaveGroup, CanSaveGroup);
itemMasterList = itemMasterManger.GetItemList();
itemGroupList = itemMasterManger.GetIemGroupList();
this.UnitPrice = 0;
}
public List <ItemGroupModel> GetHiearchyList(List <ItemGroupModel> lstAll, ItemGroupModel node)
{
var lstChilds = lstAll.Where(ds => ds.parent_item_group_id == node.item_group_id).ToList();
if (lstChilds.Count == 0)
{
return(null);
}
for (int i = 0; i < lstChilds.Count; i++)
{
var childs = GetHiearchyList(lstAll, lstChilds[i]);
lstChilds[i].type = (childs == null || childs.Count == 0) ? "leaf" : "";
lstChilds[i].children = childs;
}
return(lstChilds.OrderBy(s => s.seq_num).ToList());
}
public JsonResult DetailItemGroup(ItemGroupModel itemGroup)
{
Result <ItemGroupModel> data = null;
try
{
data = new Result <ItemGroupModel>();
string spName = "UP_ITEM_GROUP_AR_LST";
string[] spParamName = new string[] {
"@pi_intItemGroupNo", "@pi_strItemGroupName", "@pi_intUseState"
};
object[] spParamValue = new object[] {
itemGroup.ItemGroupNo, DBNull.Value, DBNull.Value
};
Result <DataTable> result = dbConn.SqlExecuteSPReturnTable(spName, spParamName, spParamValue);
if (result.RetVal.Equals(0))
{
foreach (DataRow row in result.data.Rows)
{
data.data = new ItemGroupModel
{
ItemGroupNo = Convert.ToInt64(row["ITEMGROUPNO"]),
ItemGroupName = row["ITEMGROUPNAME"].ToString(),
ItemGroupDesc = row["ITEMGROUPDESC"].ToString() ?? "",
UseState = Convert.ToInt16(row["USESTATE"]),
RegDate = row["REGDATE"].ToString(),
UpdDate = row["UPDDATE"].ToString() ?? ""
};
}
}
}
catch (Exception ex)
{
data.RetVal = 820;
data.ErrMsg = "Exception in DetailItemGroup : " + ex.Message;
return(Json(data));
}
return(Json(new { data }));
}
public void SaveGroup(object obj)
{
var itemGroupDet = new ItemGroupModel {
ItemGroupId = this.ItemGroupId, ItemGroupName = this.ItemGroupName
};
if (itemMasterManger.SaveItemGroup(itemGroupDet))
{
this.ItemGroupList = itemMasterManger.GetIemGroupList();
MessageBox.Show("Group Saved Successfully");
this.IsItemgroupOpen = Xceed.Wpf.Toolkit.WindowState.Closed;
ClearGroupDetails();
}
else
{
MessageBox.Show("Unable to Save Group");
}
}
public JsonResult GetItemGroupList(ItemGroupModel itemGroup)
{
List <ItemGroupModel> data = new List <ItemGroupModel>();
try
{
string spName = "UP_ITEM_GROUP_AR_LST";
string[] spParamName = new string[] {
"@pi_intItemGroupNo", "@pi_strItemGroupName", "@pi_intUseState"
};
object[] spParamValue = new object[] {
itemGroup.ItemGroupNo, DBNull.Value, itemGroup.UseState
};
Result <DataTable> result = dbConn.SqlExecuteSPReturnTable(spName, spParamName, spParamValue);
if (result.RetVal.Equals(0))
{
foreach (DataRow row in result.data.Rows)
{
ItemGroupModel obj = new ItemGroupModel
{
ItemGroupNo = Convert.ToInt64(row["ITEMGROUPNO"]),
ItemGroupName = row["ITEMGROUPNAME"].ToString(),
UseState = Convert.ToInt16(row["USESTATE"]),
RegDate = row["REGDATE"].ToString(),
UpdDate = row["UPDDATE"].ToString() ?? ""
};
data.Add(obj);
}
}
}
catch (Exception ex)
{
Console.WriteLine("Exception in GetItemGroupList : " + ex.Message);
return(Json(data));
}
return(Json(new { data }));
}
public bool Update(ItemGroupModel model)
{
string msgError = "";
try
{
var result = _dbHelper.ExecuteScalarSProcedureWithTransaction(out msgError, "sp_itemgroup_update",
"@item_group_id", model.item_group_id,
"@item_group_name", model.item_group_name
);
if ((result != null && !string.IsNullOrEmpty(result.ToString())) || !string.IsNullOrEmpty(msgError))
{
throw new Exception(Convert.ToString(result) + msgError);
}
return(true);
}
catch (Exception ex)
{
throw ex;
}
}
internal void AddItemGroup(ItemGroupModel itemGroupModel)
{
svssstores_itemgroup itemGroupEntity = ConvertGroupModeltoGroupEntity(itemGroupModel);
bool returnResult = DBHelper.SaveItemGroup(itemGroupEntity);
}
private ItemGroupModel ConvertGroupEntitytoGroupGroup(svssstores_itemgroup itemGroupEntity)
{
ItemGroupModel itemGroupModel = new ItemGroupModel();
itemGroupModel.ItemGroupId = itemGroupEntity.itemgroup_id;
itemGroupModel.ItemGroupName = itemGroupEntity.itemgroup_groupname;
return itemGroupModel;
}
public ItemGroupModel CreateItemGroup([FromBody] ItemGroupModel model)
{
model.item_group_id = Guid.NewGuid().ToString();
_itemGroupBusiness.Create(model);
return(model);
}
public bool Update(ItemGroupModel model)
{
return(_res.Update(model));
}
public IHttpActionResult Default(ItemGroupModel pl)
{
return(Ok("Success"));
}
public void SaveGroup(object obj)
{
var itemGroupDet = new ItemGroupModel { ItemGroupId = this.ItemGroupId, ItemGroupName = this.ItemGroupName };
if (itemMasterManger.SaveItemGroup(itemGroupDet))
{
this.ItemGroupList = itemMasterManger.GetIemGroupList();
MessageBox.Show("Group Saved Successfully");
this.IsItemgroupOpen = Xceed.Wpf.Toolkit.WindowState.Closed;
ClearGroupDetails();
}
else
{
MessageBox.Show("Unable to Save Group");
}
}
internal void AddItemGroup(ItemGroupModel itemGroupModel)
{
svssstores_itemgroup itemGroupEntity = ConvertGroupModeltoGroupEntity(itemGroupModel);
bool returnResult = DBHelper.SaveItemGroup(itemGroupEntity);
}
private svssstores_itemgroup ConvertGroupModeltoGroupEntity(ItemGroupModel itemGroupModel)
{
svssstores_itemgroup itemGroupEntity = new svssstores_itemgroup();
itemGroupEntity.itemgroup_id = itemGroupModel.ItemGroupId;
itemGroupEntity.itemgroup_groupname = itemGroupModel.ItemGroupName;
return itemGroupEntity;
}
public bool Create(ItemGroupModel model)
{
return(_res.Create(model));
}
internal void UpdateItemGroup(ItemGroupModel itemGroupModel)
{
List<svssstores_itemgroup> itemGroupEntityLilst = DBHelper.GetItemGroupList();
svssstores_itemgroup findItem = itemGroupEntityLilst.FirstOrDefault(a => a.itemgroup_id == itemGroupModel.ItemGroupId);
if (findItem != null)
{
findItem.itemgroup_groupname = itemGroupModel.ItemGroupName;
DBHelper.SaveItemGroup(findItem);
}
}
public ItemGroupModel UpdateItemGroup([FromBody] ItemGroupModel model)
{
_itemGroupBusiness.Update(model);
return(model);
}
