public virtual CloudAccountDA.DoyinGoSupportTicketDataTable GetData()
{
this.Adapter.SelectCommand = this.CommandCollection[0];
CloudAccountDA.DoyinGoSupportTicketDataTable dataTable = new CloudAccountDA.DoyinGoSupportTicketDataTable();
this.Adapter.Fill(dataTable);
return(dataTable);
}
private void ViewRecord(string sId)
{
this.objDoyinGoSupportTicketDT = this.objDoyinGoSupportTicketBll.GetDataByDoyinGoSupportTicketID(int.Parse(sId));
if (this.objDoyinGoSupportTicketDT.Rows.Count <= 0)
{
return;
}
this.hfSupportTicketID.Value = this.objDoyinGoSupportTicketDT.Rows[0]["DoyinGoSupportTicketID"].ToString();
this.lblSupportDepartment.Text = this.objDoyinGoSupportTicketDT.Rows[0]["SupportDepartmentID"].ToString();
this.objSupportDepartmentMasterDT = this.objSupportDepartmentMasterBll.GetDataBySupportDepartmentID(int.Parse(this.lblSupportDepartment.Text));
this.lblSupportDepartment.Text = this.objSupportDepartmentMasterDT.Rows[0]["SupportDepartmentName"].ToString();
this.lblSupportDate1.Text = this.lblSupportDate.Text = this.objDoyinGoSupportTicketDT.Rows[0]["SupportDate"].ToString();
this.lblSupportDate1.Text = "Posted On: " + this.objDoyinGoSupportTicketDT.Rows[0]["SupportDate"];
this.lblSubject.Text = this.objDoyinGoSupportTicketDT.Rows[0]["Subject"].ToString();
this.lblMessage.Text = this.objDoyinGoSupportTicketDT.Rows[0]["Message"].ToString();
this.ddlPriority.SelectedValue = this.lblSupportPriority.Text = this.objDoyinGoSupportTicketDT.Rows[0]["SupportPriority"].ToString();
this.lblStatus.Text = this.objDoyinGoSupportTicketDT.Rows[0]["SupportStatus"].ToString();
this.btnClose.Visible = this.lblStatus.Text != "Closed";
this.btnOpen.Visible = this.lblStatus.Text == "Closed";
this.lblStatus.Text = this.SetStatus(this.lblStatus.Text);
this.dlDiscussion.DataBind();
this.objCompanyMasterDT = this.objCompanyMasterBll.GetDataByCompanyID(int.Parse(this.objDoyinGoSupportTicketDT.Rows[0]["CompanyID"].ToString()));
this.lblCompanyName.Text = this.objCompanyMasterDT.Rows[0]["CompanyName"].ToString();
this.lblCompanyPersonName.Text = this.objCompanyMasterDT.Rows[0]["CompanyContactPerson"].ToString();
}
private void SetRecord(string sId)
{
this.objDoyinGoSupportTicketDT = this.objDoyinGoSupportTicketBll.GetDataByDoyinGoSupportTicketID(int.Parse(sId));
if (this.objDoyinGoSupportTicketDT.Rows.Count <= 0)
{
return;
}
this.hfSupportTicketID.Value = this.objDoyinGoSupportTicketDT.Rows[0]["DoyinGoSupportTicketID"].ToString();
}
public virtual int Fill(CloudAccountDA.DoyinGoSupportTicketDataTable dataTable)
{
this.Adapter.SelectCommand = this.CommandCollection[0];
if (this.ClearBeforeFill)
{
dataTable.Clear();
}
return(this.Adapter.Fill(dataTable));
}
private void SetRecord(string sId)
{
this.objDoyinGoSupportTicketDT = this.objDoyinGoSupportTicketBll.GetDataByDoyinGoSupportTicketID(int.Parse(sId));
if (this.objDoyinGoSupportTicketDT.Rows.Count <= 0)
{
return;
}
this.hfSupportTicketID.Value = this.objDoyinGoSupportTicketDT.Rows[0]["DoyinGoSupportTicketID"].ToString();
this.ddlSupportDepartment.SelectedValue = this.objDoyinGoSupportTicketDT.Rows[0]["SupportDepartmentID"].ToString();
this.txtSubject.Text = this.objDoyinGoSupportTicketDT.Rows[0]["Subject"].ToString();
this.txtMessage.Text = this.objDoyinGoSupportTicketDT.Rows[0]["Message"].ToString();
this.ddlSupportPriority.SelectedValue = this.objDoyinGoSupportTicketDT.Rows[0]["SupportPriority"].ToString();
}
public virtual CloudAccountDA.DoyinGoSupportTicketDataTable DeleteByCompanyID(int?CompanyID)
{
this.Adapter.SelectCommand = this.CommandCollection[1];
if (CompanyID.HasValue)
{
this.Adapter.SelectCommand.Parameters[1].Value = CompanyID.Value;
}
else
{
this.Adapter.SelectCommand.Parameters[1].Value = DBNull.Value;
}
CloudAccountDA.DoyinGoSupportTicketDataTable dataTable = new CloudAccountDA.DoyinGoSupportTicketDataTable();
this.Adapter.Fill(dataTable);
return(dataTable);
}
public virtual CloudAccountDA.DoyinGoSupportTicketDataTable GetDataBySupportDepartmentID(int?SupportDepartmentID)
{
this.Adapter.SelectCommand = this.CommandCollection[4];
if (SupportDepartmentID.HasValue)
{
this.Adapter.SelectCommand.Parameters[1].Value = SupportDepartmentID.Value;
}
else
{
this.Adapter.SelectCommand.Parameters[1].Value = DBNull.Value;
}
CloudAccountDA.DoyinGoSupportTicketDataTable dataTable = new CloudAccountDA.DoyinGoSupportTicketDataTable();
this.Adapter.Fill(dataTable);
return(dataTable);
}
public virtual CloudAccountDA.DoyinGoSupportTicketDataTable UpdateSupportStatus(int?DoyinGoSupportTicketID, string SupportStatus)
{
this.Adapter.SelectCommand = this.CommandCollection[6];
if (DoyinGoSupportTicketID.HasValue)
{
this.Adapter.SelectCommand.Parameters[1].Value = DoyinGoSupportTicketID.Value;
}
else
{
this.Adapter.SelectCommand.Parameters[1].Value = DBNull.Value;
}
if (SupportStatus == null)
{
this.Adapter.SelectCommand.Parameters[2].Value = DBNull.Value;
}
else
{
this.Adapter.SelectCommand.Parameters[2].Value = SupportStatus;
}
CloudAccountDA.DoyinGoSupportTicketDataTable dataTable = new CloudAccountDA.DoyinGoSupportTicketDataTable();
this.Adapter.Fill(dataTable);
return(dataTable);
}
public virtual int Update(CloudAccountDA.DoyinGoSupportTicketDataTable dataTable)
{
return(this.Adapter.Update(dataTable));
}
