protected void cmdCreateFolder_Click(object sender, EventArgs e)
{
try
{
FeedbackInfo info = new FeedbackInfo();
info.Sender_Name = info.Sender_Email = info.Sender_Address = info.Sender_Phone = info.Description = "";
info.Name = txtFolderName.Text.Trim();
info.Timeupdate = DateTime.Now;
info.Pis = 1;
if ((new CFeedback()).Save(info))
{
cmdCreateFolder.Visible = txtFolderName.Visible = false;
txtKeyword.Text = "";
this.Bind_grdView();
}
}
catch (Exception ex)
{
CCommon.CatchEx(ex);
}
}
private void setParameter(iSqlParameter[] parms, FeedbackInfo info)
{
try
{
int i = -1;
parms[++i].Value = CFunctions.SetDBString(info.Name);
parms[++i].Value = CFunctions.SetDBString(info.Description);
parms[++i].Value = CFunctions.SetDBString(info.Sender_Name);
parms[++i].Value = CFunctions.SetDBString(info.Sender_Address);
parms[++i].Value = CFunctions.SetDBString(info.Sender_Email);
parms[++i].Value = CFunctions.SetDBString(info.Sender_Phone);
parms[++i].Value = info.Status;
parms[++i].Value = info.Markas;
parms[++i].Value = CFunctions.SetDBDatetime(info.Timeupdate);
parms[++i].Value = info.Pis;
parms[++i].Value = info.Pid;
parms[++i].Value = info.Depth;
parms[++i].Value = info.Viewcounter;
parms[++i].Value = CFunctions.install_keyword(info.Sender_Name) + " " + CFunctions.install_keyword(info.Name) + " " + CFunctions.install_keyword(info.Description);
parms[++i].Value = info.Id;
return;
}
catch (Exception ex)
{
throw ex;
}
}
private bool Saveitem(iSqlTransaction trans, FeedbackInfo info)
{
try
{
if (trans == null || info == null) return false;
string SQL = string.Empty;
if (info.Id == 0)
{
SQL = SQL_INSERT;
info.Id = (int)HELPER.getNewID(trans, TABLENAME);
iSqlParameter[] parms = this.getParameter(SQL);
this.setParameter(parms, info);
HELPER.executeNonQuery(trans, iCommandType.Text, SQL, parms);
}
else if (HELPER.isExist(trans, TABLENAME, info.Id))
{
SQL = SQL_UPDATE;
iSqlParameter[] parms = this.getParameter(SQL);
this.setParameter(parms, info);
HELPER.executeNonQuery(trans, iCommandType.Text, SQL, parms);
}
else
{
SQL = SQL_INSERT;
info.Id = (int)HELPER.getNewID(trans, TABLENAME);
iSqlParameter[] parms = this.getParameter(SQL);
this.setParameter(parms, info);
HELPER.executeNonQuery(trans, iCommandType.Text, SQL, parms);
}
return true;
}
catch (Exception ex)
{
throw ex;
}
}
private FeedbackInfo getDataReader(iSqlDataReader dar)
{
try
{
int i = -1;
FeedbackInfo info = new FeedbackInfo();
info.Name = dar.IsDBNull(++i) ? string.Empty : dar.GetString(i);
info.Description = dar.IsDBNull(++i) ? string.Empty : dar.GetString(i);
info.Sender_Name = dar.IsDBNull(++i) ? string.Empty : dar.GetString(i);
info.Sender_Address = dar.IsDBNull(++i) ? string.Empty : dar.GetString(i);
info.Sender_Email = dar.IsDBNull(++i) ? string.Empty : dar.GetString(i);
info.Sender_Phone = dar.IsDBNull(++i) ? string.Empty : dar.GetString(i);
info.Status = dar.IsDBNull(++i) ? (int)CConstants.State.Status.Waitactive : dar.GetInt32(i);
info.Markas = dar.IsDBNull(++i) ? (int)CConstants.State.MarkAs.None : dar.GetInt32(i);
info.Timeupdate = dar.IsDBNull(++i) ? new DateTime(0) : dar.GetDateTime(i);
info.Pis = dar.IsDBNull(++i) ? 0 : dar.GetInt32(i);
info.Pid = dar.IsDBNull(++i) ? 0 : dar.GetInt32(i);
info.Depth = dar.IsDBNull(++i) ? 1 : dar.GetInt32(i);
info.Viewcounter = dar.IsDBNull(++i) ? 0 : dar.GetInt32(i);
info.Id = dar.IsDBNull(++i) ? 0 : dar.GetInt32(i);
info.Rownumber = dar.IsDBNull(++i) ? 0 : dar.GetInt64(i);
return info;
}
catch (Exception ex)
{
throw ex;
}
}
public bool Save(FeedbackInfo info)
{
try
{
using (iSqlConnection iConn = HELPER.getConnect(HELPER.SQL_SYSTEM))
{
using (iSqlTransaction trans = iConn.BeginTransaction())
{
try
{
this.Saveitem(trans, info);
trans.Commit();
}
catch (Exception ex)
{
trans.Rollback();
throw ex;
}
}
iConn.Close();
}
return true;
}
catch (Exception ex)
{
throw ex;
}
}
private FeedbackInfo Take()
{
try
{
FeedbackInfo info = new FeedbackInfo();
info.Sender_Name = txtSender_Nickname.Text.Trim();
info.Sender_Email = txtSender_Email.Text.Trim();
//info.Sender_Address = txtSender_Address.Text.Trim();
info.Sender_Phone = txtSender_Phone.Text.Trim();
info.Name = txtName.Text.Trim();
info.Description = txtDescription.Text.Trim();
info.Timeupdate = DateTime.Now;
return info;
}
catch
{
return null;
}
}
private void Move_Info(FeedbackInfo source_info, int dest_pid, int dest_depth, bool getchild, CFeedback BLL)
{
if (source_info == null) return;
int offset_depth = source_info.Depth - (dest_depth + 1);
FeedbackInfo info_copy = source_info.copy();
info_copy.Pid = dest_pid;
info_copy.Depth = dest_depth + 1;
info_copy.Status = CCommon.GetStatus_upt();
info_copy.Timeupdate = DateTime.Now;
if (BLL.Save(info_copy))
{
List<FeedbackInfo> listin = null;
List<FeedbackInfo> listsub = BLL.Getlist_sub(source_info.Id, listin);
if (listsub != null && listsub.Count > 0)
{
foreach (FeedbackInfo info_sub in listsub)
{
info_sub.Pid = getchild ? info_sub.Pid : (info_sub.Pid == source_info.Id ? source_info.Pid : info_sub.Pid);
info_sub.Depth = getchild ? info_sub.Depth + offset_depth : info_sub.Depth - 1;
info_sub.Status = CCommon.GetStatus_upt();
info_sub.Timeupdate = DateTime.Now;
BLL.Save(info_sub);
}
}
}
}
protected void Page_Load(object sender, EventArgs e)
{
PARENT = this.Get_Parent();
if (!Page.IsPostBack)
{
this.Init_State();
this.Bind_grdView();
}
}