private void LoadData(string id)
{
NewsGroupController db = new NewsGroupController();
NewsGroupInfo group = db.Load(id);
txtDescription.Text = group.Description;
txtGroupCode.Text = group.NewsGroupCode;
txtGroupName.Text = group.NewsGroupName;
txtOrderNumber.Text = group.OrderNumber.ToString();
int res = -1;
int iIndex = group.NewsGroupID.IndexOf('_');
if (iIndex >= 0 && int.TryParse(group.NewsGroupID.Substring(0, iIndex), out res) && res == PortalId)
{
lblGroupID.Text = group.NewsGroupID.Substring(iIndex + 1);
}
else
{
lblGroupID.Text = group.NewsGroupID;
}
lblGroupID.Visible = true;
txtGroupID.Visible = false;
ddlDesktopListID.SelectedValue = group.DesktopListID.ToString();
ddlDesktopViewID.SelectedValue = group.DesktopViewID.ToString();
}
private void ImportNewsGroupInfo(NewsGroupInfo GroupInfo)
{
base.NewsGroupID = GroupInfo.NewsGroupID;
base.NewsGroupName = GroupInfo.NewsGroupName;
base.NewsGroupCode = GroupInfo.NewsGroupCode;
base.Description = GroupInfo.Description;
base.OrderNumber = GroupInfo.OrderNumber;
base.PortalID = GroupInfo.PortalID;
base.DesktopListID = GroupInfo.DesktopListID;
base.DesktopViewID = GroupInfo.DesktopViewID;
}
private static NewsGroupInfo FillNewsGroupInfo(IDataReader dr)
{
NewsGroupInfo objNewsGroupInfo = new NewsGroupInfo();
objNewsGroupInfo.NewsGroupID = Convert.ToString(Null.SetNull(dr["NewsGroupID"], objNewsGroupInfo.NewsGroupID));
objNewsGroupInfo.NewsGroupName = Convert.ToString(Null.SetNull(dr["NewsGroupName"], objNewsGroupInfo.NewsGroupName));
objNewsGroupInfo.NewsGroupCode = Convert.ToString(Null.SetNull(dr["NewsGroupCode"], objNewsGroupInfo.NewsGroupCode));
objNewsGroupInfo.Description = Convert.ToString(Null.SetNull(dr["Description"], objNewsGroupInfo.Description));
objNewsGroupInfo.OrderNumber = Convert.ToInt32(Null.SetNull(dr["OrderNumber"], objNewsGroupInfo.OrderNumber));
objNewsGroupInfo.PortalID = Convert.ToInt32(Null.SetNull(dr["PortalID"], objNewsGroupInfo.PortalID));
objNewsGroupInfo.DesktopListID = Convert.ToInt32(Null.SetNull(dr["DesktopListID"], objNewsGroupInfo.DesktopListID));
objNewsGroupInfo.DesktopViewID = Convert.ToInt32(Null.SetNull(dr["DesktopViewID"], objNewsGroupInfo.DesktopViewID));
return(objNewsGroupInfo);
}
public NewsGroupInfo Load(string NewsGroupID)
{
NewsGroupInfo result = null;
try
{
SqlParameter param = new SqlParameter("@NewsGroupID", NewsGroupID);
DataTable dt = DataProvider.SelectSP(LOAD_NEWS_NewsGroup, param);
if (dt.Rows.Count > 0)
{
result = Converting(dt.Rows[0]);
}
}
catch (Exception ex)
{
throw ex;
}
return(result);
}
protected void btnSave_Click(object sender, EventArgs e)
{
try
{
NewsGroupInfo group = new NewsGroupInfo();
if (Request.QueryString["id"] != null)
{
group.NewsGroupID = Request.QueryString["id"];
}
else
{
group.NewsGroupID = PortalId.ToString() + "_" + txtGroupID.Text;
}
group.Description = txtDescription.Text.Trim();
group.NewsGroupCode = txtGroupCode.Text.Trim();
group.NewsGroupName = txtGroupName.Text;
group.OrderNumber = Convert.ToInt32(txtOrderNumber.Text);
group.PortalID = PortalId;
group.DesktopListID = Convert.ToInt32(ddlDesktopListID.SelectedValue);
group.DesktopViewID = Convert.ToInt32(ddlDesktopViewID.SelectedValue);
if (group.NewsGroupID == "")
{
group.NewsGroupID = PortalId.ToString() + "_" + lblGroupID.Text;
}
NewsGroupController db = new NewsGroupController();
if (Request.QueryString["id"] != null)
{
db.Update(group);
}
else
{
db.Insert(group);
}
string url = DotNetNuke.Common.Globals.NavigateURL(PortalSettings.ActiveTab.TabID, "admin_group", "mid/" + this.ModuleId.ToString());
Response.Redirect(url);
}
catch (Exception ex)
{
Response.Write(ex.Message);
}
}
public NewsGroupInfo Converting(DataRow drNews_NewsGroup)
{
NewsGroupInfo result = null;
try
{
result = new NewsGroupInfo();
result.NewsGroupID = (string)drNews_NewsGroup["NewsGroupID"];
result.NewsGroupName = (string)drNews_NewsGroup["NewsGroupName"];
result.NewsGroupCode = (string)drNews_NewsGroup["NewsGroupCode"];
result.Description = (string)drNews_NewsGroup["Description"];
result.OrderNumber = (int)drNews_NewsGroup["OrderNumber"];
result.PortalID = (int)drNews_NewsGroup["PortalID"];
result.DesktopListID = (int)drNews_NewsGroup["DesktopListID"];
result.DesktopViewID = (int)drNews_NewsGroup["DesktopViewID"];
}
catch (Exception ex)
{
throw ex;
}
return(result);
}
public static MLNewsGroupInfo GetNewsGroup(string groupID, string Locale, bool FromCache)
{
StringInfo GroupName = effority.Ealo.Controller.GetStringByQualifierAndStringName(GroupQualifier, groupID, Locale, FromCache);
MLNewsGroupInfo fMLGroupInfo = null;
NewsGroupController groupCont = new NewsGroupController();
NewsGroupInfo groupInfo = groupCont.Load(groupID);
fMLGroupInfo = new MLNewsGroupInfo(groupInfo);
if (GroupName != null)
{
if (!String.IsNullOrEmpty(GroupName.StringText))
{
fMLGroupInfo.MLGroupName = GroupName;
}
}
//if (GroupName != null && String.IsNullOrEmpty(GroupName.StringText))
//{
// GroupName.StringText = groupInfo.NewsGroupName;
//}
//fMLGroupInfo.MLGroupName = GroupName;
return(fMLGroupInfo);
}
public int Update(NewsGroupInfo group)
{
int result = 0;
try
{
SqlParameter[] param = new SqlParameter[8];
param[0] = new SqlParameter("@NewsGroupID", group.NewsGroupID);
param[1] = new SqlParameter("@NewsGroupName", group.NewsGroupName);
param[2] = new SqlParameter("@Description", group.Description);
param[3] = new SqlParameter("@NewsGroupCode", group.NewsGroupCode);
param[4] = new SqlParameter("@OrderNumber", group.OrderNumber);
param[5] = new SqlParameter("@PortalID", group.PortalID);
param[6] = new SqlParameter("@DesktopListID", group.DesktopListID);
param[7] = new SqlParameter("@DesktopViewID", group.DesktopViewID);
result = DataProvider.ExecuteSP(UPDATE_NEWS_NewsGroup, param);
}
catch (Exception ex)
{
throw ex;
}
return(result);
}
private static Dictionary <string, NewsGroupInfo> FillNewsGroupInfoDictionary(IDataReader dr)
{
Dictionary <string, NewsGroupInfo> dic = new Dictionary <string, NewsGroupInfo>();
try
{
while (dr.Read())
{
NewsGroupInfo obj = FillNewsGroupInfo(dr);
dic.Add(obj.NewsGroupID, obj);
}
}
catch (Exception exc)
{
}
finally
{
if (dr != null)
{
dr.Close();
}
}
return(dic);
}
public MLNewsGroupInfo(NewsGroupInfo groupInfo)
{
this.ImportNewsGroupInfo(groupInfo);
}
