public bool SaveCostCentre(CostCentreModel model)
{
try
{
if (model != null)
{
CostCentre costCentre = new CostCentre
{
costcentrename = model.costcentrename,
remark = model.remark,
isActive = true,
};
tRSEntities4.CostCentres.Add(costCentre);
tRSEntities4.SaveChanges();
return(true);
}
else
{
return(false);
}
}
catch (Exception e)
{
throw e;
}
}
internal DataTable LoadMainCost(CostCentreModel ObjCostCentreModel)
{
try
{
ClsCon.cmd = new SqlCommand();
ClsCon.cmd.CommandType = CommandType.StoredProcedure;
ClsCon.cmd.CommandText = "SPCostCentre";
ClsCon.cmd.CommandType = CommandType.StoredProcedure;
ClsCon.cmd.Parameters.AddWithValue("@Ind", ObjCostCentreModel.Ind);
ClsCon.cmd.Parameters.AddWithValue("@OrgID", ObjCostCentreModel.OrgID);
ClsCon.cmd.Parameters.AddWithValue("@BrID", ObjCostCentreModel.BrID);
con = ClsCon.SqlConn();
ClsCon.cmd.Connection = con;
dtCostCentre = new DataTable();
ClsCon.da = new SqlDataAdapter(ClsCon.cmd);
ClsCon.da.Fill(dtCostCentre);
dtCostCentre.TableName = "success";
}
catch (Exception)
{
dtCostCentre = new DataTable();
dtCostCentre.TableName = "error";
return(dtCostCentre);
}
finally
{
con.Close();
con.Dispose();
ClsCon.da.Dispose();
ClsCon.cmd.Dispose();
}
return(dtCostCentre);
}
public void NewCostCentreMustUseParentHeirarchyInNode()
{
//Arrange
var ctx = CreateContext();
mockCentres
.Setup(set => set.Find(It.Is <object[]>(objects => (string)objects[0] == CostCentre1)))
.Returns(() => centres[1]);
mockCentres
.Setup(set => set.Create())
.Returns(new CostCentre())
.Verifiable();
mockCentres
.Setup(set => set.Add(It.Is <CostCentre>(c => c.Node == new HierarchyId("/1/3/"))))
.Verifiable();
ctx
.SetupGet(c => c.CostCentres)
.Returns(mockCentres.Object);
var sut = new CostCentreController(ctx.Object);
var newCentre = new CostCentreModel
{
costCode = "new",
parentCostCode = CostCentre1,
name = "name",
color = "FFFFFF",
currencyCode = new Select2Model()
};
//Act
sut.UpsertCostCentre(newCentre);
//Assert
mockCentres.Verify();
}
public ActionResult UpsertCostCentre(CostCentreModel costCentre)
{
var costCode = costCentre.costCode;
if ((string.IsNullOrEmpty(costCentre.name)) ||
(string.IsNullOrEmpty(costCentre.color)))
{
return(Json(new { costCode, success = false }));
}
var parentCostCode = string.IsNullOrEmpty(costCentre.parentCostCode)
? Settings.Default.RootCostCentre
: costCentre.parentCostCode;
if (string.Equals(parentCostCode, costCode, StringComparison.InvariantCultureIgnoreCase))
{
return(Json(new { costCode, success = false }));
}
var update = true;
var centre = context.CostCentres.Find(costCode);
var parentCentre = context.CostCentres.Find(parentCostCode);
if (parentCentre == null)
{
return(Json(new { costCode, success = false }));
}
var parentNode = parentCentre.Node;
if (centre == null)
{
update = false;
centre = context.CostCentres.Create();
costCentre.orderId =
context
.CostCentres
.Count(centre1 => centre1.ParentCostCentreCostCode == parentCostCode) + 1;
costCentre.node = parentNode.ToString() + costCentre.orderId + "/";
centre.ParentCostCentreCostCode = parentCostCode;
centre.CostCode = costCode;
}
centre.Node = new HierarchyId(costCentre.node);
centre.Color = costCentre.color;
centre.ConsumptionType = GetConsumptionType(costCentre.consumptionTypes);
centre.CurrencyCode = costCentre.currencyCode.id;
centre.Description = costCentre.description;
centre.Name = costCentre.name;
centre.OrderId = costCentre.orderId;
if (!update)
{
context.CostCentres.Add(centre);
}
context.SaveChanges();
return(Json(new { costCode, success = true }));
}
public CostCentreModel GetCostCentreModel(int id)
{
try
{
var data = tRSEntities4.CostCentres.Where(x => x.id == id && x.isActive == true).FirstOrDefault();
if (data != null)
{
CostCentreModel centreModel = new CostCentreModel();
centreModel.costcentrename = data.costcentrename;
centreModel.remark = data.remark;
return(centreModel);
}
else
{
return(null);
}
}
catch (Exception e)
{
throw e;
}
}
public bool UpdateCostCentre(CostCentreModel model)
{
try
{
var data = tRSEntities4.CostCentres.Where(x => x.id == model.id && x.isActive == true).FirstOrDefault();
if (data != null)
{
data.costcentrename = model.costcentrename;
data.remark = model.remark;
data.isActive = true;
tRSEntities4.SaveChanges();
return(true);
}
else
{
return(false);
}
}
catch (Exception e)
{
throw e;
}
}
public List <CostCentreModel> GetCostCentreModels()
{
try
{
List <CostCentreModel> centreModels = new List <CostCentreModel>();
var data = tRSEntities4.CostCentres.Where(x => x.isActive == true).ToList();
foreach (var item in data)
{
CostCentreModel model = new CostCentreModel
{
id = item.id,
costcentrename = item.costcentrename,
remark = item.remark,
isActive = true,
};
centreModels.Add(model);
}
return(centreModels);
}
catch (Exception e)
{
throw e;
}
}
public IHttpActionResult SaveCostCentre(CostCentreModel model)
{
var data = costCentreRepo.SaveCostCentre(model);
return(Ok(data));
}
public DataTable DeleteCostCentre(CostCentreModel ObjCostCentreModel)
{
DataTable CostCentreList = ObjCostCentreDA.DeleteCostCentre(ObjCostCentreModel);
return(CostCentreList);
}
public DataTable LoadCostCentreGrid(CostCentreModel ObjCostCentreModel)
{
DataTable CostCentreList = ObjCostCentreDA.LoadMainCost(ObjCostCentreModel);
return(CostCentreList);
}
