public int UpdateLang(IdentityCategoryLang identity)
{
//Common syntax
var sqlCmd = @"M_Category_UpdateLang";
var newId = 0;
//For parameters
var parameters = new Dictionary <string, object>
{
{ "@Id", identity.Id },
{ "@Name", identity.Name },
{ "@LangCode", identity.LangCode },
{ "@UrlFriendly", identity.UrlFriendly },
{ "@CategoryId", identity.CategoryId }
};
try
{
using (var conn = new SqlConnection(_connectionString))
{
var returnObj = MsSqlHelper.ExecuteScalar(conn, CommandType.StoredProcedure, sqlCmd, parameters);
newId = Convert.ToInt32(returnObj);
}
}
catch (Exception ex)
{
var strError = "Failed to execute M_Category_UpdateLang. Error: " + ex.Message;
throw new CustomSQLException(strError);
}
return(newId);
}
public IdentityCategory GetDetail(int Id)
{
var info = new IdentityCategory();
var sqlCmd = @"M_Category_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 = ExtractCategoryData(reader);
}
//Get data for all languages
if (reader.NextResult())
{
while (reader.Read())
{
var langItem = new IdentityCategoryLang();
langItem.Id = Utils.ConvertToInt32(reader["Id"]);
langItem.LangCode = reader["LangCode"].ToString();
langItem.Name = reader["Name"].ToString();
langItem.UrlFriendly = reader["UrlFriendly"].ToString();
langItem.CategoryId = Utils.ConvertToInt32(reader["CategoryId"]);
info.LangList.Add(langItem);
}
}
}
}
}
catch (Exception ex)
{
var strError = "Failed to execute M_Category_GetDetail. Error: " + ex.Message;
throw new CustomSQLException(strError);
}
return(info);
}
public IdentityCategoryLang GetLangDetail(int Id)
{
IdentityCategoryLang info = null;
var sqlCmd = @"M_Category_GetLangDetail";
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))
{
if (reader.Read())
{
info = new IdentityCategoryLang();
info.Id = Utils.ConvertToInt32(reader["Id"]);
info.LangCode = reader["LangCode"].ToString();
info.Name = reader["Name"].ToString();
info.UrlFriendly = reader["UrlFriendly"].ToString();
info.CategoryId = Utils.ConvertToInt32(reader["CategoryId"]);
}
}
}
}
catch (Exception ex)
{
var strError = "Failed to execute M_Category_GetLangDetail. Error: " + ex.Message;
throw new CustomSQLException(strError);
}
return(info);
}
public int UpdateLang(IdentityCategoryLang identity)
{
return(myRepository.UpdateLang(identity));
}
public int AddNewLang(IdentityCategoryLang identity)
{
return(myRepository.AddNewLang(identity));
}
