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; } }