private static void SetTaskPan(SqlCommand cm, TaskPan pan)
{
DatabaseHelper.InsertInt32Param("@TabId", cm, pan.TabId);
DatabaseHelper.InsertStringNVarCharParam("@Title", cm, pan.Title);
DatabaseHelper.InsertInt32Param("@Position", cm, pan.Position);
DatabaseHelper.InsertStringNVarCharParam("@ImagePath", cm, pan.ImagePath);
}
public TaskPan GetTaskPanById(int panid)
{
string sql = "SELECT [TabId], [TaskPanId], [Title], [Position], [ImagePath] FROM TaskPan where TaskPanId = @TaskPanId "
+ "SELECT [TaskPanId], [NodeId], [Id], [Position] FROM TaskPanNode where TaskPanId = @TaskPanId order by Position";
using (SqlConnection con = new SqlConnection(ConnectionString))
{
con.Open();
using (SqlCommand cm = new SqlCommand(sql, con))
{
DatabaseHelper.InsertInt32Param("@TaskPanId", cm, panid);
using (SqlDataReader dr = cm.ExecuteReader())
{
if (dr != null)
{
if (dr.HasRows)
{
dr.Read();
TaskPan pan = ReadPan(dr);
dr.NextResult();
ReadPanNodes(dr, pan);
return(pan);
}
}
}
}
}
return(null);
}
public void Delete(TaskPan pan, SqlTransaction sqltransaction)
{
string sql = "Delete TaskPan where TaskPanId = @PanId";
using (SqlCommand cm = new SqlCommand(sql, DefaultConnection, sqltransaction))
{
DatabaseHelper.InsertInt32Param("@PanId", cm, pan.Id);
cm.ExecuteNonQuery();
}
}
public void Update(TaskPan pan, SqlTransaction sqltransaction)
{
string sql = "UPDATE TaskPan SET [TabId] = @TabId, [Title] = @Title ,[Position] = @Position ,[ImagePath] = @ImagePath WHERE TaskPanId = @PanId";
using (SqlCommand cm = new SqlCommand(sql, DefaultConnection, sqltransaction))
{
DatabaseHelper.InsertInt32Param("@PanId", cm, pan.Id);
SetTaskPan(cm, pan);
cm.ExecuteNonQuery();
UpdateTaskPanNodes(pan, sqltransaction);
}
}
protected void rptPanel_ItemDataBound(object sender, RepeaterItemEventArgs e)
{
TaskPan pan = e.Item.DataItem as TaskPan;
if (pan != null)
{
Literal ltr = e.Item.FindControl("ltrTitle") as Literal;
ltr.Text = pan.Title;
PlaceHolder plh = e.Item.FindControl("plhNode") as PlaceHolder;
BuildNavigation(pan.TaskPanNodes.ToList(), plh);
}
}
private TaskPan ReadPan(SqlDataReader dr)
{
TaskPan pan = new TaskPan
{
Id = DatabaseHelper.GetInt32("TaskPanId", dr),
Title = DatabaseHelper.GetString("Title", dr),
Position = DatabaseHelper.GetInt32("Position", dr),
ImagePath = DatabaseHelper.GetString("ImagePath", dr),
TabId = DatabaseHelper.GetInt32("TabId", dr),
};
return(pan);
}
private void ReadPanNodes(SqlDataReader dr, TaskPan pan)
{
while (dr.Read())
{
TaskPanNode tp = new TaskPanNode
{
Id = DatabaseHelper.GetInt32("Id", dr),
TaskPanId = DatabaseHelper.GetInt32("TaskPanId", dr),
Position = DatabaseHelper.GetInt32("Position", dr)
};
tp.Node = _nodeDao.GetNodeById(DatabaseHelper.GetInt32("NodeId", dr));
pan.TaskPanNodes.Add(tp);
}
}
public void SaveOrUpdateTab()
{
TaskPan pan = CurrentTaskpan;
pan.Title = View.GetTitle;
pan.ImagePath = View.GetImagePath;
if (pan.Id <= 0)
{
int?pos = CurrentTab.TaskPans.Select <TaskPan, int?>(x => x.Position).Max();
pan.Position = pos.HasValue ? pos.Value + 1 : 1;
CurrentTab.TaskPans.Add(pan);
}
_controller.SaveOrUpdateEntity <Tab>(CurrentTab);
}
protected void grvNodes_RowDataBound(object sender, GridViewRowEventArgs e)
{
TaskPan pan = e.Row.DataItem as TaskPan;
if (pan != null)
{
HyperLink hpl = e.Row.FindControl("hplEdit") as HyperLink;
string url = String.Format("~/Admin/TaskPanEdit.aspx?{0}=0&{1}={2}&{3}={4}", AppConstants.TABID, AppConstants.NODEID, pan.Tab.Id, AppConstants.TASKPANID, pan.Id);
hpl.NavigateUrl = this.ResolveUrl(url);
ImageButton ibt = e.Row.FindControl("ibtUp") as ImageButton;
ibt.CommandArgument = pan.Id.ToString();
ibt = e.Row.FindControl("ibtDown") as ImageButton;
ibt.CommandArgument = pan.Id.ToString();
}
}
public void Save(TaskPan pan, SqlTransaction sqltransaction)
{
string sql = "INSERT INTO TaskPan([TabId], [Title], [Position], [ImagePath]) "
+ "VALUES(@TabId, @Title, @Position, @ImagePath) SELECT @@identity";
using (SqlCommand cm = new SqlCommand(sql, DefaultConnection, sqltransaction))
{
SetTaskPan(cm, pan);
pan.Id = int.Parse(cm.ExecuteScalar().ToString());
foreach (TaskPanNode np in pan.TaskPanNodes)
{
np.TaskPanId = pan.Id;
SaveTaskPanNode(np, sqltransaction);
}
}
}
public void BindTaskpan()
{
lblTabname.Text = _presenter.CurrentTab.TabName;
TaskPan pan = _presenter.CurrentTaskpan;
if (pan.Id > 0)
{
txtTitle.Text = pan.Title;
txtImage.Text = pan.ImagePath;
btnDelete.Enabled = true;
butAddaction.Enabled = true;
}
else
{
btnDelete.Enabled = false;
butAddaction.Enabled = false;
}
}
private void GetTaskPanNodes(TaskPan pan)
{
string sql = "SELECT [TaskPanId], [NodeId], [Id], [Position] FROM TaskPanNode where TaskPanId = @TaskPanId order by Position";
using (SqlConnection con = new SqlConnection(ConnectionString))
{
con.Open();
using (SqlCommand cm = new SqlCommand(sql, con))
{
DatabaseHelper.InsertInt32Param("@TaskPanId", cm, pan.Id);
using (SqlDataReader dr = cm.ExecuteReader())
{
if (dr != null)
{
ReadPanNodes(dr, pan);
}
}
}
}
}
private void UpdateTaskPanNodes(TaskPan pan, SqlTransaction sqltransaction)
{
string sql = "DELETE FROM TaskPanNode WHERE Id = @Id";
foreach (TaskPanNode np in pan.TaskPanNodes)
{
if (np.IsDirty && np.Id > 0)
{
using (SqlCommand cm = new SqlCommand(sql, DefaultConnection, sqltransaction))
{
DatabaseHelper.InsertInt32Param("@Id", cm, np.Id);
cm.ExecuteNonQuery();
}
}
else if (np.IsNew() && !np.IsDirty)
{
np.TaskPanId = pan.Id;
SaveTaskPanNode(np, sqltransaction);
}
}
}
