public HttpResponseMessage UpdateDivisionInfo(HttpRequestMessage reqObject)
{
int result = 0;
_requestedDataObject = _IDataManipulation.GetRequestedDataObject(reqObject);
if (_requestedDataObject != null && _requestedDataObject.BusinessData != null)
{
_DivisionInfo = JsonConvert.DeserializeObject <DivisionInfo>(_requestedDataObject.BusinessData);
bool IsValid = ModelValidation.TryValidateModel(_DivisionInfo, out _modelErrorMsg);
if (IsValid)
{
result = _IDivisionInfoService.UpdateDivisionInfo(_DivisionInfo);
}
}
if (!string.IsNullOrWhiteSpace(_modelErrorMsg))
{
_serviceResponse = _IDataManipulation.SetResponseObject(result, _modelErrorMsg);
}
else if (result == 1)
{
_serviceResponse = _IDataManipulation.SetResponseObject(result, "information has been updated successfully");
}
else
{
_serviceResponse = _IDataManipulation.SetResponseObject(result, "information hasn't been updated");
}
_response = _IDataManipulation.CreateResponse(_serviceResponse, reqObject);
return(_response);
}
public HttpResponseMessage GetDivisionInfoById(HttpRequestMessage reqObject)
{
string AccountStatusId = string.Empty;
_requestedDataObject = _IDataManipulation.GetRequestedDataObject(reqObject);
if (_requestedDataObject != null && _requestedDataObject.BusinessData != null)
{
_DivisionInfo = JsonConvert.DeserializeObject <DivisionInfo>(_requestedDataObject.BusinessData);
AccountStatusId = _DivisionInfo.DivisionId;
}
if (!string.IsNullOrWhiteSpace(AccountStatusId))
{
_DivisionInfo = new DivisionInfo();
_DivisionInfo = _IDivisionInfoService.GetDivisionInfoById(AccountStatusId);
}
if (_DivisionInfo != null)
{
_serviceResponse = _IDataManipulation.SetResponseObject(_DivisionInfo, "information has been fetched successfully");
}
else
{
_serviceResponse = _IDataManipulation.SetResponseObject(_DivisionInfo, "Account Status Setup Not Found...");
}
_response = _IDataManipulation.CreateResponse(_serviceResponse, reqObject);
return(_response);
}
public HttpResponseMessage DeleteDivisionInfo(HttpRequestMessage reqObject)
{
int result = 0;
_requestedDataObject = _IDataManipulation.GetRequestedDataObject(reqObject);
if (_requestedDataObject != null && _requestedDataObject.BusinessData != null)
{
_DivisionInfo = JsonConvert.DeserializeObject <DivisionInfo>(_requestedDataObject.BusinessData);
}
if (_DivisionInfo == null || string.IsNullOrWhiteSpace(_DivisionInfo.DivisionId))
{
_serviceResponse = _IDataManipulation.SetResponseObject(result, "Account Status Setup Id Not Found...");
_response = _IDataManipulation.CreateResponse(_serviceResponse, reqObject);
return(_response);
}
result = _IDivisionInfoService.DeleteDivisionInfo(_DivisionInfo);
if (result == 1)
{
_serviceResponse = _IDataManipulation.SetResponseObject(result, "information has been deleted successfully");
}
else
{
_serviceResponse = _IDataManipulation.SetResponseObject(result, "information hasn't been deleted");
}
_response = _IDataManipulation.CreateResponse(_serviceResponse, reqObject);
return(_response);
}
public int AddDivisionInfo(DivisionInfo _DivisionInfo)
{
try
{
var _max = _IUoW.Repository <DivisionInfo>().GetMaxValue(x => x.DivisionId) + 1;
_DivisionInfo.DivisionId = _max.ToString().PadLeft(3, '0');
_DivisionInfo.AuthStatusId = "A";
_DivisionInfo.LastAction = "ADD";
_DivisionInfo.MakeDT = System.DateTime.Now;
_DivisionInfo.MakeBy = "mtaka";
var result = _IUoW.Repository <DivisionInfo>().Add(_DivisionInfo);
#region Auth Log
if (result == 1)
{
_IAuthLogService = new AuthLogService();
long _outMaxSlAuthLogDtl = 0;
result = _IAuthLogService.AddAuthLog(_IUoW, null, _DivisionInfo, "ADD", "0001", "090101003", 1, "DivisionInfo", "MTK_CP_DIVISION_INFO", "DivisionId", _DivisionInfo.DivisionId, "mtaka", _outMaxSlAuthLogDtl, out _outMaxSlAuthLogDtl);
}
#endregion
if (result == 1)
{
_IUoW.Commit();
}
return(result);
}
catch (Exception ex)
{
_ObjErrorLogService = new ErrorLogService();
_ObjErrorLogService.AddErrorLog(ex, string.Empty, "AddDivisionInfo(obj)", string.Empty);
return(0);
}
}
public void AddCommandTest(bool isAdmin)
{
using (var modelContext = new TestModelContext()) {
var userId = 100;
var now = DateTime.Now;
var entity = new DivisionInfo {
DivisionID = 1
};
var securityContext = new TestSecurityContext(userId, isAdmin);
var command = new AddCommand <DivisionInfo> (modelContext, securityContext);
command.Add(entity, now);
var entityLoaded = modelContext
.QueryWhere <DivisionInfo> (d => d.DivisionID == entity.DivisionID)
.SingleOrDefault();
Assert.Equal(isAdmin, null != entityLoaded);
if (entityLoaded != null)
{
Assert.Equal(now, entityLoaded.CreatedOnDate);
Assert.Equal(now, entityLoaded.LastModifiedOnDate);
Assert.Equal(userId, entityLoaded.CreatedByUserId);
Assert.Equal(userId, entityLoaded.LastModifiedByUserId);
}
}
}
public ActionResult DeleteConfirmed(int id)
{
DivisionInfo divisionInfo = db.DivisionInfoes.Find(id);
db.DivisionInfoes.Remove(divisionInfo);
db.SaveChanges();
return(RedirectToAction("Index"));
}
public SubDivisionViewModel (DivisionInfo division, ViewModelContext context)
{
Context = context;
Title = division.Title;
HomePage = division.HomePage;
StartDate = division.StartDate;
EndDate = division.EndDate;
}
public ActionResult Edit([Bind(Include = "DivisionId,DivisionName,DivisionCode,DivisionDesc")] DivisionInfo divisionInfo)
{
if (ModelState.IsValid)
{
db.Entry(divisionInfo).State = EntityState.Modified;
db.SaveChanges();
return(RedirectToAction("CreateAndView"));
}
return(View(divisionInfo));
}
public int UpdateDivisionInfo(DivisionInfo aDivisionInfo)
{
int rowAffected = 0;
string query = "UPDATE DivisionInfo SET DivisionName='" + aDivisionInfo.DivisionName + "' WHERE Id='" + aDivisionInfo.Id + "'";
Connection.Open();
Command = new SqlCommand(query, Connection);
rowAffected = Command.ExecuteNonQuery();
Connection.Close();
return(rowAffected);
}
public int SaveDivisionName(DivisionInfo aDivisionInfo)
{
int rowAffected = 0;
string query = "INSERT INTO DivisionInfo VALUES('" + aDivisionInfo.DivisionName + "',GETDATE() )";
Connection.Open();
Command = new SqlCommand(query, Connection);
rowAffected = Command.ExecuteNonQuery();
Connection.Close();
return(rowAffected);
}
public ActionResult Create([Bind(Include = "DivisionId,DivisionName,DivisionCode,DivisionDesc")] DivisionInfo divisionInfo)
{
if (ModelState.IsValid)
{
db.DivisionInfoes.Add(divisionInfo);
db.SaveChanges();
return(RedirectToAction("Index"));
}
return(View(divisionInfo));
}
public ApiResult <DivisionResp> GetByCityId(long cityId)
{
DivisionInfo division = _divisionQueryService.QueryByCityId(cityId);
if (division == null)
{
return(new ApiResult <DivisionResp>(ResultStatus.SUCCESS, default(DivisionResp)));
}
return(new ApiResult <DivisionResp>(ResultStatus.SUCCESS, Mapper.Map <DivisionInfo, DivisionResp>(division)));
}
protected IEnumerable <OccupiedPositionInfo> GetOccupiedPositions()
{
var division1 = new DivisionInfo {
DivisionID = 1
};
var division2 = new DivisionInfo {
DivisionID = 2
};
var division3 = new DivisionInfo {
DivisionID = 3, EndDate = DateTime.Today
};
var position11 = new PositionInfo {
PositionID = 11, Title = "Director", ShortTitle = "Chief"
};
var position12 = new PositionInfo {
PositionID = 12, Title = "Manager"
};
var position13 = new PositionInfo {
PositionID = 13, Title = "Consultant"
};
return(new List <OccupiedPositionInfo> {
new OccupiedPositionInfo {
DivisionID = 1,
Division = division1,
PositionID = 11,
Position = position11
},
new OccupiedPositionInfo {
DivisionID = 2,
Division = division2,
PositionID = 12,
Position = position12,
TitleSuffix = "(main)"
},
new OccupiedPositionInfo {
DivisionID = 1,
Division = division1,
PositionID = 13,
Position = position13
},
new OccupiedPositionInfo {
DivisionID = 3,
Division = division3,
PositionID = 11,
Position = position11
}
});
}
// GET: DivisionInfoes/Edit/5
public ActionResult Edit(int?id)
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
DivisionInfo divisionInfo = db.DivisionInfoes.Find(id);
if (divisionInfo == null)
{
return(HttpNotFound());
}
return(View(divisionInfo));
}
public ActionResult CreateAndView(DivisionInfo DivisionInfoes)
{
if (ModelState.IsValid)
{
db.DivisionInfoes.Add(DivisionInfoes);
db.SaveChanges();
return(RedirectToAction("CreateAndView", "DivisionInfoes"));
}
List <DivisionInfo> objDivisionInfoList = new List <DivisionInfo>();
objDivisionInfoList = db.DivisionInfoes.ToList();
ViewBag.DivisionInfo = objDivisionInfoList;
return(View(DivisionInfoes));
}
public int UpdateDivisionInfo(DivisionInfo _DivisionInfo)
{
try
{
int result = 0;
bool IsRecordExist;
if (!string.IsNullOrWhiteSpace(_DivisionInfo.DivisionId))
{
IsRecordExist = _IUoW.Repository <DivisionInfo>().IsRecordExist(x => x.DivisionId == _DivisionInfo.DivisionId);
if (IsRecordExist)
{
var _oldDivisionInfo = _IUoW.Repository <DivisionInfo>().GetBy(x => x.DivisionId == _DivisionInfo.DivisionId);
var _oldDivisionInfoForLog = ObjectCopier.DeepCopy(_oldDivisionInfo);
_oldDivisionInfo.AuthStatusId = _DivisionInfo.AuthStatusId = "U";
_oldDivisionInfo.LastAction = _DivisionInfo.LastAction = "EDT";
_oldDivisionInfo.LastUpdateDT = _DivisionInfo.LastUpdateDT = System.DateTime.Now;
_DivisionInfo.MakeBy = "mtaka";
result = _IUoW.Repository <DivisionInfo>().Update(_oldDivisionInfo);
#region Testing Purpose
#endregion
#region Auth Log
if (result == 1)
{
_IAuthLogService = new AuthLogService();
long _outMaxSlAuthLogDtl = 0;
result = _IAuthLogService.AddAuthLog(_IUoW, _oldDivisionInfoForLog, _DivisionInfo, "EDT", "0001", "090101003", 1, "DivisionInfo", "MTK_CP_DIVISION_INFO", "DivisionId", _DivisionInfo.DivisionId, "mtaka", _outMaxSlAuthLogDtl, out _outMaxSlAuthLogDtl);
}
#endregion
if (result == 1)
{
_IUoW.Commit();
}
return(result);
}
}
return(result);
}
catch (Exception ex)
{
_ObjErrorLogService = new ErrorLogService();
_ObjErrorLogService.AddErrorLog(ex, string.Empty, "UpdateDivisionInfo(obj)", string.Empty);
return(0);
}
}
public bool IsDivisionNameExist(DivisionInfo aDivisionInfo)
{
string query = "SELECT * FROM DivisionInfo WHERE DivisionName='" + aDivisionInfo.DivisionName + "'";
Connection.Open();
Command = new SqlCommand(query, Connection);
Reader = Command.ExecuteReader();
if (Reader.HasRows)
{
return(true);
}
Reader.Close();
Connection.Close();
return(false);
}
public void DeleteCommandTest(bool isAdmin)
{
using (var modelContext = new TestModelContext()) {
var entity = new DivisionInfo {
DivisionID = 1
};
modelContext.Add(entity);
var securityContext = new TestSecurityContext(1, isAdmin);
var command = new DeleteCommand <DivisionInfo> (modelContext, securityContext);
command.Delete(entity);
Assert.Equal(isAdmin, null == modelContext
.QueryOne <DivisionInfo> (d => d.DivisionID == entity.DivisionID)
.SingleOrDefault());
}
}
public DivisionInfo GetDivisionInfoBy(DivisionInfo _DivisionInfo)
{
try
{
if (_DivisionInfo == null)
{
return(_DivisionInfo);
}
return(_IUoW.Repository <DivisionInfo>().GetBy(x => x.DivisionId == _DivisionInfo.DivisionId &&
x.AuthStatusId == "A" &&
x.LastAction != "DEL"));
}
catch (Exception ex)
{
_ObjErrorLogService = new ErrorLogService();
_ObjErrorLogService.AddErrorLog(ex, string.Empty, "GetDivisionInfoBy(obj)", string.Empty);
return(null);
}
}
public HttpResponseMessage GetDivisionInfoBy(HttpRequestMessage reqObject)
{
_requestedDataObject = _IDataManipulation.GetRequestedDataObject(reqObject);
if (_requestedDataObject != null && _requestedDataObject.BusinessData != null)
{
_DivisionInfo = JsonConvert.DeserializeObject <DivisionInfo>(_requestedDataObject.BusinessData);
_DivisionInfo = _IDivisionInfoService.GetDivisionInfoBy(_DivisionInfo);
}
if (_DivisionInfo != null)
{
_serviceResponse = _IDataManipulation.SetResponseObject(_DivisionInfo, "information has been fetched successfully");
}
else
{
_serviceResponse = _IDataManipulation.SetResponseObject(_DivisionInfo, "Account Status Setup Not Found...");
}
_response = _IDataManipulation.CreateResponse(_serviceResponse, reqObject);
return(_response);
}
public void CalculateLevelAndPathTest()
{
var root1 = new DivisionInfo {
DivisionID = 1, Title = "Root1"
};
var root1_child1 = new DivisionInfo {
DivisionID = 2, ParentDivisionID = 1, Title = "Root1.Child1"
};
var root1_child2 = new DivisionInfo {
DivisionID = 3, ParentDivisionID = 2, Title = "Root1.Child2"
};
var root1_child1_child1 = new DivisionInfo
{
DivisionID = 4,
ParentDivisionID = 1,
Title = "Root1.Child1.Child1"
};
root1.SubDivisions = new List <DivisionInfo> {
root1_child1, root1_child2
};
root1_child1.SubDivisions = new List <DivisionInfo> {
root1_child1_child1
};
var divisions = new List <DivisionInfo> {
root1, root1_child1, root1_child2, root1_child1_child1
};
var calculatedDivisions = divisions.CalculateLevelAndPath();
// check paths
Assert.Equal("/0000000001", calculatedDivisions.Single(cd => cd.DivisionID == 1).Path);
Assert.Equal("/0000000001/0000000002", calculatedDivisions.Single(cd => cd.DivisionID == 2).Path);
Assert.Equal("/0000000001/0000000003", calculatedDivisions.Single(cd => cd.DivisionID == 3).Path);
Assert.Equal("/0000000001/0000000002/0000000004", calculatedDivisions.Single(cd => cd.DivisionID == 4).Path);
// check level
Assert.Equal(0, calculatedDivisions.Single(cd => cd.DivisionID == 1).Level);
Assert.Equal(2, calculatedDivisions.Single(cd => cd.DivisionID == 4).Level);
}
public string SaveDivisionName(DivisionInfo aDivisionInfo)
{
bool isDivisionNameExist = _divisionInfoGateway.IsDivisionNameExist(aDivisionInfo);
if (!isDivisionNameExist)
{
int rowAffected = _divisionInfoGateway.SaveDivisionName(aDivisionInfo);
if (rowAffected > 0)
{
return("success");
}
else
{
return("failed");
}
}
else
{
return("exist");
}
}
public string UpdateDivisionInfo(DivisionInfo aDivisionInfo)
{
bool isDivisionNameExist = _divisionInfoGateway.IsDivisionNameExist(aDivisionInfo);
if (!isDivisionNameExist)
{
int rowAffected = _divisionInfoGateway.UpdateDivisionInfo(aDivisionInfo);
if (rowAffected > 0)
{
return("update");
}
else
{
return("failed");
}
}
else
{
return("exist");
}
}
public DivisionInfo GetDivisionDataById(int id)
{
DivisionInfo aDivisionInfo = null;
string query = "SELECT * FROM DivisionInfo WHERE Id='" + id + "'";
Connection.Open();
Command = new SqlCommand(query, Connection);
Reader = Command.ExecuteReader();
if (Reader.HasRows)
{
Reader.Read();
aDivisionInfo = new DivisionInfo
{
DivisionName = Reader["DivisionName"].ToString(),
};
Reader.Close();
}
Connection.Close();
return(aDivisionInfo);
}
public List <DivisionInfo> GetAllDivisionInfo()
{
try
{
List <DivisionInfo> OBJ_LIST_DivisionInfo = new List <DivisionInfo>();
var _ListDivisionInfo = _IUoW.Repository <DivisionInfo>().Get(x => x.AuthStatusId == "A" && x.LastAction != "DEL").OrderByDescending(x => x.DivisionId);
foreach (var item in _ListDivisionInfo)
{
DivisionInfo OBJ_DivisionInfo = new DivisionInfo();
CountryInfoService OBJ_CountryInfoService = new CountryInfoService();
OBJ_DivisionInfo.DivisionId = item.DivisionId;
OBJ_DivisionInfo.DivisionNm = item.DivisionNm;
OBJ_DivisionInfo.DivisionShortNm = item.DivisionShortNm;
OBJ_DivisionInfo.CountryId = item.CountryId;
foreach (var item1 in OBJ_CountryInfoService.GetCountryInfoForDD())
{
if (item1.Value == OBJ_DivisionInfo.CountryId)
{
OBJ_DivisionInfo.CountryNm = item1.Text;
}
}
OBJ_DivisionInfo.AuthStatusId = item.AuthStatusId;
OBJ_DivisionInfo.LastAction = item.LastAction;
OBJ_DivisionInfo.LastUpdateDT = item.LastUpdateDT;
OBJ_DivisionInfo.MakeBy = item.MakeBy;
OBJ_DivisionInfo.MakeDT = item.MakeDT;
OBJ_DivisionInfo.TransDT = item.TransDT;
OBJ_LIST_DivisionInfo.Add(OBJ_DivisionInfo);
}
return(OBJ_LIST_DivisionInfo);
}
catch (Exception ex)
{
_ObjErrorLogService = new ErrorLogService();
_ObjErrorLogService.AddErrorLog(ex, string.Empty, "GetAllDivisionInfo()", string.Empty);
return(null);
}
}
public List <DivisionInfo> GetAllDivision()
{
List <DivisionInfo> aDivisionInfos = null;
string query = "SELECT * FROM DivisionInfo ORDER BY Id DESC";
Connection.Open();
Command = new SqlCommand(query, Connection);
Reader = Command.ExecuteReader();
if (Reader.HasRows)
{
aDivisionInfos = new List <DivisionInfo>();
while (Reader.Read())
{
DivisionInfo aInfo = new DivisionInfo();
aInfo.Id = (int)Reader["Id"];
aInfo.DivisionName = Reader["DivisionName"].ToString();
aDivisionInfos.Add(aInfo);
}
Reader.Close();
}
Connection.Close();
return(aDivisionInfos);
}
public string UploadUserFromADtoIOT(string username, string empCode, string UploadBy)
{
string result = "";
DataTable dTable = new DataTable();
SqlCommand sql = new SqlCommand();
sql.CommandText = @"SELECT username";
sql.CommandText += @" WHERE username=@username";
sql.Parameters.Add(new SqlParameter("@username", username));
dTable = oConn.Query(sql);
if (dTable.Rows.Count > 0)
{
return("Error: This Username already exists in this system. If forgot your password please click 'Lost your password?' bellow.");
}
string FirstName = "";
string LastName = "";
string FullName = "";
string Department = "";
string Position = "";
string Email = "";
EmployeeInfo oEmp = new EmployeeInfo();
if (empCode != "")
{
oEmp = oHRService.GetEmployeeData(empCode);
if (oEmp != null)
{
NameInfo oNameInfo = new NameInfo();
oNameInfo = oEmp.NameInEng;
if (oNameInfo != null)
{
FirstName = oNameInfo.Name;
LastName = oNameInfo.Surname;
FullName = FirstName + " " + LastName;
}
DivisionInfo oDivision = new DivisionInfo();
oDivision = oEmp.Division;
if (oDivision != null)
{
Department = oDivision.Name;
}
PositionInfo oPosition = new PositionInfo();
oPosition = oEmp.Position;
if (oPosition != null)
{
Position = oPosition.NameEng;
}
}
Email = oEmp.Email;
}
else
{
}
try
{
sql = new SqlCommand();
sql.CommandText = @"INSERT INTO userList VALUES(@username,@password,@firstname,@lastname,@empCode,@department";
sql.CommandText += @",@position,@email,@active,@createby,@createdate,@updateby,@updatedate)";
sql.Parameters.Add(new SqlParameter("@username", username));
sql.Parameters.Add(new SqlParameter("@password", ""));
sql.Parameters.Add(new SqlParameter("@firstname", FirstName));
sql.Parameters.Add(new SqlParameter("@lastname", LastName));
sql.Parameters.Add(new SqlParameter("@empCode", empCode));
sql.Parameters.Add(new SqlParameter("@department", Department));
sql.Parameters.Add(new SqlParameter("@position", Position));
sql.Parameters.Add(new SqlParameter("@email", Email));
sql.Parameters.Add(new SqlParameter("@active", 1));
sql.Parameters.Add(new SqlParameter("@createby", UploadBy));
sql.Parameters.Add(new SqlParameter("@createdate", DateTime.Now));
sql.Parameters.Add(new SqlParameter("@updateby", UploadBy));
sql.Parameters.Add(new SqlParameter("@updatedate", DateTime.Now));
oConn.ExecuteCommand(sql);
}
catch (Exception)
{
}
return(result);
}
public DivisionObrnadzorViewModel (DivisionInfo division, ViewModelContext context)
{
CopyCstor.Copy<DivisionInfo> (division, this);
Context = context;
}
public DivisionObrnadzorViewModel(DivisionInfo division, ViewModelContext <DivisionDirectorySettings> context)
{
CopyCstor.Copy <DivisionInfo> (division, this);
Context = context;
}
