public IdentityPlaceTypeGroup GetById(int Id)
{
var info = new IdentityPlaceTypeGroup();
var sqlCmd = @"PlaceTypeGroup_GetById";
var parameters = new Dictionary <string, object>
{
{ "@Id", Id }
};
try
{
using (var conn = new SqlConnection(_connectionString))
{
using (var reader = MsSqlHelper.ExecuteReader(conn, CommandType.StoredProcedure, sqlCmd, parameters))
{
while (reader.Read())
{
info = ExtractPlaceTypeGroupData(reader);
}
}
}
}
catch (Exception ex)
{
var strError = "Failed to execute PlaceTypeGroup_GetPlaceTypeGroupById. Error: " + ex.Message;
throw new CustomSQLException(strError);
}
return(info);
}
public bool Update(IdentityPlaceTypeGroup identity)
{
//Common syntax
var sqlCmd = @"M_PlaceTypeGroup_Update";
//For parameters
var parameters = new Dictionary <string, object>
{
{ "@Id", identity.Id },
{ "@GroupName", identity.GroupName },
{ "@GroupCode", identity.GroupCode },
{ "@FilterOnMap", identity.FilterOnMap },
{ "@SortOrder", identity.SortOrder },
{ "@Icon", identity.Icon },
{ "@Status", identity.Status }
};
try
{
using (var conn = new SqlConnection(_connectionString))
{
MsSqlHelper.ExecuteNonQuery(conn, CommandType.StoredProcedure, sqlCmd, parameters);
}
}
catch (Exception ex)
{
var strError = "Failed to execute M_PlaceTypeGroup_Update. Error: " + ex.Message;
throw new CustomSQLException(strError);
}
return(true);
}
public int Insert(IdentityPlaceTypeGroup identity)
{
var newId = 0;
var sqlCmd = @"M_PlaceTypeGroup_Insert";
var parameters = new Dictionary <string, object>
{
{ "@GroupCode", identity.GroupCode },
{ "@GroupName", identity.GroupName },
{ "@Icon", identity.Icon },
{ "@FilterOnMap", identity.FilterOnMap },
{ "@Status", identity.Status },
{ "@SortOrder", identity.SortOrder },
{ "@CreatedBy", identity.CreatedBy }
};
try
{
using (var conn = new SqlConnection(_connectionString))
{
var reader = MsSqlHelper.ExecuteReader(conn, CommandType.StoredProcedure, sqlCmd, parameters);
if (reader.Read())
{
newId = Utils.ConvertToInt32(reader[0]);
}
}
}
catch (Exception ex)
{
var strError = "Failed to M_PlaceTypeGroup_Insert. Error: " + ex.Message;
throw new CustomSQLException(strError);
}
return(newId);
}
private IdentityPlaceTypeGroup ExtractEditFormData(PlaceTypeGroupEditModel formData)
{
var myIdetity = new IdentityPlaceTypeGroup();
myIdetity.Id = formData.Id;
myIdetity.GroupName = formData.Name;
myIdetity.GroupCode = formData.Code;
myIdetity.Icon = formData.Icon;
myIdetity.FilterOnMap = (formData.FilterOnMap == 1) ? true : false;
myIdetity.SortOrder = formData.SortOrder;
myIdetity.Status = formData.Status;
return(myIdetity);
}
private PlaceTypeGroupEditModel RenderEditModel(IdentityPlaceTypeGroup identity)
{
var editModel = new PlaceTypeGroupEditModel();
editModel.Id = identity.Id;
editModel.Name = identity.GroupName;
editModel.Code = identity.GroupCode;
editModel.FilterOnMap = (identity.FilterOnMap) ? 1 : 0;
editModel.Icon = identity.Icon;
editModel.SortOrder = identity.SortOrder;
editModel.Status = identity.Status;
editModel.LangList = identity.LangList;
return(editModel);
}
private IdentityPlaceTypeGroup ExtractCreateFormData(PlaceTypeGroupCreateModel formData)
{
var myIdetity = new IdentityPlaceTypeGroup();
myIdetity.GroupName = formData.Name;
myIdetity.GroupCode = formData.Code;
//myIdetity.UrlFriendly = UrlFriendly.ConvertToUrlFriendly(formData.Name);
myIdetity.Icon = formData.Icon;
myIdetity.FilterOnMap = Utils.ConvertToBoolean(formData.FilterOnMap);
myIdetity.SortOrder = formData.SortOrder;
myIdetity.Status = Utils.ConvertToInt32(formData.Status);
myIdetity.CreatedBy = User.Identity.GetUserId();
return(myIdetity);
}
//[AccessRoleChecker]
public ActionResult Index(ManagePlaceTypeGroupModel 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 IdentityPlaceTypeGroup
{
Keyword = !string.IsNullOrEmpty(model.Keyword) ? model.Keyword.Trim() : null,
Status = model.Status == null ? -1 : (int)model.Status
};
try
{
model.SearchResults = _mainStore.GetAll(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 IdentityPlaceTypeGroup GetDetail(int Id)
{
var info = new IdentityPlaceTypeGroup();
var sqlCmd = @"M_PlaceTypeGroup_GetDetail";
var parameters = new Dictionary <string, object>
{
{ "@Id", Id }
};
try
{
using (var conn = new SqlConnection(_connectionString))
{
using (var reader = MsSqlHelper.ExecuteReader(conn, CommandType.StoredProcedure, sqlCmd, parameters))
{
//Get base info
if (reader.Read())
{
info = ExtractPlaceTypeGroupData(reader);
}
//Get data for all languages
if (reader.NextResult())
{
while (reader.Read())
{
var langItem = new IdentityPlaceTypeGroupLang();
langItem.Id = Utils.ConvertToInt32(reader["Id"]);
langItem.LangCode = reader["LangCode"].ToString();
langItem.GroupName = reader["GroupName"].ToString();
langItem.GroupId = Utils.ConvertToInt32(reader["GroupId"]);
info.LangList.Add(langItem);
}
}
}
}
}
catch (Exception ex)
{
var strError = "Failed to execute M_PlaceTypeGroup_GetDetail. Error: " + ex.Message;
throw new CustomSQLException(strError);
}
return(info);
}
private IdentityPlaceTypeGroup ExtractPlaceTypeGroupData(IDataReader reader)
{
var record = new IdentityPlaceTypeGroup();
//Seperate properties
record.Id = Utils.ConvertToInt32(reader["Id"]);
record.GroupName = reader["GroupName"].ToString();
record.GroupCode = reader["GroupCode"].ToString();
record.Icon = reader["Icon"].ToString();
record.CultureName = record.GroupName;
record.FilterOnMap = Utils.ConvertToBoolean(reader["FilterOnMap"]);
record.SortOrder = Utils.ConvertToInt32(reader["SortOrder"]);
record.Status = Utils.ConvertToInt32(reader["Status"]);
record.CreatedDate = (reader["CreatedDate"] == DBNull.Value) ? null : (DateTime?)reader["CreatedDate"];
record.CreatedBy = reader["CreatedBy"].ToString();
return(record);
}
public List <IdentityPlaceTypeGroup> GetAll(IdentityPlaceTypeGroup filter, int currentPage, int pageSize)
{
//Common syntax
var sqlCmd = @"M_PlaceTypeGroup_GetByPage";
List <IdentityPlaceTypeGroup> listData = null;
//For paging
int offset = (currentPage - 1) * pageSize;
//For parameters
var parameters = new Dictionary <string, object>
{
{ "@Keyword", filter.Keyword },
{ "@Status", filter.Status },
{ "@Offset", offset },
{ "@PageSize", pageSize },
};
try
{
using (var conn = new SqlConnection(_connectionString))
{
using (var reader = MsSqlHelper.ExecuteReader(conn, CommandType.StoredProcedure, sqlCmd, parameters))
{
listData = ParsingListPlaceTypeGroupFromReader(reader);
}
}
}
catch (Exception ex)
{
var strError = "Failed to execute M_PlaceTypeGroup_GetByPage. Error: " + ex.Message;
throw new CustomSQLException(strError);
}
return(listData);
}