public static ResultData <int> DeleteAll(string listId)
{
LogHelpers.LogHandler.Info("Start");
try
{
string stored = "sp_News_Delete";
object obj = new {
ListId = listId.Trim()
};
var result = DataAccessHelpers.ExecuteStoredReturnDataSet(stored, obj);
if (result.Code < 0)
{
LogHelpers.LogHandler.Error(result.ErrorMessage);
}
return(new ResultData <int>()
{
Code = result.Code,
ErrorMessage = result.ErrorMessage
});
}
catch (Exception ex)
{
LogHelpers.LogHandler.Error(ex.ToString());
return(new ResultData <int>()
{
Code = ex.HResult,
ErrorMessage = ex.Message
});
}
}
public static ResultBOL <DataSet> GetAllFromParent(int projectId)
{
string stored = "sp_Projects_GetAll_In_Menu";
object obj = new {
Id = projectId
};
var result = DataAccessHelpers.ExecuteStoredReturnDataSet(stored, obj);
return(result);
}
public static ResultBOL <DataSet> Login(string username, string password)
{
string stored = "sp_Users_Login";
Object obj = new {
Username = username,
Password = Utilities.EncryptPassword(password)
};
var result = DataAccessHelpers.ExecuteStoredReturnDataSet(stored, obj);
return(result);
}
public static ResultData <List <News> > GetAll(int menuId)
{
LogHelpers.LogHandler.Info("Start");
try
{
string stored = "sp_News_GetAll";
object obj = new {
MenuId = menuId
};
var result = DataAccessHelpers.ExecuteStoredReturnDataSet(stored, obj);
if (result.Code < 0)
{
LogHelpers.LogHandler.Error(result.ErrorMessage);
return(new ResultData <List <News> >()
{
Code = result.Code,
ErrorMessage = result.ErrorMessage
});
}
ResultData <List <News> > rs = new ResultData <List <News> >()
{
Code = 0,
Data = new List <News>()
};
if (result.Data == null || result.Data.Tables.Count == 0 || result.Data.Tables[0].Rows.Count == 0)
{
return(rs);
}
foreach (DataRow row in result.Data.Tables[0].Rows)
{
News news = new News(row);
news.Content_VN = Utilities.CreateImagesUrl(news.Id, news.Content_VN, ConfigurationManager.AppSettings["UploadImagesUrl"]);
news.Content_EN = Utilities.CreateImagesUrl(news.Id, news.Content_EN, ConfigurationManager.AppSettings["UploadImagesUrl"]);
rs.Data.Add(news);
}
return(rs);
}
catch (Exception ex)
{
LogHelpers.LogHandler.Error(ex.ToString());
return(new ResultData <List <News> >()
{
Code = ex.HResult,
ErrorMessage = ex.Message
});
}
}
public static ResultData <UserProfile> Login(string username, string passowrd)
{
try
{
LogHelpers.LogHandler.Info(string.Format("username: {0}, password: {1}", username, passowrd));
var stored = "sp_Users_Login";
object obj = new {
Username = username.Trim(),
Password = Utilities.ToMD5Hash(passowrd.Trim())
};
var result = DataAccessHelpers.ExecuteStoredReturnDataSet(stored, obj);
if (result.Code < 0)
{
return(new ResultData <UserProfile>()
{
Code = result.Code,
ErrorMessage = result.ErrorMessage
});
}
if (result.Data == null || result.Data.Tables.Count == 0 || result.Data.Tables[0].Rows.Count == 0)
{
return(new ResultData <UserProfile>()
{
Code = -104,
ErrorMessage = "Wrong username or password"
});
}
UserProfile user = new UserProfile(result.Data.Tables[0].Rows[0]);
HttpContext.Current.Session["LoggedUser"] = user;
return(new ResultData <UserProfile>()
{
Code = 0,
Data = user
});
}
catch (Exception ex)
{
LogHelpers.LogHandler.Error(ex.ToString());
return(new ResultData <UserProfile>()
{
Code = ex.HResult,
ErrorMessage = ex.Message
});
}
}
public static ResultBOL <DataSet> GetPageItems(int menuId, DateTime scanTime, string type)
{
string tag = "[ProjectsDAL][GetPageItems]";
if (scanTime == null)
{
return(new ResultBOL <DataSet> {
Code = -1,
ErrorMessage = Utilities.GetErrorMessage("NullObject")
});
}
try
{
int itemsCount;
if (type == "Home")
{
itemsCount = int.Parse(Utilities.GetApplicationSettingsValue("HomeProject-Items"));
}
else
{
itemsCount = int.Parse(Utilities.GetApplicationSettingsValue("Project-Items"));
}
object obj = new {
MenuId = menuId,
ScanTime = scanTime,
ItemsCount = itemsCount
};
string stored = "sp_Projects_GetAll_PageItems";
var result = DataAccessHelpers.ExecuteStoredReturnDataSet(stored, obj);
return(result);
}
catch (Exception ex)
{
LogHelpers.WriteException(tag, ex.ToString());
//--
return(new ResultBOL <DataSet>()
{
Code = ex.HResult,
ErrorMessage = ex.Message
});
}
}
public static ResultData <UserProfile> Get(int userId)
{
try
{
LogHelpers.LogHandler.Info("userId: " + userId);
string stored = "sp_Users_Get";
object obj = new {
Id = userId
};
var result = DataAccessHelpers.ExecuteStoredReturnDataSet(stored, obj);
if (result.Code < 0)
{
LogHelpers.LogHandler.Error(result.ErrorMessage);
return(new ResultData <UserProfile>()
{
Code = result.Code,
ErrorMessage = result.ErrorMessage
});
}
if (result.Data == null || result.Data.Tables.Count == 0 || result.Data.Tables[0].Rows.Count == 0)
{
return(new ResultData <UserProfile>()
{
Code = -104,
ErrorMessage = "Not found"
});
}
return(new ResultData <UserProfile>()
{
Code = 0,
Data = new UserProfile(result.Data.Tables[0].Rows[0])
});
}
catch (Exception ex)
{
LogHelpers.LogHandler.Error(ex.ToString());
return(new ResultData <UserProfile>()
{
Code = ex.HResult,
ErrorMessage = ex.Message
});
}
}
public static ResultData <SiteSetting> Get(int id, string type)
{
try
{
LogHelpers.LogHandler.Info(string.Format("id: {0}, type: {1}", id, type));
string stored = "sp_Settings_Get";
object obj = new {
Id = id,
Type = type
};
var result = DataAccessHelpers.ExecuteStoredReturnDataSet(stored, obj);
if (result.Code < 0)
{
LogHelpers.LogHandler.Error(result.ErrorMessage);
return(new ResultData <SiteSetting>()
{
Code = result.Code,
ErrorMessage = result.ErrorMessage
});
}
ResultData <SiteSetting> rs = new ResultData <SiteSetting>();
if (result.Data == null || result.Data.Tables.Count == 0 || result.Data.Tables[0].Rows.Count == 0)
{
rs.Data = new SiteSetting();
}
else
{
rs.Data = new SiteSetting(result.Data.Tables[0].Rows[0]);
}
return(rs);
}
catch (Exception ex)
{
LogHelpers.LogHandler.Error(ex.ToString());
return(new ResultData <SiteSetting>()
{
Code = ex.HResult,
ErrorMessage = ex.Message,
Data = new SiteSetting()
});
}
}
public static ResultBOL <DataSet> DeleteAll(string listId)
{
string stored = "sp_Projects_Delete";
Object obj = new {
Id = listId
};
if (listId.Contains(","))
{
obj = new {
listId = listId
};
stored = "sp_Projects_Multiple_Delete";
}
var result = DataAccessHelpers.ExecuteStoredReturnDataSet(stored, obj);
return(result);
}
public static ResultBOL <DataSet> DeleteAll(string listId)
{
string stored = "sp_Menu_Delete";
object obj = new {
Id = listId
};
if (listId.Contains(","))
{
stored = "sp_Menu_Multiple_Delete";
obj = new {
ListId = listId
};
}
var result = DataAccessHelpers.ExecuteStoredReturnDataSet(stored, obj);
if (result.Code == -1)
{
result.ErrorMessage = Utilities.GetErrorMessage("TableUsed");
}
return(result);
}
