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)); }