public void SaveRatings()
{
try
{
bool indefect = false;
for (int i = 0; i < grdCatRating.Rows.Count; i++)
{
string SystemCode = ((HiddenField)grdCatRating.Rows[i].FindControl("hdnCatCode")).Value;
string SystemDescription = grdCatRating.Rows[i].Cells[2].Text;
string SysLastReport = grdCatRating.Rows[i].Cells[3].Text;
if (SysLastReport == " ")
{
SysLastReport = "";
}
string SysCurrentReport = grdCatRating.Rows[i].Cells[4].Text;
if (SysCurrentReport == " ")
{
SysCurrentReport = "";
}
string SysRating = "";
string ScheduleID = "";
string InspectionID = ViewState["InspectionID"].ToString();
string CreatedBy = "1";
string ActiveStatus = "1";
objInsp.InsertCategoryRating(SystemCode, SysLastReport, SysCurrentReport, SysRating, ScheduleID, InspectionID, CreatedBy, DateTime.Now, ActiveStatus);
}
for (int i = 0; i < grdSubCatRating.Rows.Count; i++)
{
string SystemCode = ViewState["CategoryCode"].ToString();
string SubSystemCode = ((HiddenField)grdSubCatRating.Rows[i].FindControl("hdnSubCatCode")).Value;
string SubSystemDescription = ((Label)grdSubCatRating.Rows[i].FindControl("lblSubCatDesc")).Text;
string SubSysSecLastReport = grdSubCatRating.Rows[i].Cells[3].Text;
if (SubSysSecLastReport == " ")
{
SubSysSecLastReport = "";
}
string SubSysLastReport = grdSubCatRating.Rows[i].Cells[4].Text;
if (SubSysLastReport == " ")
{
SubSysLastReport = "";
}
string SubSysCurrentReport = ((DropDownList)grdSubCatRating.Rows[i].FindControl("ddlRating")).SelectedItem.Text;
if (SubSysCurrentReport == "--SELECT--")
{
SubSysCurrentReport = "";
}
string SubSysRating = ((DropDownList)grdSubCatRating.Rows[i].FindControl("ddlRating")).SelectedValue.ToString().Split('_')[0];
string ScheduleID = "";
string AdditionalRemarks = txtAddRemarks.Text;
string InspectionID = ViewState["InspectionID"].ToString();
string Remarks = ((TextBox)grdSubCatRating.Rows[i].FindControl("txtRemarks")).Text;
string CreatedBy = "1";
string ActiveStatus = "1";
int inDefect = objInsp.INSP_Get_WorklistReportByLocationID(Convert.ToInt32(ViewState["InspectionID"].ToString()), Convert.ToInt32(SubSystemCode));
if (inDefect == 1)
{
int Rating = objInsp.INSP_Get_RatingsByRating("Fair");
if (SubSysCurrentReport != "")
{
if (Convert.ToInt32(SubSysCurrentReport) >= Rating)
{
string js1 = "alert('Item has defect can not be rated Fair and Above'); ";
ScriptManager.RegisterStartupScript(this, this.GetType(), "alert1", js1, true);
BindSubCategoryRating(ViewState["CategoryCode"].ToString(), ViewState["InspectionID"].ToString());
((TextBox)grdSubCatRating.Rows[i].FindControl("txtRemarks")).Text = Remarks;
((Label)grdSubCatRating.HeaderRow.Cells[0].FindControl("lblCatNo")).Text = hdnCurrentCatNo.Value; //((HiddenField)grdCatRating.Rows[rowindex].FindControl("hdnCatRNo")).Value;
((Label)grdSubCatRating.HeaderRow.Cells[1].FindControl("lblCatDesc")).Text = hdnCurrentCatDesc.Value; //((HiddenField)grdCatRating.Rows[rowindex].FindControl("hdnCatDesc")).Value;
((DropDownList)grdSubCatRating.Rows[i].FindControl("ddlRating")).Focus();
indefect = true;
}
else
{
objInsp.InsertSubCategoryRating(SystemCode, SubSystemCode, SubSysSecLastReport, SubSysLastReport, SubSysCurrentReport, SubSysRating, Remarks, AdditionalRemarks, ScheduleID, InspectionID, CreatedBy, DateTime.Now, ActiveStatus);
}
}
else
{
objInsp.InsertSubCategoryRating(SystemCode, SubSystemCode, SubSysSecLastReport, SubSysLastReport, SubSysCurrentReport, SubSysRating, Remarks, AdditionalRemarks, ScheduleID, InspectionID, CreatedBy, DateTime.Now, ActiveStatus);
}
}
else
{
objInsp.InsertSubCategoryRating(SystemCode, SubSystemCode, SubSysSecLastReport, SubSysLastReport, SubSysCurrentReport, SubSysRating, Remarks, AdditionalRemarks, ScheduleID, InspectionID, CreatedBy, DateTime.Now, ActiveStatus);
}
}
if (indefect == false)
{
//pnlAddRemark.Visible = false;
// grdSubCatRating.Visible = false;
BindCategoryRating(ViewState["InspectionID"].ToString(), ViewState["CheckListIDs"].ToString());
BindSubCategoryRating(ViewState["CategoryCode"].ToString(), ViewState["InspectionID"].ToString());
updCat.Update();
hdnDirtyCounter.Value = "0";
//string js2 = "alert('Rating Saved Successfully');";
//ScriptManager.RegisterStartupScript(this, this.GetType(), "alert9", js2, true);
}
int rowindex = UDFLib.ConvertToInteger(ViewState["SelectedRowIndex"].ToString());
grdCatRating.SelectRow(rowindex);
if (grdSubCatRating.Rows.Count > 0)
{
pnlAddRemark.Visible = true;
pnlSubcategory.Visible = true;
grdSubCatRating.Visible = true;
txtAddRemarks.Visible = true;
//grdSubCatRating.Style.Add("display", "inline");
((Label)grdSubCatRating.HeaderRow.Cells[0].FindControl("lblCatNo")).Text = ((HiddenField)grdCatRating.Rows[rowindex].FindControl("hdnCatRNo")).Value;
((Label)grdSubCatRating.HeaderRow.Cells[1].FindControl("lblCatDesc")).Text = ((HiddenField)grdCatRating.Rows[rowindex].FindControl("hdnCatDesc")).Value;
}
}
catch (Exception ex)
{
throw ex;
}
}