public bool SaveModule(ModuleDTO1 objModule)
{
Boolean isvalid = false;
try
{
TextInfo textInfo = new CultureInfo("en-US", false).TextInfo;
int count = Convert.ToInt32(NPGSqlHelper.ExecuteScalar(NPGSqlHelper.SQLConnString, CommandType.Text, "select count(*) from tabmodules where statusid=1 and parentmoduleid=" + objModule.parentModuleId + " and modulename='" + textInfo.ToTitleCase(objModule.Modulename.Trim().ToUpper()) + "';"));
if (count == 0)
{
string strSave = string.Empty;
int moduleorder = 0;
//strSave = "INSERT INTO tabmodules(modulename, moduledescription, statusid, createdby, createddate, parentmodulename,moduletype) VALUES ('" + objModule.Modulename.Trim().ToUpper() + "',null,1,1,current_timestamp,'" + objModule.Modulename.Trim().ToUpper() + "','" + objModule.ModuleType + "');";
moduleorder = Convert.ToInt16(NPGSqlHelper.ExecuteScalar(NPGSqlHelper.SQLConnString, CommandType.Text, "select count(*) from tabmodules where statusid=1 and parentmoduleid=" + objModule.parentModuleId + ";"));
if (moduleorder == 0)
{
moduleorder = 1;
}
else
{
moduleorder = moduleorder + 1;
}
strSave = "INSERT INTO tabmodules(modulename,modulelevelno,modulesortorder, moduledescription, statusid, createdby, createddate, parentmoduleid,parentmodulename,moduletype) VALUES ('" + textInfo.ToTitleCase(objModule.Modulename.Trim().ToUpper()) + "'," + moduleorder + "," + moduleorder + ",'" + objModule.Modulename + "',1,1,current_timestamp," + objModule.parentModuleId + ",'" + objModule.ParentModulename.Trim().ToUpper() + "','" + objModule.ModuleType + "');";
NPGSqlHelper.ExecuteNonQuery(NPGSqlHelper.SQLConnString, CommandType.Text, strSave);
isvalid = true;
}
}
catch (Exception ex)
{
EventLogger.WriteToErrorLog(ex, "UserRights");
}
return(isvalid);
}
private int check_Existed(ModuleDTO1 objModulename)
{
int Count = 0;
try
{
string check_exist = "select count(modulename) from tabmodules where statusid=1 and modulename= '" + objModulename.Modulename.Trim().ToUpper() + "'";
Count = Convert.ToInt32(NPGSqlHelper.ExecuteScalar(NPGSqlHelper.SQLConnString, CommandType.Text, check_exist));
}
catch (Exception ex)
{
EventLogger.WriteToErrorLog(ex, "UserRights");
}
return(Count);
}
//Saving Module in Add Module in UserRights
public bool ModuleSave(ModuleDTO1 Module)
{
return(objlogin.SaveModule(Module));
}
