protected void btnsave_Click(object sender, EventArgs e)
{
objfeedback = new clsFeedBack();
try
{
objfeedback.FBDate = Convert.ToDateTime(txtfbdate.Text);
objfeedback.FBTitle = txtfbtitle.Text;
objfeedback.Username = txtuname.Text;
objfeedback.ShortDescription = txtshortdes.Text;
objfeedback.InsertData(objfeedback);
/* if (Request.QueryString["action"] == "add")
* {
* objfeedback.InsertData(objfeedback);
* }
* else if (Request.QueryString["action"] == "edit")
* {
* objfeedback.UpdateData(objfeedback, txtcustcode.Text);
* }*/
}
catch (Exception ex)
{
}
}
protected void btn_submit_Click(object sender, EventArgs e)
{
if (txt_desc.Text.Trim() != "")
{
try
{
//
SqlParameter[] param = new SqlParameter[] {
new SqlParameter("@userid", (((UserDetails)Session[clsConstant.TOKEN]).UserID).ToString().ToUpper()),
new SqlParameter("@msg", txt_desc.Text)
//(((UserDetails)Session[clsConstant.TOKEN]).UserID).ToString())
};
clsFeedBack feed = new clsFeedBack();
feed.InserFeedBack(param);
SendMail();
Response.Write("<script>alert('Your feedback is submitted sucessfully')</script>");
MPE.Hide();
txt_desc.Text = "";
}
catch { MPE.Hide(); txt_desc.Text = ""; }
}
else
{
Response.Write("<script>alert('Please enter feedback message')</script>");
}
}
protected void Page_Load(object sender, EventArgs e)
{
objfeedback = new clsFeedBack();
sCOM = new Common();
if (!Page.IsPostBack)
{
sSQL = objfeedback.DispDataAll();
//To Fill Gridview
sCOM.setGridView(GridView1, sSQL);
}
}
public void UpdateData(clsFeedBack objfeedback, string fbcode)
{
cmd = new SqlCommand();
myDB = new DBHelper();
sSQL = "UPDATE FeedBack set FBDate=@FBDate,FBTitle=@FBTitle,ShortDescription=@ShortDescription,Username=@Username where FBCode=" + fbcode;
cmd.Parameters.AddWithValue("@FBDate", objfeedback.FBDate);
cmd.Parameters.AddWithValue("@FBTitle", objfeedback.FBTitle);
cmd.Parameters.AddWithValue("@ShortDescription", objfeedback.ShortDescription);
cmd.Parameters.AddWithValue("@Username", objfeedback.Username);
myDB.Execute(sSQL, cmd);
}
public void InsertData(clsFeedBack objfeedback)
{
cmd = new SqlCommand();
myDB = new DBHelper();
sSQL = "INSERT into FeedBack(FBDate,FBTitle,ShortDescription,Username)values (@FBDate,@FBTitle,@ShortDescription,@Username)";
cmd.Parameters.AddWithValue("@FBDate", objfeedback.FBDate);
cmd.Parameters.AddWithValue("@FBTitle", objfeedback.FBTitle);
cmd.Parameters.AddWithValue("@ShortDescription", objfeedback.ShortDescription);
cmd.Parameters.AddWithValue("@Username", objfeedback.Username);
myDB.Execute(sSQL, cmd);
}
public clsFeedBack GetData(string fbcode)
{
clsFeedBack objfeedback;
myDB = new DBHelper();
objfeedback = new clsFeedBack();
sSQL = objfeedback.DispDataCode(fbcode);
SqlDataReader sDr = myDB.GetFromReader(sSQL);
sDr.Read();
if (sDr.HasRows)
{
objfeedback.FBDate = Convert.ToDateTime(sDr["FBDate"].ToString());
objfeedback.FBTitle = sDr["FBTitle"].ToString();
objfeedback.ShortDescription = sDr["ShortDescription"].ToString();
objfeedback.Username = sDr["Username"].ToString();
}
return(objfeedback);
}
protected void Page_Load(object sender, EventArgs e)
{
objfeedback = new clsFeedBack();
sCOM = new Common();
uname = (String)Session["uname"];
if (uname != null)
{
txtuname.Text = uname;
}
else
{
txtuname.Text = "travelagent";
}
if (!Page.IsPostBack)
{
if (Request.QueryString["action"] == "add")
{
txtfbdate.Text = DateTime.Now.Date.ToString();
txtfbcode.Text = sCOM.setAutoID("FeedBack", "FBCode").ToString();
}
else if (Request.QueryString["action"] == "edit")
{
if (Request.QueryString["ec"] != null)
{
string ec = (Request.QueryString["ec"].ToString());
objfeedback = objfeedback.GetData(ec);
txtfbdate.Text = objfeedback.FBDate.ToString();
txtfbtitle.Text = objfeedback.FBTitle;
txtuname.Text = objfeedback.Username;
txtshortdes.Text = objfeedback.ShortDescription;
}
}
else
{
//Error Page
}
}
}
public List <clsFeedBack> GetFeedback(int projectId, string type)
{
try
{
string AppUrl = HttpContext.Request.Headers["appurl"];
string _SpUserId = HttpContext.Request.Headers["LoggedInUserSPUserId"];
string SchemaName = "";
if (!string.IsNullOrEmpty(AppUrl))
{
SchemaName = new clsUatClient(_context).GetClientSchema(AppUrl);
}
else
{
return(null);
}
string status = string.Empty;
string statementType = string.Empty;
List <clsFeedBack> listFB = new List <clsFeedBack>();
using (var cmd = _context.Database.GetDbConnection().CreateCommand())
{
cmd.CommandText = "UAT.spGetFeedBack";
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.Add(new SqlParameter("@ProjectId", SqlDbType.Int)
{
Value = projectId
});
cmd.Parameters.Add(new SqlParameter("@LoginSpUserId", SqlDbType.Int)
{
Value = _SpUserId
});
cmd.Parameters.Add(new SqlParameter("@SchemaName", SqlDbType.NVarChar, 500)
{
Value = SchemaName
});
cmd.Parameters.Add(new SqlParameter("@Ret_Parameter", SqlDbType.VarChar, 500)
{
Direction = ParameterDirection.Output
});
if (cmd.Connection.State != ConnectionState.Open)
{
cmd.Connection.Open();
}
var retObject = new List <dynamic>();
using (var dr = cmd.ExecuteReader())
{
int testpassId = dr.GetOrdinal("TestPass_Id");
int testpassName = dr.GetOrdinal("TestPass_Name");
int testcaseId = dr.GetOrdinal("TestCase_Id");
int testcaseName = dr.GetOrdinal("TestCase_Name");
int userId = dr.GetOrdinal("spUser_Id");
int testerName = dr.GetOrdinal("Tester_Name");
int Role_ID = dr.GetOrdinal("Role_ID");
int roleName = dr.GetOrdinal("Role_Name");
int Feedback_Type = dr.GetOrdinal("Feedback_Type");
int Feedback = dr.GetOrdinal("Feedback");
int Rating = dr.GetOrdinal("Rating");
int RatingFeedId = dr.GetOrdinal("RatingFeedId");
int TestStep_ID = dr.GetOrdinal("TestStep_ID");
int TestStep_ActionName = dr.GetOrdinal("TestStep_ActionName");
int Expected_Result = dr.GetOrdinal("Expected_Result");
int TestStepPlan_Id = dr.GetOrdinal("TestStepPlan_Id");
int Actual_Result = dr.GetOrdinal("Actual_Result");
int TesterStatusText = dr.GetOrdinal("TesterStatusText");
int TspFeedback = dr.GetOrdinal("TspFeedback");
int count = 0;
while (dr.Read())
{
List <clsTestFeedBack> lst = new List <clsTestFeedBack>();
lst.Add(new clsTestFeedBack()
{
testpassId = Convert.ToString(dr[testpassId]),
testcaseId = Convert.ToString(dr[testcaseId]),
Role_ID = Convert.ToString(dr[Role_ID]),
userId = Convert.ToString(dr[userId]),
testpassName = Convert.ToString(dr[testpassName]),
testcaseName = Convert.ToString(dr[testcaseName]),
testerName = Convert.ToString(dr[testerName]),
Role_Name = Convert.ToString(dr[roleName]),
Feedback_Type = Convert.ToString(dr[Feedback_Type]),
Feedback = Convert.ToString(dr[Feedback]),
Rating = Convert.ToString(dr[Rating]),
RatingFeedId = Convert.ToString(dr[RatingFeedId]),
TestStep_ID = Convert.ToString(dr[TestStep_ID]),
TestStep_ActionName = Convert.ToString(dr[TestStep_ActionName]),
Expected_Result = Convert.ToString(dr[Expected_Result]),
TestStepPlan_Id = Convert.ToString(dr[TestStepPlan_Id]),
Actual_Result = Convert.ToString(dr[Actual_Result]),
TesterStatusText = Convert.ToString(dr[TesterStatusText]),
TspFeedback = Convert.ToString(dr[TspFeedback]),
});
lst = lst.OrderBy(z => z.testpassId).OrderBy(z => z.testcaseId).OrderBy(z => z.Role_ID).OrderBy(z => z.userId).ToList();
clsFeedBack fbObject = null;
List <FeedbackUnique> lstUnique = new List <FeedbackUnique>();
List <FeedbackTesterDetail> listTesterDetail = null;
count++;
int tpid = Convert.ToInt32(dr["TestPass_ID"]);
int tcid = Convert.ToInt32(dr["TestCase_ID"]);
int rid = Convert.ToInt32(dr["Role_ID"]);
int uid = Convert.ToInt32(dr["spUser_Id"]);
if (lstUnique.Any(z => z.TPassId == tpid && z.TCaseId == tcid && z.RoleId == rid && z.spUserId == uid) == false)
{
lstUnique.Add(new FeedbackUnique()
{
TPassId = tpid,
TCaseId = tcid,
RoleId = rid,
spUserId = uid
});
fbObject = new clsFeedBack();
fbObject.testpassId = (dr.IsDBNull(testpassId)) == true ? "" : Convert.ToString(dr["TestPass_Id"]);
fbObject.testpassName = (dr.IsDBNull(testpassName)) == true ? "" : Convert.ToString(dr["TestPass_Name"]);
fbObject.testcaseId = (dr.IsDBNull(testcaseId)) == true ? "" : Convert.ToString(dr["TestCase_Id"]);
fbObject.testcaseName = (dr.IsDBNull(testcaseName)) == true ? "" : Convert.ToString(dr["TestCase_Name"]);
fbObject.userId = (dr.IsDBNull(userId)) == true ? "" : Convert.ToString(dr["spUser_Id"]);
fbObject.testerName = (dr.IsDBNull(testerName)) == true ? "" : Convert.ToString(dr["Tester_Name"]);
listTesterDetail = new List <FeedbackTesterDetail>();
if (type == "0")/*testpass*/
{
listTesterDetail.Add(new FeedbackTesterDetail()
{
roleId = (dr.IsDBNull(Role_ID)) == true ? "" : Convert.ToString(dr["Role_ID"]),
roleName = (dr.IsDBNull(roleName)) == true ? "" : Convert.ToString(dr["Role_Name"]),
fBType = (dr.IsDBNull(Feedback_Type)) == true ? "" : Convert.ToString(dr["Feedback_Type"]),
tpTcFeedback = (dr.IsDBNull(Feedback)) == true ? "" : Convert.ToString(dr["Feedback"]),
tpTcRating = (dr.IsDBNull(Rating)) == true ? "" : Convert.ToString(dr["Rating"]),
feedbackRatingId = (dr.IsDBNull(RatingFeedId)) == true ? "" : Convert.ToString(dr["RatingFeedId"])
});
}
else if (type == "1")/*teststep*/
{
listTesterDetail.Add(new FeedbackTesterDetail()
{
testStepId = (dr.IsDBNull(TestStep_ID)) == true ? "" : Convert.ToString(dr["TestStep_ID"]),
testStepName = (dr.IsDBNull(TestStep_ActionName)) == true ? "" : Convert.ToString(dr["TestStep_ActionName"]),
expectedResult = (dr.IsDBNull(Expected_Result)) == true ? "" : Convert.ToString(dr["Expected_Result"]),
testplanId = (dr.IsDBNull(TestStepPlan_Id)) == true ? "" : Convert.ToString(dr["TestStepPlan_Id"]),
actualResult = (dr.IsDBNull(Actual_Result)) == true ? "" : Convert.ToString(dr["Actual_Result"]),
roleId = (dr.IsDBNull(Role_ID)) == true ? "" : Convert.ToString(dr["Role_ID"]),
roleName = (dr.IsDBNull(roleName)) == true ? "" : Convert.ToString(dr["Role_Name"]),
status = (dr.IsDBNull(TesterStatusText)) == true ? "" : Convert.ToString(dr["TesterStatusText"]),
tsFeedback = (dr.IsDBNull(TspFeedback)) == true ? "" : Convert.ToString(dr["TspFeedback"])
});
}
if (lst.Count == count)
{
fbObject.listTesterDetail = listTesterDetail;
listFB.Add(fbObject);
}
else if ((Convert.ToInt32(dr["TestPass_ID"]) != tpid || Convert.ToInt32(dr["TestCase_ID"]) != tcid || Convert.ToInt32(dr["Role_ID"]) != rid || Convert.ToInt32(dr["spUser_Id"]) != uid))
{
fbObject.listTesterDetail = listTesterDetail;
listFB.Add(fbObject);
}
}
else
{
if (type == "0")
{
listTesterDetail.Add(new FeedbackTesterDetail()
{
roleId = (dr.IsDBNull(Role_ID)) == true ? "" : Convert.ToString(dr["Role_ID"]),
roleName = (dr.IsDBNull(roleName)) == true ? "" : Convert.ToString(dr["Role_Name"]),
fBType = (dr.IsDBNull(Feedback_Type)) == true ? "" : Convert.ToString(dr["Feedback_Type"]),
tpTcFeedback = (dr.IsDBNull(Feedback)) == true ? "" : Convert.ToString(dr["Feedback"]),
tpTcRating = (dr.IsDBNull(Rating)) == true ? "" : Convert.ToString(dr["Rating"]),
feedbackRatingId = (dr.IsDBNull(RatingFeedId)) == true ? "" : Convert.ToString(dr["RatingFeedId"])
});
}
else if (type == "1")
{
listTesterDetail.Add(new FeedbackTesterDetail()
{
testStepId = (dr.IsDBNull(TestStep_ID)) == true ? "" : Convert.ToString(dr["TestStep_ID"]),
testStepName = (dr.IsDBNull(TestStep_ActionName)) == true ? "" : Convert.ToString(dr["TestStep_ActionName"]),
expectedResult = (dr.IsDBNull(Expected_Result)) == true ? "" : Convert.ToString(dr["Expected_Result"]),
testplanId = (dr.IsDBNull(TestStepPlan_Id)) == true ? "" : Convert.ToString(dr["TestStepPlan_Id"]),
actualResult = (dr.IsDBNull(Actual_Result)) == true ? "" : Convert.ToString(dr["Actual_Result"]),
roleId = (dr.IsDBNull(Role_ID)) == true ? "" : Convert.ToString(dr["Role_ID"]),
roleName = (dr.IsDBNull(roleName)) == true ? "" : Convert.ToString(dr["Role_Name"]),
status = (dr.IsDBNull(TesterStatusText)) == true ? "" : Convert.ToString(dr["TesterStatusText"]),
tsFeedback = (dr.IsDBNull(TspFeedback)) == true ? "" : Convert.ToString(dr["TspFeedback"])
});
}
if (lst.Count == count)
{
fbObject.listTesterDetail = listTesterDetail;
listFB.Add(fbObject);
}
else if ((Convert.ToInt32(dr["TestPass_ID"]) != tpid || Convert.ToInt32(dr["TestCase_ID"]) != tcid || Convert.ToInt32(dr["Role_ID"]) != rid || Convert.ToInt32(dr["spUser_Id"]) != uid))
{
fbObject.listTesterDetail = listTesterDetail;
listFB.Add(fbObject);
}
}
}
}
return(listFB);
}
}
catch (Exception ex)
{
return(null);
}
}
public List <clsFeedBack> GetFeedback(int projectId, string type)
{
try
{
string AppUrl = HttpContext.Request.Headers["appurl"];
string _SpUserId = HttpContext.Request.Headers["LoggedInUserSPUserId"];
string SchemaName = "";
if (!string.IsNullOrEmpty(AppUrl))
{
SchemaName = new clsUatClient(_context).GetClientSchema(AppUrl);
}
else
{
return(null);
}
string status = string.Empty;
string statementType = string.Empty;
List <clsFeedBack> listFB = new List <clsFeedBack>();
using (var cmd = _context.Database.GetDbConnection().CreateCommand())
{
cmd.CommandText = "UAT.spGetFeedBack";
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.Add(new SqlParameter("@ProjectId", SqlDbType.Int)
{
Value = Convert.ToInt32(projectId)
});
cmd.Parameters.Add(new SqlParameter("@LoginSpUserId", SqlDbType.Int)
{
Value = Convert.ToInt32(_SpUserId)
});
cmd.Parameters.Add(new SqlParameter("@SchemaName", SqlDbType.NVarChar, 500)
{
Value = SchemaName
});
cmd.Parameters.Add(new SqlParameter("@Ret_Parameter", SqlDbType.VarChar, 500)
{
Direction = ParameterDirection.Output
});
if (cmd.Connection.State != ConnectionState.Open)
{
cmd.Connection.Open();
}
var retObject = new List <dynamic>();
using (var dr = cmd.ExecuteReader())
{
List <clsTestFeedBack> lst = new List <clsTestFeedBack>();
int count = 0;
int dr_Row = 0;
while (dr.Read())
{
lst.Add(new clsTestFeedBack()
{
testpassId = Convert.ToString(dr["TestPass_Id"]),
testcaseId = Convert.ToString(dr["TestCase_Id"]),
Role_ID = Convert.ToString(dr["Role_ID"]),
userId = Convert.ToString(dr["spUser_Id"]),
testpassName = Convert.ToString(dr["TestPass_Name"]),
testcaseName = Convert.ToString(dr["TestCase_Name"]),
testerName = Convert.ToString(dr["Tester_Name"]),
Role_Name = Convert.ToString(dr["Role_Name"]),
Feedback_Type = Convert.ToString(dr["Feedback_Type"]),
Feedback = Convert.ToString(dr["Feedback"]),
Rating = Convert.ToString(dr["Rating"]),
RatingFeedId = Convert.ToString(dr["RatingFeedId"]),
TestStep_ID = Convert.ToString(dr["TestStep_ID"]),
TestStep_ActionName = Convert.ToString(dr["TestStep_ActionName"]),
Expected_Result = Convert.ToString(dr["Expected_Result"]),
TestStepPlan_Id = Convert.ToString(dr["TestStepPlan_Id"]),
Actual_Result = Convert.ToString(dr["Actual_Result"]),
TesterStatusText = Convert.ToString(dr["TesterStatusText"]),
TspFeedback = Convert.ToString(dr["TspFeedback"]),
});
}
clsFeedBack fbObject = null;
List <FeedbackUnique> lstUnique = new List <FeedbackUnique>();
List <FeedbackTesterDetail> listTesterDetail = null;
if (lst.Count > 0)
{
dr_Row = lst.Count;
for (int i = 0; i < dr_Row; i++)
{
lst = lst.OrderBy(z => z.testpassId).OrderBy(z => z.testcaseId).OrderBy(z => z.Role_ID).OrderBy(z => z.userId).ToList();
count++;
int tpid = Convert.ToInt32(lst[i].testpassId);
int tcid = Convert.ToInt32(lst[i].testcaseId);
int rid = Convert.ToInt32(lst[i].Role_ID);
int uid = Convert.ToInt32(lst[i].userId);
if (lstUnique.Any(z => z.TPassId == tpid && z.TCaseId == tcid && z.RoleId == rid && z.spUserId == uid) == false)
{
lstUnique.Add(new FeedbackUnique()
{
TPassId = tpid,
TCaseId = tcid,
RoleId = rid,
spUserId = uid
});
fbObject = new clsFeedBack();
fbObject.testpassId = lst[i].testpassId;
fbObject.testpassName = lst[i].testpassName;
fbObject.testcaseId = lst[i].testcaseId;
fbObject.testcaseName = lst[i].testcaseName;
fbObject.userId = lst[i].userId;
fbObject.testerName = lst[i].testerName;
listTesterDetail = new List <FeedbackTesterDetail>();
if (type == "0")/*testpass*/
{
listTesterDetail.Add(new FeedbackTesterDetail()
{
roleId = lst[i].Role_ID,
roleName = lst[i].Role_Name,
fBType = lst[i].Feedback_Type,
tpTcFeedback = lst[i].Feedback,
tpTcRating = lst[i].Rating,
feedbackRatingId = lst[i].RatingFeedId
});
}
else if (type == "1")/*teststep*/
{
listTesterDetail.Add(new FeedbackTesterDetail()
{
testStepId = lst[i].TestStep_ID,
testStepName = lst[i].TestStep_ActionName,
expectedResult = lst[i].Expected_Result,
testplanId = lst[i].TestStepPlan_Id,
actualResult = lst[i].Actual_Result,
roleId = lst[i].Role_ID,
roleName = lst[i].Role_Name,
status = lst[i].TesterStatusText,
tsFeedback = lst[i].TspFeedback
});
}
if (dr_Row == count)
{
fbObject.listTesterDetail = listTesterDetail;
listFB.Add(fbObject);
}
else if (Convert.ToInt32(lst[count].testpassId) != tpid || Convert.ToInt32(lst[count].testcaseId) != tcid || Convert.ToInt32(lst[count].Role_ID) != rid || Convert.ToInt32(lst[count].userId) != uid)
{
fbObject.listTesterDetail = listTesterDetail;
listFB.Add(fbObject);
}
}
else
{
if (type == "0")
{
listTesterDetail.Add(new FeedbackTesterDetail()
{
roleId = lst[i].Role_ID,
roleName = lst[i].Role_Name,
fBType = lst[i].Feedback_Type,
tpTcFeedback = lst[i].Feedback,
tpTcRating = lst[i].Rating,
feedbackRatingId = lst[i].RatingFeedId
});
}
else if (type == "1")
{
listTesterDetail.Add(new FeedbackTesterDetail()
{
testStepId = lst[i].TestStep_ID,
testStepName = lst[i].TestStep_ActionName,
expectedResult = lst[i].Expected_Result,
testplanId = lst[i].TestStepPlan_Id,
actualResult = lst[i].Actual_Result,
roleId = lst[i].Role_ID,
roleName = lst[i].Role_Name,
status = lst[i].TesterStatusText,
tsFeedback = lst[i].TspFeedback
});
}
if (dr_Row == count)
{
fbObject.listTesterDetail = listTesterDetail;
listFB.Add(fbObject);
}
else if (Convert.ToInt32(lst[count].testpassId) != tpid || Convert.ToInt32(lst[count].testcaseId) != tcid || Convert.ToInt32(lst[count].Role_ID) != rid || Convert.ToInt32(lst[count].userId) != uid)
{
fbObject.listTesterDetail = listTesterDetail;
listFB.Add(fbObject);
}
}
}
}
return(listFB);
}
}
}
catch (Exception ex)
{
return(null);
}
}
