public int SaveMenuContentDeatails(MenuContentSchema objmenucontentschema)
{
try
{
using (SqlConnection objConn = SQLHelper.OpenConnection())
{
using (SqlTransaction objTran = objConn.BeginTransaction())
{
try
{
var param = new SqlParameter[]
{
new SqlParameter("@MenuID", objmenucontentschema.MenuID == 0 ? 0 : objmenucontentschema.MenuID),
new SqlParameter("@MenuContentID", objmenucontentschema.MenuContentID == 0 ? 0 : objmenucontentschema.MenuContentID),
new SqlParameter("@PageTitle", objmenucontentschema.PageTitle == null ? (object)DBNull.Value : objmenucontentschema.PageTitle),
new SqlParameter("@PageTitle_LL", objmenucontentschema.PageTitle_LL == null ? (object)DBNull.Value : objmenucontentschema.PageTitle_LL),
new SqlParameter("@PageTitle_UL", objmenucontentschema.PageTitle_UL == null ? (object)DBNull.Value : objmenucontentschema.PageTitle_UL),
new SqlParameter("@ShortDescription", objmenucontentschema.ShortDescription == null ? (object)DBNull.Value : objmenucontentschema.ShortDescription),
new SqlParameter("@ShortDescription_LL", objmenucontentschema.ShortDescription_LL == null ? (object)DBNull.Value : objmenucontentschema.ShortDescription_LL),
new SqlParameter("@ShortDescription_UL", objmenucontentschema.ShortDescription_UL == null ? (object)DBNull.Value : objmenucontentschema.ShortDescription_UL),
new SqlParameter("@LongDescription", objmenucontentschema.LongDescription == null ? (object)DBNull.Value : objmenucontentschema.LongDescription),
new SqlParameter("@LongDescription_LL", objmenucontentschema.LongDescription_LL == null ? (object)DBNull.Value : objmenucontentschema.LongDescription_LL),
new SqlParameter("@LongDescription_UL", objmenucontentschema.LongDescription_UL == null ? (object)DBNull.Value : objmenucontentschema.LongDescription_UL),
new SqlParameter("@SequenceNo", objmenucontentschema.SequenceNo == 0 ? 0 : objmenucontentschema.SequenceNo),
new SqlParameter("@IsApprove", objmenucontentschema.IsApprove == false ? Convert.ToBoolean(0) : objmenucontentschema.IsApprove),
new SqlParameter("@CreatedBy", objmenucontentschema.CreatedBy == null ? (object)DBNull.Value : objmenucontentschema.CreatedBy),
new SqlParameter("@UpdatedBy", objmenucontentschema.UpdatedBy == null ? (object)DBNull.Value : objmenucontentschema.UpdatedBy),
new SqlParameter("@IsActive", objmenucontentschema.IsActive == false ? Convert.ToBoolean(0) : objmenucontentschema.IsActive),
new SqlParameter("@ActionType", objmenucontentschema.ActionType == null ? (object)DBNull.Value : objmenucontentschema.ActionType)
};
int result = SQLHelper.ExecuteNonQuery(objConn, objTran, CommandType.StoredProcedure, "usp_Addupdatemenucontent", param);
if (result == 1)
{
objTran.Commit();
return(result);
}
else
{
objTran.Rollback();
return(0);
}
}
catch (Exception ex)
{
objTran.Rollback();
return(0);
}
}
}
}
catch (Exception ee)
{
return(0);
}
finally
{
}
}
public int DMLMenuContentList(MenuContentSchema objmenucontentschema)
{
try
{
using (SqlConnection objConn = SQLHelper.OpenConnection())
{
var param = new SqlParameter[]
{
new SqlParameter("@MenuContentID", objmenucontentschema.MenuContentID == 0 ? 0 : objmenucontentschema.MenuContentID)
};
int result = SQLHelper.ExecuteNonQuery(objConn, null, CommandType.StoredProcedure, "Usp_DMLMenuContentList", param);
if (result == 1)
{
return(result);
}
else
{
return(0);
}
}
}
catch (Exception ee)
{
return(0);
}
finally
{
}
}
public int DMLMenuContentList(MenuContentSchema objmenuContentSchema)
{
try
{
result = objmenucontentDAL.DMLMenuContentList(objmenuContentSchema);
return(result);
}
catch (Exception ex)
{
return(0);
}
}
public int SaveMenuContentDeatails(MenuContentSchema objmenuContentSchema)
{
try
{
result = objmenucontentDAL.SaveMenuContentDeatails(objmenuContentSchema);
return(result);
}
catch (Exception ex)
{
return(0);
}
}
public DataSet GetMenuContentList(MenuContentSchema objmenuContentSchema)
{
try
{
ds = objmenucontentDAL.GetMenuContentList(objmenuContentSchema);
return(ds);
}
catch (Exception e)
{
return(null);
}
finally
{
ds = null;
}
}
public DataSet GetMenuContentList(MenuContentSchema objmenucontentschema)
{
SqlConnection objConn = SQLHelper.OpenConnection();
try
{
SqlParameter[] param = new SqlParameter[1];
param[0] = new SqlParameter("@MenuID", SqlDbType.VarChar);
param[0].Value = objmenucontentschema.MenuID;
using (DataSet ds = SQLHelper.ExecuteDataset(objConn, null, CommandType.StoredProcedure, "Usp_GetMenuContentList", param))
{
return(ds);
}
}
catch (Exception ex)
{
return(null);
}
finally
{
SQLHelper.CloseConnection(objConn);
}
}
