/// <summary>
/// Update record by using the table's primary key.
/// </summary>
/// <param name="database"></param>
/// <param name="data">Data which to update.</param>
/// <param name="oldMENU_SUB_CD">Old Key #1</param>
/// <returns></returns>
public int UpdateWithPK(Database database, MenuSubDTO data, NZString oldMENU_SUB_CD)
{
Database db = UseDatabase(database);
StringBuilder sb = new StringBuilder();
#region SQL Statement
sb.AppendLine(" UPDATE " + data.TableName);
sb.AppendLine(" SET ");
sb.AppendLine(" " + MenuSubDTO.eColumns.MENU_SUB_CD + "=:MENU_SUB_CD");
sb.AppendLine(" ," + MenuSubDTO.eColumns.IMAGE_CD + "=:IMAGE_CD");
sb.AppendLine(" ," + MenuSubDTO.eColumns.MENU_SUB_NAME + "=:MENU_SUB_NAME");
sb.AppendLine(" ," + MenuSubDTO.eColumns.UPD_BY + "=:UPD_BY");
sb.AppendLine(" ," + MenuSubDTO.eColumns.UPD_DATE + "=GETDATE()");
sb.AppendLine(" ," + MenuSubDTO.eColumns.UPD_MACHINE + "=:UPD_MACHINE");
sb.AppendLine(" WHERE ");
sb.AppendLine(" " + MenuSubDTO.eColumns.MENU_SUB_CD + "=:oldMENU_SUB_CD");
#endregion
DataRequest req = new DataRequest(sb.ToString());
#region Parameters
req.Parameters.Add("MENU_SUB_CD", DataType.VarChar, data.MENU_SUB_CD.Value);
req.Parameters.Add("IMAGE_CD", DataType.VarChar, data.IMAGE_CD.Value);
req.Parameters.Add("MENU_SUB_NAME", DataType.VarChar, data.MENU_SUB_NAME.Value);
req.Parameters.Add("UPD_BY", DataType.NVarChar, data.UPD_BY.Value);
req.Parameters.Add("UPD_MACHINE", DataType.NVarChar, data.UPD_MACHINE.Value);
req.Parameters.Add("oldMENU_SUB_CD", DataType.VarChar, oldMENU_SUB_CD.Value);
#endregion
return(db.ExecuteNonQuery(req));
}
/// <summary>
/// Check exist before manipulate data. If found record will update data. Otherwise insert new data.
/// </summary>
/// <param name="database"></param>
/// <param name="data"></param>
/// <returns></returns>
public int AddNewOrUpdate(Database database, MenuSubDTO data)
{
Database db = UseDatabase(database);
if (Exist(database, data.MENU_SUB_CD))
{
return(UpdateWithoutPK(db, data));
}
return(AddNew(db, data));
}
/// <summary>
/// Save new menu sub.
/// </summary>
/// <param name="menuSubCD"></param>
/// <param name="menuSubName"></param>
/// <exception cref="EVOFramework.ValidateException"><c>ValidateException</c>.</exception>
/// <exception cref="EVOFramework.BusinessException"><c>BusinessException</c>.</exception>
public void SaveNewMenuSubDescription(NZString menuSubCD, NZString menuSubName)
{
MenuSubValidator validator = new MenuSubValidator();
validator.ValidateBeforeSaveAdd(menuSubCD, menuSubName);
Database database = CommonLib.Common.CurrentDatabase;
try {
database.KeepConnection = true;
database.BeginTransaction();
ILangDAO daoLang = DAOFactory.CreateLangDAO(database);
IMenuSubDAO daoMenuSub = DAOFactory.CreateMenuSubDAO(database);
IMenuSubLangDAO daoMenuSubLang = DAOFactory.CreateMenuSubLangDAO(database);
//== Add menu sub master.
MenuSubDTO dtoMenuSub = new MenuSubDTO();
dtoMenuSub.MENU_SUB_CD = menuSubCD;
dtoMenuSub.MENU_SUB_NAME = menuSubName;
dtoMenuSub.IMAGE_CD.Value = null;
dtoMenuSub.CRT_BY = CommonLib.Common.CurrentUserInfomation.UserCD;
dtoMenuSub.UPD_BY = CommonLib.Common.CurrentUserInfomation.UserCD;
dtoMenuSub.CRT_MACHINE = CommonLib.Common.CurrentUserInfomation.Machine;
dtoMenuSub.UPD_MACHINE = CommonLib.Common.CurrentUserInfomation.Machine;
daoMenuSub.AddNew(null, dtoMenuSub);
//== Add menu sub on each language.
List <LangDTO> langs = daoLang.LoadAll(null);
for (int i = 0; i < langs.Count; i++)
{
MenuSubLangDTO dtoMenuSubLang = new MenuSubLangDTO();
dtoMenuSubLang.MENU_SUB_CD = menuSubCD;
dtoMenuSubLang.LANG_CD = langs[i].LANG_CD;
dtoMenuSubLang.MENU_SUB_DESC = menuSubName;
dtoMenuSubLang.CRT_BY = CommonLib.Common.CurrentUserInfomation.UserCD;
dtoMenuSubLang.UPD_BY = CommonLib.Common.CurrentUserInfomation.UserCD;
dtoMenuSubLang.CRT_MACHINE = CommonLib.Common.CurrentUserInfomation.Machine;
dtoMenuSubLang.UPD_MACHINE = CommonLib.Common.CurrentUserInfomation.Machine;
daoMenuSubLang.AddNewOrUpdate(null, dtoMenuSubLang);
}
database.Commit();
} catch {
database.Rollback();
throw;
} finally {
if (database.DBConnectionState == ConnectionState.Open)
{
database.Close();
}
}
}
/// <summary>
/// Insert new record into database.
/// </summary>
/// <param name="database"></param>
/// <param name="data"></param>
/// <returns></returns>
public int AddNew(Database database, MenuSubDTO data)
{
Database db = UseDatabase(database);
StringBuilder sb = new StringBuilder();
#region SQL Statement
sb.AppendLine(" INSERT INTO " + data.TableName + "(");
sb.AppendLine(" " + MenuSubDTO.eColumns.MENU_SUB_CD);
sb.AppendLine(" ," + MenuSubDTO.eColumns.IMAGE_CD);
sb.AppendLine(" ," + MenuSubDTO.eColumns.MENU_SUB_NAME);
sb.AppendLine(" ," + MenuSubDTO.eColumns.CRT_BY);
sb.AppendLine(" ," + MenuSubDTO.eColumns.CRT_DATE);
sb.AppendLine(" ," + MenuSubDTO.eColumns.CRT_MACHINE);
sb.AppendLine(" ," + MenuSubDTO.eColumns.UPD_BY);
sb.AppendLine(" ," + MenuSubDTO.eColumns.UPD_DATE);
sb.AppendLine(" ," + MenuSubDTO.eColumns.UPD_MACHINE);
sb.AppendLine(") VALUES(");
sb.AppendLine(" :MENU_SUB_CD");
sb.AppendLine(" ,:IMAGE_CD");
sb.AppendLine(" ,:MENU_SUB_NAME");
sb.AppendLine(" ,:CRT_BY");
sb.AppendLine(" ,GETDATE()");
sb.AppendLine(" ,:CRT_MACHINE");
sb.AppendLine(" ,:UPD_BY");
sb.AppendLine(" ,GETDATE()");
sb.AppendLine(" ,:UPD_MACHINE");
sb.AppendLine(" )");
#endregion
DataRequest req = new DataRequest(sb.ToString());
#region Parameters
req.Parameters.Add("MENU_SUB_CD", DataType.VarChar, data.MENU_SUB_CD.Value);
req.Parameters.Add("IMAGE_CD", DataType.VarChar, data.IMAGE_CD.Value);
req.Parameters.Add("MENU_SUB_NAME", DataType.VarChar, data.MENU_SUB_NAME.Value);
req.Parameters.Add("CRT_BY", DataType.NVarChar, data.CRT_BY.Value);
req.Parameters.Add("CRT_MACHINE", DataType.NVarChar, data.CRT_MACHINE.Value);
req.Parameters.Add("UPD_BY", DataType.NVarChar, data.UPD_BY.Value);
req.Parameters.Add("UPD_MACHINE", DataType.NVarChar, data.UPD_MACHINE.Value);
#endregion
return(db.ExecuteNonQuery(req));
}
public void SaveEditMenuSub(NZString menuSubCD, NZString menuSubName)
{
Database database = CommonLib.Common.CurrentDatabase;
try
{
database.KeepConnection = true;
database.BeginTransaction();
IMenuSubDAO daoMenuSub = DAOFactory.CreateMenuSubDAO(database);
//== Update menu sub master.
MenuSubDTO dtoMenuSub = new MenuSubDTO();
dtoMenuSub.MENU_SUB_CD = menuSubCD;
dtoMenuSub.MENU_SUB_NAME = menuSubName;
dtoMenuSub.IMAGE_CD.Value = null;
dtoMenuSub.CRT_BY = CommonLib.Common.CurrentUserInfomation.UserCD;
dtoMenuSub.UPD_BY = CommonLib.Common.CurrentUserInfomation.UserCD;
dtoMenuSub.CRT_MACHINE = CommonLib.Common.CurrentUserInfomation.Machine;
dtoMenuSub.UPD_MACHINE = CommonLib.Common.CurrentUserInfomation.Machine;
daoMenuSub.UpdateWithoutPK(null, dtoMenuSub);
database.Commit();
}
catch
{
database.Rollback();
throw;
}
finally
{
if (database.DBConnectionState == ConnectionState.Open)
{
database.Close();
}
}
}
