/// <summary>
/// This function changes the "ActiveStatus" of the CompanyDB Detail object to "False"
/// </summary>
/// <param name="CompanyDBId"></param>
/// <returns></returns>
public Boolean DeleteCompanyDB(CompanyDBDTO CompanyDBDTOobject)
{
bool flag = false;
try
{
using (UnitOfWork uow = new UnitOfWork())
{
CompanyDB companydbObj = new CompanyDB();
companydbObj.CompanyDBId = CompanyDBDTOobject.CompanyDBId;
companydbObj.FkCompanyId = CompanyDBDTOobject.FkCompanyId;
companydbObj.FkDatabaseInfoId = CompanyDBDTOobject.FkDatabaseInfoId;
companydbObj.Active = false;
companydbObj.RecordStatus = CompanyDBDTOobject.RecordStatus;
companydbObj.CreatedBy = CompanyDBDTOobject.CreatedBy;
companydbObj.CreatedDate = CompanyDBDTOobject.CreatedDate;
companydbObj.LastModifiedBy = DateTime.Now;
companydbObj.LastModifiedDate = DateTime.Now.Date;
uow.CompanyDBRepo.Update(companydbObj);
uow.Complete();
flag = true;
}
}
catch (Exception e)
{
System.Diagnostics.Debug.WriteLine(e.Message);
}
return(flag);
}
/// <summary>
/// This function updates Company's Database Details in the database on the basis of "edited" details provided by the user
/// </summary>
/// <param name="CompanyDBDTOobject"></param>
/// <returns></returns>
public Boolean UpdateCompanyDBInfo(CompanyDBDTO CompanyDBDTOobject)
{
bool flag = false;
try
{
using (UnitOfWork uow = new UnitOfWork())
{
CompanyDB companydbObj = new CompanyDB();
DatabaseInfo databaseinfoObj = new DatabaseInfo();
databaseinfoObj.DatabaseInfoId = CompanyDBDTOobject.DatabaseInfo.DatabaseInfoId;
databaseinfoObj.ServerName = CompanyDBDTOobject.DatabaseInfo.ServerName;
databaseinfoObj.Authentication = CompanyDBDTOobject.DatabaseInfo.Authentication;
databaseinfoObj.UserName = CompanyDBDTOobject.DatabaseInfo.UserName;
databaseinfoObj.Password = CompanyDBDTOobject.DatabaseInfo.Password;
databaseinfoObj.Active = CompanyDBDTOobject.DatabaseInfo.Active;
databaseinfoObj.RecordStatus = CompanyDBDTOobject.DatabaseInfo.RecordStatus;
databaseinfoObj.CreatedBy = CompanyDBDTOobject.DatabaseInfo.CreatedBy;
databaseinfoObj.CreatedDate = CompanyDBDTOobject.DatabaseInfo.CreatedDate;
databaseinfoObj.LastModifiedBy = DateTime.Now;
databaseinfoObj.LastModifiedDate = DateTime.Now.Date;
uow.DatabaseInfoRepo.Update(databaseinfoObj);
uow.Complete();
flag = true;
}
}
catch (Exception e)
{
System.Diagnostics.Debug.WriteLine(e.Message);
}
return(flag);
}
/// <summary>
/// This function returns the details of CompanyDBData on the basis of CompanyDBId given by the user
/// </summary>
/// <param name="CompanyDBId"></param>
/// <returns></returns>
public CompanyDBDTO GetById(int CompanyDBId)
{
CompanyDBDTO CompanyDBDTOobject = new CompanyDBDTO();
try
{
using (UnitOfWork uow = new UnitOfWork())
{
CompanyDB companydbObj = uow.CompanyDBRepo.GetById(CompanyDBId);
CompanyDBDTOobject.CompanyDBId = companydbObj.CompanyDBId;
CompanyDBDTOobject.Active = companydbObj.Active;
CompanyDBDTOobject.RecordStatus = companydbObj.RecordStatus;
CompanyDBDTOobject.CreatedBy = companydbObj.CreatedBy;
CompanyDBDTOobject.CreatedDate = companydbObj.CreatedDate;
CompanyDBDTOobject.LastModifiedBy = companydbObj.LastModifiedBy;
CompanyDBDTOobject.LastModifiedDate = companydbObj.LastModifiedDate;
CompanyDBDTOobject.FkCompanyId = companydbObj.FkCompanyId;
CompanyDBDTOobject.FkDatabaseInfoId = companydbObj.FkDatabaseInfoId;
CompanyDBDTOobject.Company = new CompanyDTO
{
CompanyId = companydbObj.Company.CompanyId,
Company1 = companydbObj.Company.Company1,
CompanyCode = companydbObj.Company.CompanyCode,
Active = companydbObj.Company.Active,
RecordStatus = companydbObj.Company.RecordStatus,
CreatedBy = companydbObj.Company.CreatedBy,
CreatedDate = companydbObj.Company.CreatedDate,
LastModifiedBy = companydbObj.Company.LastModifiedBy,
LastModifiedDate = companydbObj.Company.LastModifiedDate
};
CompanyDBDTOobject.DatabaseInfo = new DatabaseInfoDTO
{
DatabaseInfoId = companydbObj.DatabaseInfo.DatabaseInfoId,
ServerName = companydbObj.DatabaseInfo.ServerName,
Authentication = companydbObj.DatabaseInfo.Authentication,
UserName = companydbObj.DatabaseInfo.UserName,
Password = companydbObj.DatabaseInfo.Password,
Active = companydbObj.DatabaseInfo.Active,
RecordStatus = companydbObj.DatabaseInfo.RecordStatus,
CreatedBy = companydbObj.DatabaseInfo.CreatedBy,
CreatedDate = companydbObj.DatabaseInfo.CreatedDate,
LastModifiedBy = companydbObj.DatabaseInfo.LastModifiedBy,
LastModifiedDate = companydbObj.DatabaseInfo.LastModifiedDate
};
}
}
catch (Exception e)
{
System.Diagnostics.Debug.WriteLine(e.Message);
}
return(CompanyDBDTOobject);
}
public async Task <JsonResult> CompanyDBInfoByIdInJson(int CompanyDBId)
{
CompanyDBDTO CompanyDBDTOobject = new CompanyDBDTO();
using (var client = new HttpClient())
{
client.BaseAddress = new Uri("http://localhost:49750/");
HttpResponseMessage response = await client.GetAsync("api/CompanyDB/CompanyDBDataById/?CompanyDBId=" + CompanyDBId);
if (response.IsSuccessStatusCode)
{
CompanyDBDTOobject = response.Content.ReadAsAsync <CompanyDBDTO>().Result;
}
return(Json(CompanyDBDTOobject, JsonRequestBehavior.AllowGet));
}
}
/// <summary>
/// This function adds Company's Database Details in the database on the basis of data provided by the user
/// </summary>
/// <param name="CompanyDBDTOobject"></param>
/// <returns></returns>
public Boolean AddCompanyDBInfo(CompanyDBDTO CompanyDBDTOobject)
{
bool flag = false;
try
{
using (UnitOfWork uow = new UnitOfWork())
{
CompanyDB companydbObj = new CompanyDB();
DatabaseInfo databaseinfoObj = new DatabaseInfo();
databaseinfoObj.ServerName = CompanyDBDTOobject.DatabaseInfo.ServerName;
databaseinfoObj.Authentication = CompanyDBDTOobject.DatabaseInfo.Authentication;
databaseinfoObj.UserName = CompanyDBDTOobject.DatabaseInfo.UserName;
databaseinfoObj.Password = CompanyDBDTOobject.DatabaseInfo.Password;
databaseinfoObj.Active = true;
databaseinfoObj.RecordStatus = 1;
databaseinfoObj.CreatedBy = 123;
databaseinfoObj.CreatedDate = DateTime.Now.Date;
databaseinfoObj.LastModifiedBy = DateTime.Now;
databaseinfoObj.LastModifiedDate = DateTime.Now.Date;
uow.DatabaseInfoRepo.Add(databaseinfoObj);
uow.Complete();
companydbObj.FkDatabaseInfoId = uow.DatabaseInfoRepo.GetAll().Where(a => a.ServerName == CompanyDBDTOobject.DatabaseInfo.ServerName &&
a.Authentication == CompanyDBDTOobject.DatabaseInfo.Authentication &&
a.UserName == CompanyDBDTOobject.DatabaseInfo.UserName &&
a.Password == CompanyDBDTOobject.DatabaseInfo.Password).SingleOrDefault().DatabaseInfoId;
companydbObj.FkCompanyId = CompanyDBDTOobject.FkCompanyId;
companydbObj.Active = true;
companydbObj.RecordStatus = 1;
companydbObj.CreatedBy = 123;
companydbObj.CreatedDate = DateTime.Now.Date;
companydbObj.LastModifiedDate = DateTime.Now.Date;
companydbObj.LastModifiedBy = DateTime.Now;
uow.CompanyDBRepo.Add(companydbObj);
uow.Complete();
flag = true;
}
}
catch (Exception e)
{
System.Diagnostics.Debug.WriteLine(e.Message);
}
return(flag);
}
public IHttpActionResult CompanyDBDataById([FromUri] int CompanyDBId)
{
try
{
CompanyDBDTO CompanyDBDTOobject = CompanyDBMapBLobject.GetById(CompanyDBId);
if (CompanyDBDTOobject != null)
{
return(Ok(CompanyDBDTOobject));
}
else
{
return(NotFound());
}
}
catch (Exception e)
{
return(InternalServerError(e));
}
}
public HttpResponseMessage DeleteCompanyDB([FromBody] CompanyDBDTO CompanyDBDTOobject)
{
try
{
bool flag = CompanyDBMapBLobject.DeleteCompanyDB(CompanyDBDTOobject);
if (flag == true)
{
return(Request.CreateResponse(HttpStatusCode.OK));
}
else
{
return(Request.CreateResponse(HttpStatusCode.BadRequest));
}
}
catch (Exception e)
{
return(Request.CreateResponse(HttpStatusCode.InternalServerError, e.Message));
}
}
