public IdentityProject GetById(int Id)
{
var sqlCmd = @"Project_GetById";
IdentityProject info = null;
var parameters = new Dictionary <string, object>
{
{ @"Id", Id }
};
try
{
using (var conn = new SqlConnection(_connectinString))
{
using (var reader = MsSqlHelper.ExecuteReader(conn, CommandType.StoredProcedure, sqlCmd, parameters))
{
if (reader.Read())
{
info = ExtractProjectData(reader);
}
}
}
}
catch (Exception ex)
{
var strError = "Failed to execute Project_GetById. Error: " + ex.Message;
throw new CustomSQLException(strError);
}
return(info);
}
public List <IdentityProject> GetByPage(IdentityProject filter, int currentPage, int pageSize)
{
var sqlCmd = @"Project_GetByPage";
List <IdentityProject> listData = null;
int offset = (currentPage - 1) * pageSize;
var paramaters = new Dictionary <string, object>
{
{ @"Keyword", filter.Keyword },
{ @"Status", filter.Status },
{ @"offset", offset },
{ @"pageSize", pageSize },
};
try
{
using (var conn = new SqlConnection(_connectinString))
{
using (var reader = MsSqlHelper.ExecuteReader(conn, CommandType.StoredProcedure, sqlCmd, paramaters))
{
listData = ParsingListFromReader(reader);
}
}
}
catch (Exception ex)
{
var strError = "Failed to execute Project_GetByPage. Error: " + ex.Message;
throw new CustomSQLException(strError);
}
return(listData);
}
public ActionResult Index(ManageProjectModel model)
{
int currentPage = 1;
int pageSize = SystemSettings.DefaultPageSize;
if (string.IsNullOrEmpty(model.SearchExec))
{
model.SearchExec = "Y";
if (!ModelState.IsValid)
{
ModelState.Clear();
}
}
if (Request["Page"] != null)
{
currentPage = Utils.ConvertToInt32(Request["Page"], 1);
}
var filter = new IdentityProject
{
Keyword = !string.IsNullOrEmpty(model.Keyword) ? model.Keyword.Trim() : null,
Status = model.Status == null ? -1 : (int)model.Status,
};
try
{
model.Companys = CommonHelpers.GetListCompany();
model.ProjectCategorys = CommonHelpers.GetListProjectCatefory();
model.SearchResults = _mainStore.GetByPage(filter, currentPage, SystemSettings.DefaultPageSize);
if (model.SearchResults != null && model.SearchResults.Count > 0)
{
model.TotalCount = model.SearchResults[0].TotalCount;
model.CurrentPage = currentPage;
model.PageSize = pageSize;
}
}
catch (Exception ex)
{
this.AddNotification(NotifSettings.Error_SystemBusy, NotificationType.ERROR);
logger.Error("Failed to get data because: " + ex.ToString());
return(View(model));
}
return(View(model));
}
public ProjectEditModel RenderEditProject(IdentityProject identity)
{
var editModel = new ProjectEditModel();
editModel.Code = identity.Code;
editModel.ProjectCategoryId = identity.ProjectCategoryId;
editModel.CompanyId = identity.CompanyId;
editModel.ProjectCategorys = CommonHelpers.GetListProjectCatefory();
editModel.Companys = CommonHelpers.GetListCompany();
editModel.Name = identity.Name;
editModel.ShortDescription = identity.ShortDescription;
editModel.Detail = identity.Detail;
editModel.BeginDate = identity.BeginDate;
editModel.FinishDate = identity.FinishDate;
editModel.Status = identity.Status;
return(editModel);
}
public IdentityProject ExtractCreateFormData(ProjectCreateModel formData)
{
var myIdentity = new IdentityProject();
myIdentity.Code = formData.Code;
myIdentity.ProjectCategoryId = formData.ProjectCategoryId;
myIdentity.CompanyId = formData.CompanyId;
myIdentity.Name = formData.Name;
myIdentity.ShortDescription = formData.ShortDescription;
myIdentity.Detail = formData.Detail;
//myIdentity.BeginDate = Convert.ToDateTime(formData.BeginDate);
//myIdentity.FinishDate = Convert.ToDateTime(formData.FinishDate);
myIdentity.BeginDate = formData.BeginDate;
myIdentity.FinishDate = formData.FinishDate;
myIdentity.Status = formData.Status;
return(myIdentity);
}
public int Insert(IdentityProject identity)
{
var sqlCmd = @"Project_Insert";
var newId = 0;
var strNow = DateTime.Now.ToString("dd/mm/yyyy h:mm");
var parameters = new Dictionary <string, object>
{
{ @"Code", identity.Code },
{ @"ProjectCategoryId", identity.ProjectCategoryId },
{ @"CompanyId", identity.CompanyId },
{ @"Name", identity.Name },
{ @"ShortDescription", identity.ShortDescription },
{ @"Detail", identity.Detail },
{ @"BeginDate", identity.BeginDate },
{ @"FinishDate", identity.FinishDate },
{ @"CreatedBy", identity.CreatedBy },
{ @"CreatedDate", strNow },
{ @"Status", identity.Status },
};
try
{
using (var conn = new SqlConnection(_connectinString))
{
var returnObj = MsSqlHelper.ExecuteScalar(conn, CommandType.StoredProcedure, sqlCmd, parameters);
newId = Convert.ToInt32(returnObj);
}
}
catch (Exception ex)
{
var strError = "Failed to execute Project_Insert. Error: " + ex.Message;
throw new CustomSQLException(strError);
}
return(newId);
}
public IdentityProject ExtractProjectData(IDataReader reader)
{
var record = new IdentityProject();
record.Id = Utils.ConvertToInt32(reader["Id"]);
record.Code = reader["Code"].ToString();
record.ProjectCategoryId = Utils.ConvertToInt32(reader["ProjectCategoryId"]);
record.CompanyId = Utils.ConvertToInt32(reader["CompanyId"]);
record.Name = reader["Name"].ToString();
record.ShortDescription = reader["ShortDescription"].ToString();
record.Detail = reader["Detail"].ToString();
record.BeginDate = reader["BeginDate"] == DBNull.Value ? null : (DateTime?)reader["BeginDate"];
record.FinishDate = reader["FinishDate"] == DBNull.Value ? null : (DateTime?)reader["FinishDate"];
record.CreatedBy = Utils.ConvertToInt32(reader["CreatedBy"]);
record.CreatedDate = reader["CreatedDate"] == DBNull.Value ? null : (DateTime?)reader["CreatedDate"];
//record.LastUpdatedBy = Utils.ConvertToInt32(reader["LastUpdatedBy"]);
//record.LastUpdated = reader["LastUpdated"] == DBNull.Value ? null : (DateTime?)reader["LastUpdated"];
record.Status = Utils.ConvertToInt32(reader["Status"]);
return(record);
}
public bool Update(IdentityProject identity)
{
return(myRepository.Update(identity));
}
public int Insert(IdentityProject filter)
{
return(myRepository.Insert(filter));
}
public List <IdentityProject> GetByPage(IdentityProject filter, int currentPage, int pageSize)
{
return(myRepository.GetByPage(filter, currentPage, pageSize));
}
