public JsonResult SubFeatureSaveUpdate(AdmMenusubEntity obj)
{
bool Success = false;
if (string.IsNullOrEmpty(obj.Isactive))
{
obj.Isactive = "Active";
}
if (string.IsNullOrEmpty(obj.Id))
{
obj.Createdby = Session["UserId"].ToString();
obj.Createdtime = DateTime.Now.ToString("dd/MM/yyyy HH:mm:ss");
obj.Id = (string)ExecuteDB(HCareTaks.AG_SaveAdmMenusubInfo, obj);
if (!string.IsNullOrEmpty(obj.Id))
{
Success = true;
}
}
else
{
obj.Updatedby = Session["UserId"].ToString();
obj.Updatedtime = DateTime.Now.ToString("dd/MM/yyyy HH:mm:ss");
Success = (bool)ExecuteDB(HCareTaks.AG_UpdateAdmMenusubInfo, obj);
}
string Message = Success ? "Process has been done successfully" : "Sorry something went wrong!";
return(Json(new { Success = Success, Message = Message, Id = obj.Menuid }));
}
public object SaveAdmMenusubInfo(AdmMenusubEntity admMenusubEntity, Database db, DbTransaction transaction)
{
string sql = "SELECT isnull(MAX(SortBy),0)+1 FROM Adm_MenuSub ";
DbCommand dbCommand = db.GetSqlStringCommand(sql);
if (string.IsNullOrEmpty(admMenusubEntity.Sortby))
{
admMenusubEntity.Sortby = db.ExecuteScalar(dbCommand, transaction).ToString();
}
sql = "INSERT INTO Adm_MenuSub ( MenuId, SortBy, SubIcon, SubName, SubUrl, IsActive, CreatedBy, CreatedTime ) output inserted.ID VALUES ( @Menuid, @Sortby, @Subicon, @Subname, @Suburl, @Isactive, @Createdby, @Createdtime )";
dbCommand = db.GetSqlStringCommand(sql);
db.AddInParameter(dbCommand, "Menuid", DbType.String, admMenusubEntity.Menuid);
db.AddInParameter(dbCommand, "Sortby", DbType.String, admMenusubEntity.Sortby);
db.AddInParameter(dbCommand, "Subicon", DbType.String, admMenusubEntity.Subicon);
db.AddInParameter(dbCommand, "Subname", DbType.String, admMenusubEntity.Subname);
db.AddInParameter(dbCommand, "Suburl", DbType.String, admMenusubEntity.Suburl);
db.AddInParameter(dbCommand, "Isactive", DbType.String, admMenusubEntity.Isactive);
db.AddInParameter(dbCommand, "Createdby", DbType.String, admMenusubEntity.Createdby);
db.AddInParameter(dbCommand, "Createdtime", DbType.String, admMenusubEntity.Createdtime);
var id = db.ExecuteScalar(dbCommand, transaction).ToString();
return(id);
}
public DataTable GetAllAdmMenusubRecord(object param)
{
Database db = DatabaseFactory.CreateDatabase();
string sql = @"SELECT D.ID, D.MenuId, D.SortBy, D.SubIcon, D.SubName, D.SubUrl, D.IsActive, D.CreatedBy, D.CreatedTime, D.UpdatedBy, D.UpdatedTime
, M.MenuName
FROM Adm_MenuSub D
Left Join Adm_Menu M ON M.ID = D.MenuId Where 1=1";
AdmMenusubEntity obj = new AdmMenusubEntity();
if (param != null)
{
obj = (AdmMenusubEntity)param;
}
if (!string.IsNullOrEmpty(obj.Menuid))
{
sql += " And D.MenuId = '" + obj.Menuid + "'";
}
if (!string.IsNullOrEmpty(obj.Isactive))
{
sql += " And D.IsActive = '" + obj.Isactive + "' And M.IsActive = '" + obj.Isactive + "'";
}
sql += " Order By M.SortBy Asc, D.SortBy Asc";
DbCommand dbCommand = db.GetSqlStringCommand(sql);
DataSet ds = db.ExecuteDataSet(dbCommand);
return(ds.Tables[0]);
}
public object UpdateAdmMenusubInfo(object param)
{
Database db = DatabaseFactory.CreateDatabase();
object retObj = null;
using (DbConnection connection = db.CreateConnection())
{
connection.Open();
DbTransaction transaction = connection.BeginTransaction();
try
{
AdmMenusubEntity admMenusubEntity = (AdmMenusubEntity)param;
AdmMenusubDAL admMenusubDAL = new AdmMenusubDAL();
retObj = (object)admMenusubDAL.UpdateAdmMenusubInfo(admMenusubEntity, db, transaction);
transaction.Commit();
}
catch
{
transaction.Rollback();
throw;
}
finally
{
connection.Close();
}
}
return(retObj);
}
public JsonResult SubFeatureDeleteById(string Id)
{
bool Success = false;
AdmMenusubEntity obj = (AdmMenusubEntity)ExecuteDB(HCareTaks.AG_GetSingleAdmMenusubRecordById, Id);
if (obj != null)
{
obj.Updatedby = Session["UserId"].ToString();
obj.Updatedtime = DateTime.Now.ToString("dd/MM/yyyy");
obj.Isactive = "Inactive";
Success = (bool)ExecuteDB(HCareTaks.AG_UpdateAdmMenusubInfo, obj);
}
string Message = Success ? "Delete Success" : "Sorry something went wrong!";
return(Json(new { Success = Success, Message = Message }));
}
string SubFeatureListTableData(string Id)
{
string TableData = "";
AdmMenusubEntity obj = new AdmMenusubEntity();
obj.Menuid = Id;
DataTable dt = (DataTable)ExecuteDB(HCareTaks.AG_GetAllAdmMenusubRecord, obj);
int Count = 1;
foreach (DataRow dr in dt.Rows)
{
string Action = "<i class='mdi mdi-table-edit iAction' title='Edit This' onclick=\"EditDetails('" + dr["Id"].ToString() + "')\" style='color:orange'></i>";
Action += "<i class='mdi mdi-close-box iAction' title='Inactive This' onclick=\"DeleteDetails('" + dr["Id"].ToString() + "', this)\" style='color:red'></i>";
TableData +=
"<tr>" +
"<td>" + dr["MenuName"] + "</td>" +
"<td>SF" + dr["ID"] + "</td>" +
"<td>" + dr["SortBy"] + "</td>" +
"<td>" + dr["SubIcon"] + "</td>" +
"<td>" + dr["SubName"] + "</td>" +
"<td>" + dr["SubUrl"] + "</td>" +
"<td class='IsActive'>" + dr["IsActive"] + "</td>" +
"<td>" + Action + "</td>" +
"</tr>";
Count += 1;
}
string CreateBtn = "<button class='btn btn-primary' type='button' onclick='CreateDetails()' style='margin-bottom:10px;'> New</button>";
string tHead =
"<tr>" +
"<th>Feature</th>" +
"<th>Code</th>" +
"<th>SortBy</th>" +
"<th>Icon</th>" +
"<th>Sub-Feature</th>" +
"<th>Url</ th>" +
"<th>IsActive</th>" +
"<th>Action</th>" +
"</tr>";
TableData = CreateBtn + "<div class='table-responsive'><table id='zero_config' class='table table-striped table-bordered'>" +
"<thead>" + tHead + "</thead><tbody>" + TableData + "</tbody></table></div>";
return(TableData);
}
public bool UpdateAdmMenusubInfo(AdmMenusubEntity admMenusubEntity, Database db, DbTransaction transaction)
{
string sql = "UPDATE Adm_MenuSub SET MenuId= @Menuid, SortBy= @Sortby, SubIcon= @Subicon, SubName= @Subname, SubUrl= @Suburl, IsActive= @Isactive, UpdatedBy= @Updatedby, UpdatedTime= @Updatedtime WHERE Id=@Id";
DbCommand dbCommand = db.GetSqlStringCommand(sql);
db.AddInParameter(dbCommand, "Id", DbType.String, admMenusubEntity.Id);
db.AddInParameter(dbCommand, "Menuid", DbType.String, admMenusubEntity.Menuid);
db.AddInParameter(dbCommand, "Sortby", DbType.String, admMenusubEntity.Sortby);
db.AddInParameter(dbCommand, "Subicon", DbType.String, admMenusubEntity.Subicon);
db.AddInParameter(dbCommand, "Subname", DbType.String, admMenusubEntity.Subname);
db.AddInParameter(dbCommand, "Suburl", DbType.String, admMenusubEntity.Suburl);
db.AddInParameter(dbCommand, "Isactive", DbType.String, admMenusubEntity.Isactive);
db.AddInParameter(dbCommand, "Updatedby", DbType.String, admMenusubEntity.Updatedby);
db.AddInParameter(dbCommand, "Updatedtime", DbType.String, admMenusubEntity.Updatedtime);
db.ExecuteNonQuery(dbCommand, transaction);
return(true);
}
public List <SiteInfo> SiteSubMenusList(string MenuId = "")
{
List <SiteInfo> Items = new List <SiteInfo>();
if (!string.IsNullOrEmpty(MenuId))
{
AdmMenusubEntity obj = new AdmMenusubEntity();
obj.Isactive = "Active";
obj.Menuid = MenuId;
DataTable dt = (DataTable)ExecuteDB(HCareTaks.AG_GetAllAdmMenusubRecord, obj);
foreach (DataRow dr in dt.Rows)
{
Items.Add(new SiteInfo {
MenuId = dr["ID"].ToString(), MenuIcon = dr["SubIcon"].ToString(), MenuName = dr["SubName"].ToString(), MenuUrl = dr["SubUrl"].ToString()
});
}
}
return(Items);
}
public ActionResult SubFeatureCreate(string Id)
{
string eMsg = SiteMainMenuList("SubFeature Details", "Settings", "FeatureList");
if (!string.IsNullOrEmpty(eMsg))
{
return(RedirectToOut(eMsg));
}
//else if (!SiteUserAccess("", "V")) return RedirectToOut();
ViewBag.MainFeatureList = List_MainFeature();
AdmMenusubEntity obj = new AdmMenusubEntity();
obj.Subicon = "mdi mdi-chart-bubble";
if (!string.IsNullOrEmpty(Id))
{
obj = (AdmMenusubEntity)ExecuteDB(HCareTaks.AG_GetSingleAdmMenusubRecordById, Id);
}
return(View(obj));
}
public AdmMenusubEntity GetSingleAdmMenusubRecordById(object param)
{
Database db = DatabaseFactory.CreateDatabase();
string sql = "SELECT ID, MenuId, SortBy, SubIcon, SubName, SubUrl, IsActive, CreatedBy, CreatedTime, UpdatedBy, UpdatedTime FROM Adm_MenuSub WHERE Id=@Id";
DbCommand dbCommand = db.GetSqlStringCommand(sql);
db.AddInParameter(dbCommand, "Id", DbType.String, param);
AdmMenusubEntity admMenusubEntity = null;
using (IDataReader dataReader = db.ExecuteReader(dbCommand))
{
if (dataReader.Read())
{
admMenusubEntity = new AdmMenusubEntity();
if (dataReader["ID"] != DBNull.Value)
{
admMenusubEntity.Id = dataReader["ID"].ToString();
}
if (dataReader["MenuId"] != DBNull.Value)
{
admMenusubEntity.Menuid = dataReader["MenuId"].ToString();
}
if (dataReader["SortBy"] != DBNull.Value)
{
admMenusubEntity.Sortby = dataReader["SortBy"].ToString();
}
if (dataReader["SubIcon"] != DBNull.Value)
{
admMenusubEntity.Subicon = dataReader["SubIcon"].ToString();
}
if (dataReader["SubName"] != DBNull.Value)
{
admMenusubEntity.Subname = dataReader["SubName"].ToString();
}
if (dataReader["SubUrl"] != DBNull.Value)
{
admMenusubEntity.Suburl = dataReader["SubUrl"].ToString();
}
if (dataReader["IsActive"] != DBNull.Value)
{
admMenusubEntity.Isactive = dataReader["IsActive"].ToString();
}
if (dataReader["CreatedBy"] != DBNull.Value)
{
admMenusubEntity.Createdby = dataReader["CreatedBy"].ToString();
}
if (dataReader["CreatedTime"] != DBNull.Value)
{
admMenusubEntity.Createdtime = dataReader["CreatedTime"].ToString();
}
if (dataReader["UpdatedBy"] != DBNull.Value)
{
admMenusubEntity.Updatedby = dataReader["UpdatedBy"].ToString();
}
if (dataReader["UpdatedTime"] != DBNull.Value)
{
admMenusubEntity.Updatedtime = dataReader["UpdatedTime"].ToString();
}
}
}
return(admMenusubEntity);
}
