protected void mydetailsview_ItemCommand(object sender, ListViewCommandEventArgs e)
{
if (e.CommandName == "Update")
{
Label _id = (Label)e.Item.FindControl("lbid");
TextBox _resp = (TextBox)e.Item.FindControl("responseTextBox");
BLL_Dml _objbll = new BLL_Dml();
_database _objdb = new _database();
_objdb.DBName = "DB_" + lblprjcode.Text;
_clsdocreview _objcls = new _clsdocreview();
_objcls.dr_id = 0;
_objcls.details = "";
_objcls.desc = "";
_objcls.response = _resp.Text;
_objcls.issued_date = DateTime.Now;
_objcls.uid = "";
_objcls.dr_itm_id = Convert.ToInt32(_id.Text);
_objcls.mode = 0;
_objbll.Document_Review_Details(_objcls, _objdb);
ScriptManager.RegisterStartupScript(this, typeof(string), "close", "window.close();", true);
}
else if (e.CommandName == "Cancel")
{
ScriptManager.RegisterStartupScript(this, typeof(string), "close", "window.close();", true);
}
else if (e.CommandName == "Select")
{
Label _id = (Label)e.Item.FindControl("lbid");
Session["id"] = _id.Text;
txtcomments.Text = String.Empty;
//ScriptManager.RegisterStartupScript(this, typeof(string), "close", "alert('"+ (string)Session["id"] + "');", true);
btnDummy_ModalPopupExtender.Show();
ScriptManager.RegisterStartupScript(this, typeof(string), "close", "CallAutoSize();", true);
}
}
private void Load_DocReview_Info()
{
BLL_Dml _objbll = new BLL_Dml();
_database _objdb = new _database();
_objdb.DBName = "DB_" + lblprj.Text;
_clsdocreview _objcls = new _clsdocreview();
_objcls.dr_id = Convert.ToInt32(lblid.Text);
DataTable _dt = _objbll.Load_Document_Review_INFO(_objcls, _objdb);
foreach (DataRow _drow in _dt.Rows)
{
lblpackage.Text = _drow["service"].ToString();
lblrecordby.Text = _drow["userid"].ToString();
lbldrno.Text = _drow["dr_no"].ToString();
lblsubmitted.Text = _drow["issued"].ToString();
lbldrno.Text = _drow["dr_no"].ToString();
lblsubject.Text = _drow["dr_reviewed"].ToString();
lblsrvid.Text = _drow["srv_id"].ToString();
lblissuedto.Text = _drow["issued_to"].ToString();
lblBuilding.Text = _drow["building"].ToString();
txtnote.Text = _drow["Note"].ToString();
}
}
protected void Insert_Doc_review_log()
{
BLL_Dml _objbll = new BLL_Dml();
_database _objdb = new _database();
_objdb.DBName = "DB_" + lblprj.Text;
_clsdocreview _objcls = new _clsdocreview();
_objcls.dr_reviewed = rtxtDocuments.Text;
_objcls.issued_date = DateTime.Now;
if (rcbIssued.SelectedItem == null)
{
_objcls.issued_to = "";
}
else
{
_objcls.issued_to = rcbIssued.SelectedItem.Text;
}
_objcls.dr_status = true;//open
_objcls.project_code = lblprj.Text;
_objcls.uid = (string)Session["uid"];
_objcls.mode = 1;
if (rcbPackage.SelectedItem == null)
{
_objcls.service = string.Empty;
}
else
{
_objcls.service = rcbPackage.SelectedItem.Text;
}
_objbll.Document_Review_Log(_objcls, _objdb);
load_doc_review_log(lblprj.Text);
Load_DocReview();
}
private void Load_SO_Pdf_Details()
{
BLL_Dml _objbll = new BLL_Dml();
_database _objdb = new _database();
_objdb.DBName = "DB_" + lblprj.Text;
_clsdocreview _objcls = new _clsdocreview();
_objcls.dr_id = Convert.ToInt32(Label2.Text);
DataTable _dt = _objbll.Load_dr_pdf_details(_objcls, _objdb);
txt_drno.Text = _dt.Rows[0]["Dr_No"].ToString();
txt_subject.Text = _dt.Rows[0]["Subject"].ToString();
txt_review.Text = _dt.Rows[0]["created_By"].ToString();
txt_issuedto.Text = _dt.Rows[0]["Issue_To"].ToString();
txt_issuedate.Text = _dt.Rows[0]["Issue_Date"].ToString();
txt_cmts.Text = _dt.Rows[0]["Comments"].ToString();
txt_resp.Text = _dt.Rows[0]["Response"].ToString();
lblfile.Text = _dt.Rows[0]["File_Name"].ToString();
lblfilename.Text = lblfile.Text;
dr_status.ClearSelection();
if (_dt.Rows[0]["Status"].ToString() == "True")
{
dr_status.Items.FindByText("OPEN").Selected = true;
}
else
{
dr_status.Items.FindByText("CLOSED").Selected = true;
}
}
private void Update_Document()
{
BLL_Dml _objbll = new BLL_Dml();
_database _objdb = new _database();
_objdb.DBName = "DB_" + (string)Session["project"];
_clsdocreview _objcls = new _clsdocreview();
_objcls.dr_id = Convert.ToInt32(Label2.Text);
_objcls.dr_no = txt_drno.Text;
_objcls.ddate = txt_issuedate.Text;
_objcls.issued_to = txt_issuedto.Text;
_objcls.service = drservice.SelectedItem.Text;
_objcls.dr_reviewed = txt_subject.Text;
_objcls.uid = txt_review.Text;
_objcls.details = lblfile.Text;
_objcls.desc = txt_cmts.Text;
_objcls.response = txt_resp.Text;
if (dr_status.SelectedValue == "1")
{
_objcls.dr_status = true;
}
else
{
_objcls.dr_status = false;
}
_objcls.mode = 2;
_objbll.dml_dr_pdf(_objcls, _objdb);
//ScriptManager.RegisterStartupScript(this, typeof(string), "close", "alert('DR Details Updated');", true);
btndummy_ModalPopupExtender.Hide();
}
protected void btnupdate_Click(object sender, EventArgs e)
{
//ScriptManager.RegisterStartupScript(this, typeof(string), "close", "alert('" + Label2.Text + "');", true);
BLL_Dml _objbll = new BLL_Dml();
_database _objdb = new _database();
_objdb.DBName = "DB_" + lblprj.Text;
_clsdocreview _objcls = new _clsdocreview();
_objcls.dr_reviewed = "";
_objcls.issued_date = DateTime.Now;
_objcls.issued_to = "";
_objcls.project_code = "";
_objcls.uid = "";
_objcls.mode = 0;
_objcls.dr_id = Convert.ToInt32(Label2.Text);
_objcls.service = "";
if (drstatus1.SelectedItem.Text == "OPEN")
{
_objcls.dr_status = true;
}
else
{
_objcls.dr_status = false;
}
_objcls.Notes = "";
string id = _objbll.Document_Review_Log(_objcls, _objdb);
load_doc_review_log(lblprj.Text);
Load_DocReview();
btnDummy_ModalPopupExtender1.Hide();
}
private void Load_DocReview_Info(int dr_id)
{
BLL_Dml _objbll = new BLL_Dml();
_database _objdb = new _database();
_objdb.DBName = "DB_" + lblprjcode.Text;
_clsdocreview _objcls = new _clsdocreview();
_objcls.dr_id = dr_id;
DataTable _dt = _objbll.Load_Document_Review_INFO(_objcls, _objdb);
foreach (DataRow _drow in _dt.Rows)
{
lbpkg.Text = _drow["service"].ToString();
lbcreated.Text = _drow["userid"].ToString();
lbno.Text = _drow["dr_no"].ToString();
lbissued.Text = _drow["issued"].ToString();
lbdoc.Text = _drow["dr_reviewed"].ToString();
lbldrno.Text = _drow["dr_no"].ToString();
lblnote.Text = _drow["Note"].ToString();
lbluid.Text = _drow["uid"].ToString();
lblissued.Text = _drow["issued_to"].ToString();
lblsrvid.Text = _drow["srv_id"].ToString();
}
}
protected void btnupdate_Click(object sender, EventArgs e)
{
////ScriptManager.RegisterStartupScript(this, typeof(string), "close", "alert('" + Label2.Text + "');", true);
BLL_Dml _objbll = new BLL_Dml();
_database _objdb = new _database();
_objdb.DBName = "DB_" + lblprj.Text;
_clsdocreview _objcls = new _clsdocreview();
_objcls.dr_reviewed = txt_subject.Text;
_objcls.issued_date = DateTime.Now;//Convert.ToDateTime(txt_issuedate.Text);
_objcls.issued_to = "";
_objcls.project_code = "";
_objcls.uid = "";
_objcls.mode = 0;
_objcls.dr_id = Convert.ToInt32(Label2.Text);
_objcls.service = rcbService_Edit.SelectedItem.Text;
_objcls.Notes = "";
if (sostatus1.SelectedItem.Text == "OPEN")
{
_objcls.dr_status = true;
_objcls.closeout_date = "";
}
else
{
_objcls.dr_status = false;
if (lblNewProject.Text == "1")
{
if (RadDatePicker_CloseDate.SelectedDate.ToString() == string.Empty)
{
RadDatePicker_CloseDate.SelectedDate = DateTime.Now;
}
_objcls.closeout_date = Convert.ToDateTime(RadDatePicker_CloseDate.SelectedDate).ToShortDateString();
_objcls.closeout_date = DateTime.Parse(_objcls.closeout_date.ToString()).ToString("dd/MM/yyyy");
}
else
{
_objcls.closeout_date = string.Empty;
}
}
if (lblNewProject.Text == "1")
{
_objcls.building = (rcbBuilding_Edit.SelectedValue != string.Empty) ? Convert.ToInt32(rcbBuilding_Edit.SelectedValue) : _objcls.building;
}
string id = _objbll.Document_Review_Log(_objcls, _objdb);
load_doc_review_log(lblprj.Text);
//Load_DocReview();
Filtering((string)Session["ser"], (string)Session["rew"], (string)Session["iss"], (string)Session["sta"], (string)Session["bui"]);
string script = "function f(){$find(\"" + RadWindow1.ClientID + "\").close(); Sys.Application.remove_load(f);}Sys.Application.add_load(f);";
ScriptManager.RegisterStartupScript(this, this.GetType(), "key", script, true);
}
protected void myview_ItemCommand(object sender, ListViewCommandEventArgs e)
{
if (e.CommandName == "select")
{
Button _btn = (Button)e.Item.FindControl("btndr_no");
Label _lbl = (Label)e.Item.FindControl("dr_idLabel");
Label _lblcr = (Label)e.Item.FindControl("uidLabel");
Label _lblis = (Label)e.Item.FindControl("issued_toLabel");
Label _lblsrv = (Label)e.Item.FindControl("lbsrv");
Label _lbldoc = (Label)e.Item.FindControl("dr_reviewedLabel");
//ScriptManager.RegisterStartupScript(this, typeof(string), "close", "alert('"+ _btn.Text +"');", true);
//Session["dr_id"] = _lbl.Text;
//Session["dr_no"] = _btn.Text;
Session["created"] = _lblcr.Text;
//Session["issued"] = _lblis.Text;
//Session["service"] = _lblsrv.Text;
//Session["doc"] = _lbldoc.Text;
_Create_Cookies();
string _prm = "";
if (lblprj.Text == "HPOB")
{
_prm = "cmsdocreview_details1.aspx?id=" + _lbl.Text + "_P" + lblprj.Text;
}
else
{
//_prm = "cmsdocreview_details.aspx?id=" + _lbl.Text + "_P" + lblprj.Text;
_prm = "cmsdocreview_details.aspx?id=" + _lbl.Text + "&PRJ=" + lblprj.Text + "&SER=" + dr_service.Text + "&RVW=" + drreview.Text + "&ISS=" + drissue.Text + "&STA=" + drstatus.Text + "&ACN=1&BUI=" + drbuilding.SelectedItem.Text;
}
//ScriptManager.RegisterStartupScript(this, typeof(string), "Message", "window.open(''" + _prm + "' ,'','left=50,top=50,width=1300,height=600,menubar=1,toolbar=1,scrollbars=1,status=0,resizable=1');", true);
Response.Redirect(_prm);
}
else if (e.CommandName == "Update")
{
Label _id = (Label)e.Item.FindControl("dr_idLabel");
DropDownList _drs = (DropDownList)e.Item.FindControl("drstatus");
BLL_Dml _objbll = new BLL_Dml();
_database _objdb = new _database();
_objdb.DBName = "DB_" + lblprj.Text;
_clsdocreview _objcls = new _clsdocreview();
_objcls.dr_reviewed = "";
_objcls.issued_date = DateTime.Now;
_objcls.issued_to = "";
_objcls.project_code = "";
_objcls.uid = "";
_objcls.mode = 0;
_objcls.dr_id = Convert.ToInt32(_id.Text);
_objcls.service = "";
if (_drs.SelectedItem.Text == "OPEN")
{
_objcls.dr_status = true;
}
else
{
_objcls.dr_status = false;
}
_objbll.Document_Review_Log(_objcls, _objdb);
}
}
protected void mydetails_ItemDataBound(object sender, ListViewItemEventArgs e)
{
Label _id = (Label)e.Item.FindControl("so_itm_idLabel");
BLL_Dml _objbll = new BLL_Dml();
_database _objdb = new _database();
_objdb.DBName = "DB_" + (string)Session["project"];
_clsdocreview _objcls = new _clsdocreview();
_objcls.dr_id = Convert.ToInt32(_id.Text);
GridView _myphoto = (GridView)e.Item.FindControl("myphoto");
_myphoto.DataSource = _objbll.Load_DR_Photo_Temp(_objcls, _objdb);
_myphoto.DataBind();
int ent1 = 0;
int count = 1;
TextBox txt = (TextBox)e.Item.FindControl("detailsLabel");
foreach (Char chr in txt.Text)
{
if (chr.ToString() == "\n")
{
ent1 += 1;
}
}
if (txt.Text.Length >= 80)
{
count = (txt.Text.Length / 80);
}
count += ent1;
//txt.Height = Unit.Pixel(count * 30);
//txt1.Height = Unit.Pixel(count1 * 30);
txt.Rows = count + 1;
int ent2 = 0;
int count1 = 1;
TextBox txt1 = (TextBox)e.Item.FindControl("descrlabel");
foreach (Char chr in txt1.Text)
{
if (chr.ToString() == "\n")
{
ent2 += 1;
}
}
if (txt1.Text.Length >= 80)
{
count1 = (txt1.Text.Length / 80);
}
count1 += ent2;
//txt.Height = Unit.Pixel(count * 30);
//txt1.Height = Unit.Pixel(count1 * 30);
txt1.Rows = count1 + 1;
}
private void Remove_DrTemp(int id)
{
BLL_Dml _objbll = new BLL_Dml();
_database _objdb = new _database();
_objdb.DBName = "DB_" + lblprj.Text;
_clsdocreview _objcls = new _clsdocreview();
_objcls.dr_id = id;
_objbll.Remove_DRTemp(_objcls, _objdb);
}
private void Update_DrIssue()
{
BLL_Dml _objbll = new BLL_Dml();
_database _objdb = new _database();
_clsdocreview _objcls = new _clsdocreview();
_objdb.DBName = "DB_" + lblprjcode.Text;
_objcls.dr_id = Convert.ToInt32(lblid.Text);
_objcls.issued_to = drissuedto.SelectedItem.Text;
_objcls.issued_date = DateTime.Now;
_objbll.Update_DrIssueTo(_objcls, _objdb);
}
private void Delete_DrTemp()
{
BLL_Dml _objbll = new BLL_Dml();
_database _objdb = new _database();
_objdb.DBName = "DB_" + lblprj.Text;
_clsdocreview _objcls = new _clsdocreview();
_objcls.uid = lblrecordby.Text;
_objcls.dr_reviewed = lblsubject.Text;
_objcls.service = lblpackage.Text;
_objbll.Delete_DRTemp(_objcls, _objdb);
}
private void Load_DRTemp()
{
BLL_Dml _objbll = new BLL_Dml();
_database _objdb = new _database();
_objdb.DBName = "DB_" + lblprj.Text;
_clsdocreview _objcls = new _clsdocreview();
_objcls.uid = lblrecordby.Text;
_objcls.dr_reviewed = lblsubject.Text;
_objcls.service = lblpackage.Text;
myschedule_basket.DataSource = _objbll.Load_DRTemp(_objcls, _objdb);
myschedule_basket.DataBind();
}
protected void btnsave_Click(object sender, EventArgs e)
{
BLL_Dml _objbll = new BLL_Dml();
_database _objdb = new _database();
_objdb.DBName = "DB_" + lblprjcode.Text;
_clsdocreview _objcls = new _clsdocreview();
_objcls.dr_itm_id = Convert.ToInt32((string)Session["id"]);
_objcls.response = txtcomments.Text;
_objbll.dr_cml_comment(_objcls, _objdb);
load_doc_review_details(Convert.ToInt32(lblid.Text));
btnDummy_ModalPopupExtender.Hide();
}
private void Update_DR_Details()
{
BLL_Dml _objbll = new BLL_Dml();
_database _objdb = new _database();
_objdb.DBName = "DB_" + lblprj.Text;
_clsdocreview _objcls = new _clsdocreview();
_objcls.dr_no = lbldrno.Text;
_objcls.service = lblpackage.Text;
_objcls.details = lblsubject.Text;
_objcls.uid = lblrecordby.Text;
_objbll.Update_DR_Details(_objcls, _objdb);
}
protected void mydetails_ItemCommand(object sender, ListViewCommandEventArgs e)
{
if (e.CommandName == "Delete")
{
Label _id = (Label)e.Item.FindControl("so_itm_idLabel");
BLL_Dml _objbll = new BLL_Dml();
_database _objdb = new _database();
_objdb.DBName = "DB_" + (string)Session["project"];
_clsdocreview _objcls = new _clsdocreview();
_objcls.dr_id = Convert.ToInt32(_id.Text);
_objbll.Remove_DR_Details_Basket(_objcls, _objdb);
Load_DRTemp();
}
}
protected void btnsave_Click(object sender, EventArgs e)
{
BLL_Dml _objbll = new BLL_Dml();
_database _objdb = new _database();
_objdb.DBName = "DB_" + lblprjcode.Text;
_clsdocreview _objcls = new _clsdocreview();
_objcls.dr_itm_id = Convert.ToInt32((string)Session["id"]);
_objcls.response = txtcomments.Text;
_objbll.dr_cml_comment(_objcls, _objdb);
load_doc_review_details(Convert.ToInt32(lblid.Text));
btnDummy_ModalPopupExtender.Hide();
ScriptManager.RegisterStartupScript(this, typeof(string), "close", "CallAutoSize();", true);
}
private void Delete_Dr()
{
BLL_Dml _objbll = new BLL_Dml();
_database _objdb = new _database();
_clsdocreview _objcls = new _clsdocreview();
_objdb.DBName = "DB_" + lblprjcode.Text;
_objcls.dr_id = Convert.ToInt32(lblid.Text);
_objcls.dr_itm_id = 0;
_objcls.reviewed_by = "";
_objcls.details = "";
_objcls.descr = "";
_objcls.mode = 2;
_objbll.Edit_DR(_objcls, _objdb);
}
private void Add_ToTemp()
{
BLL_Dml _objbll = new BLL_Dml();
_database _objdb = new _database();
_objdb.DBName = "DB_" + lblprj.Text;
_clsdocreview _objcls = new _clsdocreview();
_objcls.details = txtdetails.Text;
_objcls.descr = txtdesc.Text;
_objcls.uid = lblrecordby.Text;
_objcls.dr_reviewed = lblsubject.Text;
_objcls.service = lblpackage.Text;
_objbll.Insert_DRTemp(_objcls, _objdb);
add_Photo();
}
private void Load_Dr_Items()
{
BLL_Dml _objbll = new BLL_Dml();
_database _objdb = new _database();
_clsdocreview _objcls = new _clsdocreview();
_objdb.DBName = "DB_" + lblprjcode.Text;
_objcls.dr_id = Convert.ToInt32(lbldrdid.Text);
DataTable _dt = _objbll.Load_Document_Review_Items(_objcls, _objdb);
foreach (DataRow _drow in _dt.Rows)
{
txt_details.Text = _drow["details"].ToString();
txt_descr.Text = _drow["description"].ToString();
}
}
//protected void btnaddtr_Click(object sender, EventArgs e)
//{
// Insert_Doc_review_details();
//}
protected void Insert_Doc_review_details()
{
BLL_Dml _objbll = new BLL_Dml();
_database _objdb = new _database();
_objdb.DBName = "DB_" + lblprjcode.Text;
_clsdocreview _objcls = new _clsdocreview();
_objcls.dr_id = Convert.ToInt32((string)Session["dr_id1"]);
//_objcls.details = txtdetails.Text;
_objcls.response = "";
_objcls.issued_date = DateTime.Now;
_objcls.uid = (string)Session["uid"];
_objcls.dr_itm_id = 0;
_objcls.mode = 1;
_objbll.Document_Review_Details(_objcls, _objdb);
// load_doc_review_details();
}
protected void load_doc_review_details(int dr_id)
{
//ScriptManager.RegisterStartupScript(this, typeof(string), "close", "alert('"+ (string)Session["dr_id"] +"');", true);
//Session["dr_id1"] = (string)Session["dr_id"];
//Session["dr_no1"]=(string)Session["dr_no"];
BLL_Dml _objbll = new BLL_Dml();
_database _objdb = new _database();
_objdb.DBName = "DB_" + lblprjcode.Text;
_clsdocreview _objcls = new _clsdocreview();
_objcls.dr_id = dr_id;
//mygrid1.DataSource = _objbll.Load_Document_Review_Details(_objcls);
//mygrid1.DataBind();
//mydetailsview.DataSource = _objbll.Load_Document_Review_Details(_objcls,_objdb);
//mydetailsview.DataBind();
mygrid_details.DataSource = _objbll.Load_Document_Review_Details(_objcls, _objdb);
mygrid_details.DataBind();
}
private void Add_ToTemp()
{
BLL_Dml _objbll = new BLL_Dml();
_database _objdb = new _database();
_objdb.DBName = "DB_" + lblprj.Text;
_clsdocreview _objcls = new _clsdocreview();
_objcls.details = txtdetails.Text;
_objcls.descr = txtdesc.Text;
_objcls.uid = lblrecordby.Text;
_objcls.dr_reviewed = lblsubject.Text;
_objcls.service = lblpackage.Text;
if (trBuilding.Visible)
{
_objcls.building = Convert.ToInt32(Session["buildingid"]);
}
_objbll.Insert_DRTemp(_objcls, _objdb);
}
protected void Insert_Doc_review_log()
{
BLL_Dml _objbll = new BLL_Dml();
_database _objdb = new _database();
_objdb.DBName = "DB_" + lblprj.Text;
_clsdocreview _objcls = new _clsdocreview();
_objcls.dr_reviewed = lblsubject.Text;
_objcls.issued_date = DateTime.Now;
_objcls.issued_to = lblissuedto.Text;
_objcls.dr_status = true;//open
_objcls.project_code = lblprj.Text;
_objcls.uid = lblrecordby.Text;
_objcls.mode = 1;
_objcls.service = lblpackage.Text;
_objcls.Notes = txtnote.Text;
lbldrno.Text = _objbll.Document_Review_Log(_objcls, _objdb);
Update_DR_Details();
}
protected void btnupdate_Click(object sender, EventArgs e)
{
BLL_Dml _objbll = new BLL_Dml();
_database _objdb = new _database();
_objdb.DBName = "DB_" + lblprjcode.Text;
_clsdocreview _objcls = new _clsdocreview();
_objcls.dr_id = 0;
_objcls.details = "";
_objcls.desc = "";
_objcls.response = txtresp.Text;
_objcls.issued_date = DateTime.Now;
_objcls.uid = "";
_objcls.dr_itm_id = Convert.ToInt32((string)Session["id"]);
_objcls.mode = 0;
_objbll.Document_Review_Details(_objcls, _objdb);
load_doc_review_details(Convert.ToInt32(lblid.Text));
Send_Mail();
btnDummy_ModalPopupExtender1.Hide();
}
void Update_DRNotes()
{
BLL_Dml _objbll = new BLL_Dml();
_database _objdb = new _database();
_objdb.DBName = "DB_" + lblprj.Text;
_clsdocreview _objcls = new _clsdocreview();
_objcls.dr_reviewed = "";
_objcls.issued_date = DateTime.Now;
_objcls.issued_to = "";
_objcls.project_code = "";
_objcls.uid = "";
_objcls.mode = 2;
_objcls.dr_id = Convert.ToInt32(lblid.Text);
_objcls.service = "";
_objcls.Notes = txtnote.Text;
_objcls.dr_status = true;
_objcls.closeout_date = "";
string id = _objbll.Document_Review_Log(_objcls, _objdb);
}
protected void Add_Doc_review_details()
{
BLL_Dml _objbll = new BLL_Dml();
_database _objdb = new _database();
_objdb.DBName = "DB_" + lblprj.Text;
_clsdocreview _objcls = new _clsdocreview();
_objcls.dr_id = Convert.ToInt32(lblid.Text);
_objcls.response = "";
_objcls.issued_date = DateTime.Now;
_objcls.uid = lblrecordby.Text;
_objcls.dr_itm_id = 0;
_objcls.mode = 3;
for (int i = 0; i <= myschedule_basket.Rows.Count - 1; i++)
{
TextBox _details = (TextBox)myschedule_basket.Rows[i].FindControl("txtdetails");
TextBox _desc = (TextBox)myschedule_basket.Rows[i].FindControl("txtdesc");
_objcls.details = _details.Text;
_objcls.desc = _desc.Text;
_objbll.Document_Review_Details(_objcls, _objdb);
}
}
protected void Insert_Doc_review_log()
{
BLL_Dml _objbll = new BLL_Dml();
_database _objdb = new _database();
_objdb.DBName = "DB_" + lblprj.Text;
_clsdocreview _objcls = new _clsdocreview();
_objcls.dr_reviewed = lblsubject.Text;
_objcls.issued_date = DateTime.Now;
_objcls.issued_to = lblissuedto.Text;
_objcls.dr_status = true;//open
_objcls.project_code = lblprj.Text;
_objcls.uid = lblrecordby.Text;
_objcls.mode = 1;
_objcls.service = lblpackage.Text;
_objcls.Notes = txtnote.Text;
_objcls.closeout_date = "";
if (trBuilding.Visible)
{
_objcls.building = Convert.ToInt32(Session["buildingid"]);
}
lbldrno.Text = _objbll.Document_Review_Log(_objcls, _objdb);
}
protected void mygrid_details_RowDataBound(object sender, GridViewRowEventArgs e)
{
e.Row.Cells[8].Visible = false;
e.Row.Cells[9].Visible = false;
if (e.Row.RowType == DataControlRowType.DataRow)
{
if ((string)Session["uid"] != lblissued.Text)
{
Button _btn = (Button)e.Row.FindControl("btnresp");
_btn.Enabled = false;
}
if ((string)Session["group"] != "ADMIN GROUP" && (string)Session["group"] != "SYS.ADMIN GROUP")
{
Button _btn = (Button)e.Row.FindControl("btncml");
_btn.Enabled = false;
}
Label _id = (Label)e.Row.FindControl("lblid");
BLL_Dml _objbll = new BLL_Dml();
_database _objdb = new _database();
_objdb.DBName = "DB_" + (string)Session["project"];
_clsdocreview _objcls = new _clsdocreview();
_objcls.dr_id = Convert.ToInt32(_id.Text);
GridView _myphoto = (GridView)e.Row.FindControl("myphoto");
_myphoto.DataSource = _objbll.Load_DR_Image(_objcls, _objdb);
_myphoto.DataBind();
if (_myphoto.Rows.Count > 0)
{
_photo = true;
}
e.Row.Cells[1].Text = (e.Row.RowIndex + 1).ToString();
int count = 1;
int count1 = 1;
int ent1 = 0;
int ent2 = 0;
TextBox txt = (TextBox)e.Row.FindControl("txtdesc");
TextBox txt1 = (TextBox)e.Row.FindControl("txtdetails");
// if (txt1.Text.Length >= 30)
// count1 = (txt1.Text.Length / 30);
// else
// count1 = 1;
// if (txt.Text.Length >= 30)
// count = (txt.Text.Length / 30);
// else
// count = 1;
// if (count1 > count)
// count = count1;
// else
// count1 = count;
//txt.Height = Unit.Pixel(count * 30);
// txt1.Height = Unit.Pixel(count1 * 30);
foreach (Char chr in txt.Text)
{
if (chr.ToString() == "\n")
{
ent1 += 1;
}
}
foreach (Char chr in txt1.Text)
{
if (chr.ToString() == "\n")
{
ent2 += 1;
}
}
if (txt1.Text.Length >= 25)
{
count1 = (txt1.Text.Length / 25);
}
if (txt.Text.Length >= 25)
{
count = (txt.Text.Length / 25);
}
count += ent1;
count1 += ent2;
if (count1 > count)
{
count = count1;
}
else
{
count1 = count;
}
//txt.Height = Unit.Pixel(count * 30);
//txt1.Height = Unit.Pixel(count1 * 30);
txt.Rows = count + 2;
txt1.Rows = count1 + 2;
}
}