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.Replace("\n", "<br />"); //_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(); BLL_Dml _objbll = new BLL_Dml(); _database _objdb = new _database(); _objdb.DBName = "DB_" + lblprjcode.Text; _clsSO _objcls = new _clsSO(); _objcls.so_itm_id = Convert.ToInt32(lblsoitmid.Text); _objcls.response = txtresp.Text; //.Replace("\n", "<br />"); _objbll.Update_SO_Resp(_objcls, _objdb); load_so_details(Convert.ToInt32(lblid.Text)); btnDummy_ModalPopupExtender1.Hide(); ScriptManager.RegisterStartupScript(this, typeof(string), "close", "CallAutoSize();", true); }
protected void add_Photo() { HttpFileCollection hfc = Request.Files; BLL_Dml _objbll = new BLL_Dml(); _database _objdb = new _database(); _objdb.DBName = "DB_" + lblprj.Text; _clsSO _objcls = new _clsSO(); for (int i = 0; i < hfc.Count; i++) { HttpPostedFile hpf = hfc[i]; string _fileName = System.IO.Path.GetFileName(hpf.FileName); FileInfo _Ffile = new FileInfo(Server.MapPath("..\\DRIMG") + "\\" + lblprj.Text + "\\" + System.IO.Path.GetFileName(hpf.FileName)); if (_Ffile.Exists == true) { _Ffile.Delete(); } if (hpf.ContentLength > 0) { hpf.SaveAs(Server.MapPath("..\\DRIMG") + "\\" + lblprj.Text + "\\" + System.IO.Path.GetFileName(hpf.FileName)); _objcls.photo = "../DRIMG/" + lblprj.Text + "/" + System.IO.Path.GetFileName(hpf.FileName); //_objbll.SO_Photo(_objcls, _objdb); _objbll.DR_Photo(_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"]; _clsSO _objcls = new _clsSO(); _objcls.so_id = Convert.ToInt32(_id.Text); GridView _myphoto = (GridView)e.Item.FindControl("myphoto"); _myphoto.DataSource = _objbll.Load_SO_Photo_Basket(_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; }
private void Load_So_Items() { BLL_Dml _objbll = new BLL_Dml(); _database _objdb = new _database(); _clsSO _objcls = new _clsSO(); _objdb.DBName = "DB_" + lblprjcode.Text; _objcls.so_itm_id = Convert.ToInt32(lblsoitmid.Text); DataTable _dt = _objbll.Load_SO_Items(_objcls, _objdb); foreach (DataRow _drow in _dt.Rows) { txt_descr.Text = Server.HtmlDecode(_drow["details"].ToString()); //txt_cmlcommt.Text = _drow["cmlresp"].ToString(); if (_drow["status"].ToString() == "0") { drstatus.Items.FindByValue("2").Selected = true; } } chkReplacePhoto.Checked = false; //_objcls.so_id = Convert.ToInt32(lblsoitmid.Text); // lvSOPhotoList.DataSource = _objbll.Load_SO_Photo(_objcls, _objdb); //lvSOPhotoList.DataBind(); }
private void Update_soDetails() { BLL_Dml _objbll = new BLL_Dml(); _database _objdb = new _database(); _clsSO _objcls = new _clsSO(); _objdb.DBName = "DB_" + lblprj.Text; _objcls.so_id = Convert.ToInt32(lblmode.Text); _objcls.srv_id = Convert.ToInt32(drpackage.SelectedItem.Value); _objcls.sub = txt_subj.Text; _objcls.idate = txt_date.Text; _objcls.issued_by = txt_created.Text; _objcls.issued_to = txt_issuedto.Text; _objcls.doc_name = txt_docname.Text; _objcls.uid = (string)Session["uid"]; _objcls.comments = txt_cmts.Text; _objcls.response = txt_clear.Text; if (drstatus.SelectedItem.Text == "OPEN") { _objcls.status = true; } else { _objcls.status = false; } _objcls.details = txt_details.Text; _objcls.cdate = txt_cdate.Text; _objcls.mode = 2; _objbll.Insert_SO_Uversion(_objcls, _objdb); ScriptManager.RegisterStartupScript(this, typeof(string), "close", "alert('Documents Uploaded!');", true); }
private void Load_SOUversion_Details() { BLL_Dml _objbll = new BLL_Dml(); _database _objdb = new _database(); _clsSO _objcls = new _clsSO(); _objdb.DBName = "DB_" + lblprj.Text; _objcls.so_id = Convert.ToInt32(lblmode.Text); DataTable _dt = _objbll.Load_SOUversion_Details(_objcls, _objdb); foreach (DataRow _drow in _dt.Rows) { drpackage.Items.FindByText(_drow["srv_name"].ToString()).Selected = true; txt_subj.Text = _drow["subject"].ToString(); txt_date.Text = _drow["issue_date"].ToString(); txt_created.Text = _drow["issued_by"].ToString(); txt_issuedto.Text = _drow["issued_to"].ToString(); txt_cmts.Text = _drow["comments"].ToString(); txt_clear.Text = _drow["response"].ToString(); drstatus.Items.FindByText(_drow["so_status"].ToString()).Selected = true; txt_details.Text = _drow["details"].ToString(); txt_cdate.Text = _drow["compl_date"].ToString(); txt_docname.Text = _drow["doc_name"].ToString(); lbltitle.Text = "Commissioning Snag [" + _drow["so_no"].ToString() + "] - Edit"; } }
private void Load_SO_Info(int so_id) { BLL_Dml _objbll = new BLL_Dml(); _database _objdb = new _database(); _objdb.DBName = "DB_" + lblprjcode.Text; _clsSO _objcls = new _clsSO(); _objcls.so_id = so_id; DataTable _dt = _objbll.Load_SO_Info(_objcls, _objdb); foreach (DataRow _drow in _dt.Rows) { lbpkg.Text = _drow["package"].ToString(); lbcreated.Text = _drow["uid"].ToString(); lbno.Text = _drow["so_no"].ToString(); lbissued.Text = _drow["issued_to"].ToString(); lbdoc.Text = (_drow["subject"].ToString()).Replace("\n", " <br /> "); lblsono.Text = _drow["so_no"].ToString(); lbluid.Text = _drow["uid"].ToString(); lblissued.Text = _drow["issued_to"].ToString(); if (isbuildingProject) { lblBuilding.Text = _drow["building"].ToString(); lblBuilding.Attributes.Add("buildid", _drow["build_id"].ToString()); } } }
private void Submit() { BLL_Dml _objbll = new BLL_Dml(); _database _objdb = new _database(); _objdb.DBName = "DB_" + lblprj.Text; _clsSO _objcls = new _clsSO(); _objcls.so_id = Convert.ToInt32(Request.QueryString[0].ToString());; if (lblid.Text == "0") { _objcls.so_no = (string)Session["sono"]; } else { _objcls.so_no = lblsono.Text; } _objcls.project_code = lblprj.Text; _objcls.so_date = DateTime.Now; _objcls.remarks = lblsono.Text; _objcls.package = (string)Session["service"]; _objcls.doc_name = (string)Session["doc"]; _objcls.uid = (string)Session["uid"]; _objbll.Update_SO_Details(_objcls, _objdb); //Send_Mail(); //load_so_details(); //ScriptManager.RegisterStartupScript(this, typeof(string), "close", "alert('Site Observation Details Submitted');", true); //ScriptManager.RegisterStartupScript(this, typeof(string), "close", "window.close();", true); }
private void Load_SO_Info() { BLL_Dml _objbll = new BLL_Dml(); _database _objdb = new _database(); _objdb.DBName = "DB_" + lblprj.Text; _clsSO _objcls = new _clsSO(); _objcls.so_id = Convert.ToInt32(lblid.Text); DataTable _dt = _objbll.Load_SO_Info(_objcls, _objdb); foreach (DataRow _drow in _dt.Rows) { lblpackage.Text = _drow["package"].ToString(); lblrecordby.Text = _drow["uid"].ToString(); lblsono.Text = _drow["so_no"].ToString(); lblsubmitted.Text = _drow["issued_to"].ToString(); lblsubject.Text = _drow["subject"].ToString(); if (lblprj.Text == "123" || lblprj.Text == "HMIM" || lblprj.Text == "AZC" || lblprj.Text == "HMHS" || lblprj.Text == "demo") { lblbuilding.Text = _drow["building"].ToString(); lblbuilding.Attributes.Add("buildid", _drow["build_id"].ToString()); } //lbluid.Text = _drow["uid"].ToString(); //lblissued.Text = _drow["issued_to"].ToString(); } }
protected void load_so_details() { BLL_Dml _objbll = new BLL_Dml(); _database _objdb = new _database(); _objdb.DBName = "DB_" + lblprj.Text; _clsSO _objcls = new _clsSO(); _objcls.so_no = lblsono.Text; _objcls.project_code = lblprj.Text; _objcls.package = (string)Session["service"]; if (trBuilding.Visible && lblbuilding.Attributes["buildid"] != null) { _objcls.so_building = (Request.QueryString["buildid"] != null) ? (Convert.ToInt32(Request.QueryString["buildid"].ToString())) : Convert.ToInt32(lblbuilding.Attributes["buildid"].ToString()); } _objcls.doc_name = (string)Session["doc"]; _objcls.uid = (string)Session["uid"]; mydetails.DataSource = _objbll.Load_SO_Basket(_objcls, _objdb); mydetails.DataBind(); for (int i = 0; i < mydetails.Items.Count; i++) { Label _slno = (Label)mydetails.Items[i].FindControl("slno"); _slno.Text = (i + 1).ToString(); } }
protected void btnupdate_Click(object sender, EventArgs e) { BLL_Dml _objbll = new BLL_Dml(); _database _objdb = new _database(); _objdb.DBName = "DB_" + (string)Session["project"]; _clsSO _objcls = new _clsSO(); _objcls.so_id = Convert.ToInt32((string)Session["soid"]); if (sostatus1.SelectedItem.Text == "OPEN") { _objcls.status = true; } else { _objcls.status = false; } _objcls.mode = 0; _objcls.package = ""; _objcls.doc_name = ""; _objcls.so_date = DateTime.Now; _objcls.issued_to = ""; _objcls.issued_date = DateTime.Now; _objcls.remarks = ""; _objcls.project_code = ""; _objcls.uid = ""; _objbll.SO_Dir(_objcls, _objdb); load_so_dir((string)Session["project"]); Load_SO_Details(); btnDummy_ModalPopupExtender1.Hide(); }
private void insert_so() { BLL_Dml _objbll = new BLL_Dml(); _database _objdb = new _database(); _objdb.DBName = "DB_" + (string)Session["project"]; _clsSO _objcls = new _clsSO(); _objcls.package = (string)Session["service"]; _objcls.doc_name = (string)Session["doc"]; _objcls.so_date = DateTime.Now; _objcls.issued_to = (string)Session["issued"]; _objcls.issued_date = DateTime.Now; _objcls.remarks = ""; _objcls.project_code = (string)Session["project"]; _objcls.uid = (string)Session["uid"]; _objcls.mode = 1; _objcls.so_id = 0; if (trBuilding.Visible && lblbuilding.Attributes["buildid"] != null) { _objcls.so_building = (Request.QueryString["buildid"] != null) ? Convert.ToInt32(Request.QueryString["buildid"].ToString()) : Convert.ToInt32(lblbuilding.Attributes["buildid"].ToString()); } string _sono = _objbll.SO_Dir(_objcls, _objdb); Session["sono"] = _sono; }
private void uploadFiles() { HttpFileCollection hfc = Request.Files; BLL_Dml _objbll = new BLL_Dml(); _database _objdb = new _database(); _objdb.DBName = "DB_" + lblprj.Text; _clsSO _objcls = new _clsSO(); string _dir = lblprj.Text; if (Directory.Exists(Server.MapPath("..\\CMS_DOCS") + "\\" + _dir) == false) { Directory.CreateDirectory(Server.MapPath("..\\CMS_DOCS") + "\\" + _dir); } for (int i = 0; i < hfc.Count; i++) { HttpPostedFile hpf = hfc[i]; string _fileName = System.IO.Path.GetFileName(hpf.FileName); //FileInfo _Ffile = new FileInfo(Server.MapPath("CMS_DOCS\\" + _dir) + "\\" + System.IO.Path.GetFileName(hpf.FileName)); //if (_Ffile.Exists == true) // _Ffile.Delete(); if (hpf.ContentLength > 0) { hpf.SaveAs(Server.MapPath("..\\CMS_DOCS") + "\\" + _dir + "\\" + System.IO.Path.GetFileName(hpf.FileName)); //hpf.SaveAs("http://www.cmldubai.com\\CmsDocs\\" + System.IO.Path.GetFileName(hpf.FileName)); } _objcls.so_id = 0; _objcls.srv_id = Convert.ToInt32(drpackage.SelectedItem.Value); _objcls.sub = txt_subj.Text; _objcls.idate = txt_date.Text; _objcls.issued_by = txt_created.Text; _objcls.issued_to = txt_issuedto.Text; _objcls.doc_name = System.IO.Path.GetFileName(hpf.FileName); _objcls.uid = (string)Session["uid"]; _objcls.comments = txt_cmts.Text; _objcls.response = txt_clear.Text; if (drstatus.SelectedItem.Text == "OPEN") { _objcls.status = true; } else { _objcls.status = false; } _objcls.details = txt_details.Text; _objcls.cdate = txt_cdate.Text; if (lblmode.Text == "0") { _objcls.mode = 1; } else { _objcls.mode = 2; _objcls.so_id = Convert.ToInt32(lblmode.Text); } _objbll.Insert_SO_Uversion(_objcls, _objdb); ScriptManager.RegisterStartupScript(this, typeof(string), "close", "alert('Documents Uploaded!');", true); } } }
private void Edit_So() { BLL_Dml _objbll = new BLL_Dml(); _database _objdb = new _database(); _clsSO _objcls = new _clsSO(); _objdb.DBName = "DB_" + lblprjcode.Text; _objcls.so_id = Convert.ToInt32(lblid.Text); _objcls.so_itm_id = Convert.ToInt32(lblsoitmid.Text); _objcls.doc_name = txt_doc.Text; _objcls.details = txt_descr.Text; _objcls.comments = ""; bool _status = true; if (drstatus.SelectedValue == "2") { _status = false; } _objcls.status = _status; _objcls.mode = 1; HttpFileCollection hfc = Request.Files; for (int i = 0; i < hfc.Count; i++) { HttpPostedFile hpf = hfc[i]; string _fileName = System.IO.Path.GetFileName(hpf.FileName); FileInfo _Ffile = new FileInfo(Server.MapPath("..\\SOIMG") + "\\" + System.IO.Path.GetFileName(hpf.FileName)); if (_Ffile.Exists == true) { _Ffile.Delete(); } if (hpf.ContentLength > 0) { Guid _uniqueFileName = Guid.NewGuid(); hpf.SaveAs(Server.MapPath("..\\SOIMG") + "\\" + _uniqueFileName.ToString()); _objcls.photo += "../SOIMG/" + _uniqueFileName.ToString() + "*"; // hpf.SaveAs(Server.MapPath("..\\SOIMG") + "\\" + DateTime.Now.GetDateTimeFormats().GetValue(5) + "_" + DateTime.Now.Hour + DateTime.Now.Minute + DateTime.Now.Second+ "(" + i + ")"); //_objcls.photo += "../SOIMG/" + DateTime.Now.GetDateTimeFormats().GetValue(5) + "_" + DateTime.Now.Hour + DateTime.Now.Minute + "(" + i + ")"+"*"; //_objbll.SO_Photo(_objcls, _objdb); //_objbll.Add_SO_Photo_Basket(_objcls, _objdb); } } if (!chkReplacePhoto.Checked) { foreach (DataListItem item in dtSOphotos.Items) { _objcls.photo += ((Label)item.FindControl("lblPhoto")).Text + "*"; } } _objbll.Edit_SO(_objcls, _objdb); }
protected void mydirview_ItemCommand(object sender, ListViewCommandEventArgs e) { if (e.CommandName == "select") { Button _btn = (Button)e.Item.FindControl("btndr_no"); Label _lbl = (Label)e.Item.FindControl("so_idLabel"); Label _issued = (Label)e.Item.FindControl("issued_toLabel"); Label _create = (Label)e.Item.FindControl("uidLabel"); //ScriptManager.RegisterStartupScript(this, typeof(string), "close", "alert('" + _btn.Text + "');", true); Session["soid"] = _lbl.Text; Session["sono"] = _btn.Text; //lbldrno.Text = _btn.Text; // load_so_details(); Session["issued"] = _issued.Text; Session["created"] = _create.Text; //ScriptManager.RegisterStartupScript(this, typeof(string), "Message", "window.open('sodetails.aspx','','left=210,top=100,width=1024,height=600,menubar=1,toolbar=1,scrollbars=1,status=0,resizable=0');", true); if (lblprj.Text == "123") { Response.Redirect("sodetails_new.aspx?PRJ=" + lblprj.Text + "&id=" + _lbl.Text); } else { Response.Redirect("sodetails.aspx"); } //_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"; } else if (e.CommandName == "Update") { Label _id = (Label)e.Item.FindControl("so_idLabel"); DropDownList _drs = (DropDownList)e.Item.FindControl("drstatus"); BLL_Dml _objbll = new BLL_Dml(); _database _objdb = new _database(); _objdb.DBName = "DB_" + (string)Session["project"]; _clsSO _objcls = new _clsSO(); _objcls.so_id = Convert.ToInt32(_id.Text); if (_drs.SelectedItem.Text == "OPEN") { _objcls.status = true; } else { _objcls.status = false; } _objcls.mode = 0; _objcls.package = ""; _objcls.doc_name = ""; _objcls.so_date = DateTime.Now; _objcls.issued_to = ""; _objcls.issued_date = DateTime.Now; _objcls.remarks = ""; _objcls.project_code = ""; _objcls.uid = ""; _objbll.SO_Dir(_objcls, _objdb); } }
private void Update_SOIssue() { BLL_Dml _objbll = new BLL_Dml(); _database _objdb = new _database(); _clsSO _objcls = new _clsSO(); _objdb.DBName = "DB_" + lblprjcode.Text; _objcls.so_id = Convert.ToInt32(lblid.Text); _objcls.issued_to = drissuedto.SelectedItem.Text; _objcls.issued_date = DateTime.Now; _objbll.Update_SOIssueTo(_objcls, _objdb); }
protected void btnupdate_Click(object sender, EventArgs e) { BLL_Dml _objbll = new BLL_Dml(); _database _objdb = new _database(); _objdb.DBName = "DB_" + lblprj.Text; _clsSO _objcls = new _clsSO(); _objcls.so_id = Convert.ToInt32(txt_subject.Attributes["so_id"].ToString()); if (sostatus1.SelectedItem.Text == "OPEN") { _objcls.status = true; } else { _objcls.status = false; if (lblNewProject.Text == "1") { if (RadDatePicker_CloseDate.SelectedDate.ToString() == string.Empty) { RadDatePicker_CloseDate.SelectedDate = DateTime.Now; } _objcls.cdate = Convert.ToDateTime(RadDatePicker_CloseDate.SelectedDate).ToShortDateString(); _objcls.cdate = DateTime.Parse(_objcls.cdate.ToString()).ToString("dd/MM/yyyy"); } } _objcls.mode = 0; _objcls.package = rcbService_Edit.SelectedItem.Text; _objcls.doc_name = txt_subject.Text; _objcls.so_date = DateTime.Now; _objcls.issued_to = ""; _objcls.issued_date = DateTime.Now; _objcls.remarks = ""; _objcls.project_code = ""; _objcls.uid = ""; if (lblNewProject.Text == "1") { _objcls.so_building = (rcbBuilding_Edit.SelectedValue != string.Empty) ? Convert.ToInt32(rcbBuilding_Edit.SelectedValue) : _objcls.so_building; } _objbll.SO_Dir(_objcls, _objdb); 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); load_so_dir(lblprj.Text); Load_SO_Details(); grdSOLog.DataSource = _dtresult; grdSOLog.Rebind(); }
protected void load_so_details(int so_id) { BLL_Dml _objbll = new BLL_Dml(); _database _objdb = new _database(); _objdb.DBName = "DB_" + lblprjcode.Text; _clsSO _objcls = new _clsSO(); _objcls.so_id = so_id; mydetails.DataSource = _objbll.Load_SO_Details(_objcls, _objdb); mydetails.DataBind(); get_itmno(); }
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"]; _clsSO _objcls = new _clsSO(); _objcls.so_id = Convert.ToInt32(_id.Text); _objbll.Remove_SO_Details_Basket(_objcls, _objdb); load_so_details(); } }
private void Generate_SOIMG() { BLL_Dml _objbll = new BLL_Dml(); _database _objdb = new _database(); _objdb.DBName = "DB_" + lblprj.Text; _clsSO _objcls = new _clsSO(); _objcls.so_id = Convert.ToInt32(lblid.Text); DataTable _dtmain = _objbll.Load_SO_Details(_objcls, _objdb); var _result = from o in _dtmain.AsEnumerable() select o; foreach (var row in _result) { _objcls.so_id = Convert.ToInt32(row["so_itm_id"].ToString()); _objcls.so_itm_id = Convert.ToInt32(row["so_itm_id"].ToString()); DataTable _dtsub = _objbll.Load_SO_Photo(_objcls, _objdb); var _sub = from o in _dtsub.AsEnumerable() select o; foreach (var row1 in _sub) { byte[] _image = new byte[1000]; string _path = row1["photo"].ToString(); FileStream fs; BinaryReader br; if (File.Exists(Server.MapPath(_path))) { fs = new FileStream(Server.MapPath(_path), FileMode.Open, FileAccess.Read); br = new BinaryReader(fs); _image = br.ReadBytes((int)fs.Length); br.Close(); fs.Close(); } else { _path = "../SOIMG/default.jpg"; fs = new FileStream(Server.MapPath(_path), FileMode.Open, FileAccess.Read); br = new BinaryReader(fs); _image = br.ReadBytes((int)fs.Length); br.Close(); fs.Close(); } _objcls.logo = _image; _objbll.Generate_SOIMG(_objcls, _objdb); } } }
protected void btnupdate_cmt_Click(object sender, EventArgs e) { BLL_Dml _objbll = new BLL_Dml(); _database _objdb = new _database(); _objdb.DBName = "DB_" + lblprjcode.Text; _clsSO _objcls = new _clsSO(); _objcls.so_itm_id = Convert.ToInt32(lblsoitmid.Text); _objcls.response = txt_cmlresp.Text; _objbll.Update_SO_CMLResp(_objcls, _objdb); load_so_details(Convert.ToInt32(lblid.Text)); ModalPopupExtender1_cmt.Hide(); ScriptManager.RegisterStartupScript(this, typeof(string), "close", "CallAutoSize();", true); }
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"]; _clsSO _objcls = new _clsSO(); _objcls.so_id = Convert.ToInt32(_id.Text); GridView _myphoto = (GridView)e.Item.FindControl("myphoto"); _myphoto.DataSource = _objbll.Load_SO_Photo(_objcls, _objdb); _myphoto.DataBind(); }
private void Delete_So() { BLL_Dml _objbll = new BLL_Dml(); _database _objdb = new _database(); _clsSO _objcls = new _clsSO(); _objdb.DBName = "DB_" + lblprjcode.Text; _objcls.so_id = Convert.ToInt32(lblid.Text); _objcls.so_itm_id = 0; _objcls.doc_name = ""; _objcls.details = ""; _objcls.comments = ""; _objcls.mode = 2; _objbll.Edit_SO(_objcls, _objdb); }
protected void btnupdate_cmt_Click(object sender, EventArgs e) { BLL_Dml _objbll = new BLL_Dml(); _database _objdb = new _database(); _objdb.DBName = "DB_" + lblprjcode.Text; _clsSO _objcls = new _clsSO(); _objcls.so_itm_id = Convert.ToInt32(lblsoitmid.Text); _objcls.response = txt_cmlresp.Text; _objbll.Update_SO_CMLResp(_objcls, _objdb); load_so_details(Convert.ToInt32(lblid.Text)); string script = "function f(){$find(\"" + RadWindow_Comment.ClientID + "\").close(); Sys.Application.remove_load(f);}Sys.Application.add_load(f);"; ScriptManager.RegisterStartupScript(Page, Page.GetType(), "key", script, true); }
protected void add_details() { HttpFileCollection hfc = Request.Files; BLL_Dml _objbll = new BLL_Dml(); _database _objdb = new _database(); _objdb.DBName = "DB_" + lblprj.Text; //if(lblsono.Text=="") // lblsono.Text = _objbll.Get_TempSONo(_objdb); _clsSO _objcls = new _clsSO(); _objcls.details = txtdetails.Text; _objcls.so_no = lblsono.Text; _objcls.package = (string)Session["service"]; _objcls.doc_name = (string)Session["doc"]; _objcls.uid = (string)Session["uid"]; _objcls.project_code = lblprj.Text; if (trBuilding.Visible && lblbuilding.Attributes["buildid"] != null) { _objcls.so_building = (Request.QueryString["buildid"] != null) ? (Convert.ToInt32(Request.QueryString["buildid"].ToString())) : Convert.ToInt32(lblbuilding.Attributes["buildid"].ToString()); } _objbll.Add_SO_Details_Basket(_objcls, _objdb); string[] itm = new string[3]; for (int i = 0; i < hfc.Count; i++) { HttpPostedFile hpf = hfc[i]; //string _fileName = System.IO.Path.GetFileName(hpf.FileName); //FileInfo _Ffile = new FileInfo(Server.MapPath("..\\SOIMG") + "\\" + System.IO.Path.GetFileName(hpf.FileName)); //if (_Ffile.Exists == true) // _Ffile.Delete(); if (hpf.ContentLength > 0) { // hpf.SaveAs(Server.MapPath("..\\SOIMG") + "\\" + System.IO.Path.GetFileName(hpf.FileName)); // _objcls.photo = "../SOIMG/" + System.IO.Path.GetFileName(hpf.FileName); // //_objbll.SO_Photo(_objcls, _objdb); // _objbll.Add_SO_Photo_Basket(_objcls, _objdb); Guid _uniqueFileName = Guid.NewGuid(); string extension = Path.GetExtension(hpf.FileName); string path = Server.MapPath("..\\SOIMG") + "\\" + _uniqueFileName.ToString() + extension; hpf.SaveAs(path); _objcls.photo = "../SOIMG/" + _uniqueFileName.ToString() + extension; _objbll.Add_SO_Photo_Basket(_objcls, _objdb); } } }
protected void mydetails_ItemCommand(object sender, ListViewCommandEventArgs e) { if (e.CommandName == "Update") { Label _id = (Label)e.Item.FindControl("so_itm_idLabel"); TextBox _resp = (TextBox)e.Item.FindControl("responseTextBox"); BLL_Dml _objbll = new BLL_Dml(); _database _objdb = new _database(); _objdb.DBName = "DB_" + lblprjcode.Text; _clsSO _objcls = new _clsSO(); _objcls.so_itm_id = Convert.ToInt32(_id.Text); _objcls.response = _resp.Text; _objbll.Update_SO_Resp(_objcls, _objdb); ScriptManager.RegisterStartupScript(this, typeof(string), "close", "window.close();", true); } else if (e.CommandName == "Edit1") { Label _response = (Label)e.Item.FindControl("lblSOResponse"); Label _comment = (Label)e.Item.FindControl("lblCMLComment"); txtresp.Text = _response.Text.Replace(" <br />", "\n"); lblComment.Text = _comment.Text; Label _soItemID = (Label)e.Item.FindControl("so_itm_idLabel"); Label _serialno = (Label)e.Item.FindControl("slno"); lblsoitmid.Text = _soItemID.Text; lblResponseTitle.Text = lblsono.Text + @" / Item " + _serialno.Text + " Response Issue"; string script = "function f(){$find(\"" + RadWindow_Response.ClientID + "\").show(); Sys.Application.remove_load(f);}Sys.Application.add_load(f);"; ScriptManager.RegisterStartupScript(Page, Page.GetType(), "key", script, true); ScriptManager.RegisterStartupScript(this, typeof(string), "close", "CallAutoSize();", true); } else if (e.CommandName == "Comment") { Label _comment = (Label)e.Item.FindControl("lblCMLComment"); Label _response = (Label)e.Item.FindControl("lblSOResponse"); txt_cmlresp.Text = _comment.Text.Replace(" <br />", "\n");; lblResponse.Text = _response.Text; Label _soItemID = (Label)e.Item.FindControl("so_itm_idLabel"); Label _serialno = (Label)e.Item.FindControl("slno"); lblsoitmid.Text = _soItemID.Text; lblCommentTitle.Text = lblsono.Text + @" / Item " + _serialno.Text + " CML Comment"; string script = "function f(){$find(\"" + RadWindow_Comment.ClientID + "\").show(); Sys.Application.remove_load(f);}Sys.Application.add_load(f);"; ScriptManager.RegisterStartupScript(Page, Page.GetType(), "key", script, true); ScriptManager.RegisterStartupScript(this, typeof(string), "close", "CallAutoSize();", true); } }
protected void mydetails_ItemCommand(object sender, ListViewCommandEventArgs e) { if (e.CommandName == "Update") { Label _id = (Label)e.Item.FindControl("so_itm_idLabel"); TextBox _resp = (TextBox)e.Item.FindControl("responseTextBox"); BLL_Dml _objbll = new BLL_Dml(); _database _objdb = new _database(); _objdb.DBName = "DB_" + (string)Session["project"]; _clsSO _objcls = new _clsSO(); _objcls.so_id = 0; _objcls.details = ""; _objcls.response = _resp.Text; _objcls.so_date = DateTime.Now; _objcls.so_itm_id = Convert.ToInt32(_id.Text); _objcls.mode = 0; _objcls.uid = ""; _objbll.SO_Details(_objcls, _objdb); } }
private void insert_so() { BLL_Dml _objbll = new BLL_Dml(); _database _objdb = new _database(); _objdb.DBName = "DB_" + (string)Session["project"]; _clsSO _objcls = new _clsSO(); _objcls.package = drpackage.SelectedItem.Text; _objcls.doc_name = txtdoc.Text; _objcls.so_date = DateTime.Now; _objcls.issued_to = drissued.SelectedItem.Text; _objcls.issued_date = DateTime.Now; _objcls.remarks = ""; _objcls.project_code = (string)Session["project"]; _objcls.uid = (string)Session["uid"]; _objcls.mode = 1; _objcls.so_id = 0; _objbll.SO_Dir(_objcls, _objdb); load_so_dir((string)Session["project"]); Load_SO_Details(); }
private void Edit_So() { BLL_Dml _objbll = new BLL_Dml(); _database _objdb = new _database(); _clsSO _objcls = new _clsSO(); _objdb.DBName = "DB_" + lblprjcode.Text; _objcls.so_id = Convert.ToInt32(lblid.Text); _objcls.so_itm_id = Convert.ToInt32(lblsoitmid.Text); _objcls.doc_name = lblSubjectText.Text; _objcls.details = txt_descr.Text; _objcls.comments = ""; bool _status = true; if (drstatus.SelectedValue == "2") { _status = false; } _objcls.status = _status; _objcls.mode = 1; foreach (UploadedFile file in asyncSOImageUpload.UploadedFiles) { Guid _uniqueFileName = Guid.NewGuid(); string path = Server.MapPath("..\\SOIMG") + "\\" + _uniqueFileName.ToString() + file.GetExtension(); file.SaveAs(path); _objcls.photo += "../SOIMG/" + _uniqueFileName.ToString() + file.GetExtension() + "*"; } if (!chkReplacePhoto.Checked) { foreach (ListViewDataItem item in lvPhotoList.Items) { _objcls.photo += ((ImageButton)item.FindControl("imgEdit")).ImageUrl + "*"; } } _objbll.Edit_SO(_objcls, _objdb); }
private void Generate_Reports(string _rpt) { bool _isNewProject = (Array.IndexOf(Constants.CMLTConstants.recentProjects, lblprj.Text) > -1) ? true : false; bool _hasBuilding = (Array.IndexOf(Constants.CMLTConstants.hasBuilding, lblprj.Text) > -1) ? true : false; TableLogOnInfos crtableLogoninfos = new TableLogOnInfos(); TableLogOnInfo crtableLogoninfo = new TableLogOnInfo(); ConnectionInfo crConnectionInfo = new ConnectionInfo(); Tables CrTables; BLL_Dml _objbll = new BLL_Dml(); _database _objdb = new _database(); _objdb.DBName = "DBCML"; _clsproject _objcls1 = new _clsproject(); _objcls1.prjcode = lblprj.Text; _objbll.Update_RPTLogo(_objcls1, _objdb); _objdb.DBName = "DB_" + lblprj.Text; if (_rpt == "dr") { //string _path = "../images/" + lblprj.Text + "logo.jpg"; //FileStream fs = new FileStream(Server.MapPath(_path), FileMode.Open, FileAccess.Read); //BinaryReader br = new BinaryReader(fs); //byte[] _image = br.ReadBytes((int)fs.Length); //br.Close(); //fs.Close(); _clsdocreview _objcls = new _clsdocreview(); _objcls.project_code = (string)Session["projectname"]; _objcls.dr_id = Convert.ToInt32(lblid.Text); _objbll.Generate_DRReport(_objcls, _objdb); if (lblprj.Text == "14211") { cryRpt.Load(Server.MapPath("drreport_kaia.rpt")); } if (lblprj.Text == "ARSD") { cryRpt.Load(Server.MapPath("drdetails_svd.rpt")); } else if (_isNewProject) { cryRpt.Load(Server.MapPath("drView.rpt")); } else { cryRpt.Load(Server.MapPath("drreport.rpt")); } } else if (_rpt == "so") { _clsSO _objcls = new _clsSO(); _objcls.project_code = (string)Session["projectname"]; _objcls.so_id = Convert.ToInt32(lblid.Text); _objbll.Generate_SOReport(_objcls, _objdb); Generate_SOIMG(); if (lblprj.Text == "14211") { cryRpt.Load(Server.MapPath("soreport_kaia.rpt")); } else if (lblprj.Text == "ARSD") { cryRpt.Load(Server.MapPath("sodetails_svd.rpt")); } else if (_isNewProject) { cryRpt.Load(Server.MapPath("soreport_new.rpt")); } else { cryRpt.Load(Server.MapPath("soreport.rpt")); } } else if (_rpt == "pr") { _objdb.DBName = "DBCML"; _objdb.Dataname = "DB_" + lblprj.Text; _objdb.project = (string)Session["projectname"]; _objbll.Generate_PRG_RPT(_objdb); cryRpt.Load(Server.MapPath("cpms_report.rpt")); } else if (_rpt == "dlog1") { _objdb.DBName = "DB_" + lblprj.Text; _objdb.rpt = 0; _objdb.Logname = ""; _objbll.Generate_DR_SO_RPT(_objdb); if (lblprj.Text == "14211") { cryRpt.Load(Server.MapPath("drso_kaia.rpt")); } else { cryRpt.Load(Server.MapPath("drso.rpt")); } cryRpt.SetParameterValue("service", "All"); cryRpt.SetParameterValue("rev", "All"); cryRpt.SetParameterValue("iss", "All"); cryRpt.SetParameterValue("sts", "All"); cryRpt.SetParameterValue("project", (string)Session["projectname"]); } else if (_rpt == "dlog") { mydiv.Visible = false; _objdb.DBName = "DB_" + lblprj.Text; if (lblprj.Text == "BNGA") { _objdb.rpt = 2; } else { _objdb.rpt = 0; } _objdb.Logname = lblid.Text; _objbll.Generate_DR_SO_RPT(_objdb); if (lblprj.Text == "14211") { cryRpt.Load(Server.MapPath("drso_kaia.rpt")); SelectionFormula(cryRpt, (string)Session["fsrv"], (string)Session["frev"], (string)Session["fiss"], (string)Session["fsts"]); } else if (_isNewProject) { cryRpt.Load(Server.MapPath("drLog_New.rpt")); cryRpt.SetParameterValue("building", (string)Session["fbui"]); SelectFormulaWithBuilding(cryRpt, (string)Session["fsrv"], (string)Session["frev"], (string)Session["fiss"], (string)Session["fsts"], (string)Session["fbui"]); } else if (lblprj.Text == "ARSD") { cryRpt.Load(Server.MapPath("drsolog_svd.rpt")); SelectionFormula(cryRpt, (string)Session["fsrv"], (string)Session["frev"], (string)Session["fiss"], (string)Session["fsts"]); } else { cryRpt.Load(Server.MapPath("drso.rpt")); SelectionFormula(cryRpt, (string)Session["fsrv"], (string)Session["frev"], (string)Session["fiss"], (string)Session["fsts"]); } cryRpt.SetParameterValue("service", (string)Session["fsrv"]); cryRpt.SetParameterValue("rev", (string)Session["frev"]); cryRpt.SetParameterValue("iss", (string)Session["fiss"]); cryRpt.SetParameterValue("sts", (string)Session["fsts"]); cryRpt.SetParameterValue("project", (string)Session["projectname"]); } else if (_rpt == "som") { _objdb.DBName = "DB_" + lblprj.Text; _objdb.rpt = 1; _objdb.Logname = ""; _objbll.Generate_DR_SO_RPT(_objdb); cryRpt.Load(Server.MapPath("drso.rpt")); cryRpt.SetParameterValue("service", "All"); cryRpt.SetParameterValue("rev", "All"); cryRpt.SetParameterValue("iss", "All"); cryRpt.SetParameterValue("sts", "All"); cryRpt.SetParameterValue("project", (string)Session["projectname"]); } else if (_rpt == "cmtlogdr") { mydiv.Visible = false; _clsSO _objcls = new _clsSO(); _objcls.mode = 0; DataSet ds = new DataSet(); ds = _objbll.Load_DR_SO_CommentLog(_objcls, _objdb); cryRpt.Load(Server.MapPath("drCommentLog.rpt")); cryRpt.Database.Tables["DR_CMMNT_RPT"].SetDataSource(ds.Tables[0]); cryRpt.Subreports[0].Database.Tables[0].SetDataSource(ds.Tables[1]); cryRpt.SetParameterValue("project", (string)Session["projectname"]); } else if (_rpt == "socmtlog") { mydiv.Visible = false; _clsSO _objcls = new _clsSO(); _objcls.mode = (_rpt == "socmtlog" ? 1 : 0); DataSet ds = new DataSet(); ds = _objbll.Load_DR_SO_CommentLog(_objcls, _objdb); ds.Tables[1].Columns.Add("Image", typeof(byte[])); FileStream fs; BinaryReader br; byte[] _image; //int ins=0; for (int ins = 0; ins <= ds.Tables[1].Rows.Count - 1; ins += 1) { string _path = ds.Tables[1].Rows[ins]["Photo"].ToString(); if (string.IsNullOrEmpty(_path)) { continue; } fs = new FileStream(Server.MapPath(_path), FileMode.Open, FileAccess.Read); br = new BinaryReader(fs); _image = br.ReadBytes((int)fs.Length); ds.Tables[1].Rows[ins]["Image"] = _image; ds.Tables[1].AcceptChanges(); } cryRpt.Load(Server.MapPath("SoCommentLog.rpt")); cryRpt.Database.Tables["SO_CMMNT_RPT"].SetDataSource(ds.Tables[0]); cryRpt.Subreports[0].Database.Tables[0].SetDataSource(ds.Tables[1]); //cryRpt.Subreports[1].Database.Tables[0].SetDataSource(ds.Tables[2]); cryRpt.SetParameterValue("project", (string)Session["projectname"]); } else if (_rpt == "som1") { mydiv.Visible = false; _objdb.DBName = "DB_" + lblprj.Text; _objdb.rpt = 1; _objdb.Logname = ""; _objbll.Generate_DR_SO_RPT(_objdb); if (lblprj.Text == "14211") { cryRpt.Load(Server.MapPath("drso_kaia.rpt")); } else if (_isNewProject && _hasBuilding) { DataSet _ds = new DataSet(); DataTable _dt = GetData(); _ds.Tables.Add(_dt); //_ds.WriteXmlSchema(Server.MapPath("") + "\\soreport.xml"); cryRpt.Load(Server.MapPath("SO_New.rpt")); cryRpt.Database.Tables[0].SetDataSource(_ds.Tables[0]); cryRpt.SetParameterValue("building", (string)Session["fbui"]); } else if (lblprj.Text == "ARSD") { cryRpt.Load(Server.MapPath("drsolog_svd.rpt")); } else { cryRpt.Load(Server.MapPath("drso.rpt")); } cryRpt.SetParameterValue("service", (string)Session["fsrv"]); cryRpt.SetParameterValue("rev", (string)Session["frev"]); cryRpt.SetParameterValue("iss", (string)Session["fiss"]); cryRpt.SetParameterValue("sts", (string)Session["fsts"]); cryRpt.SetParameterValue("project", (string)Session["projectname"]); if (_isNewProject && _hasBuilding) { SelectionFormula_New(cryRpt, (string)Session["fsrv"], (string)Session["frev"], (string)Session["fiss"], (string)Session["fsts"], (string)Session["fbui"]); } else { SelectionFormula(cryRpt, (string)Session["fsrv"], (string)Session["frev"], (string)Session["fiss"], (string)Session["fsts"]); } } else if (_rpt == "uso") { mydiv.Visible = false; _objdb.DBName = "DB_" + lblprj.Text; _objdb.rpt = 1; _objbll.Generate_DR_SO_RPT(_objdb); cryRpt.Load(Server.MapPath("uso_log.rpt")); } else if (_rpt == "cp") { _objdb.DBName = "DBCML"; _objdb.Dataname = "DB_" + lblprj.Text; _objdb.project = (string)Session["projectname"]; _objbll.Generate_CP_RPT(_objdb); cryRpt.Load(Server.MapPath("cpms_report.rpt")); //cryRpt.Load(Server.MapPath("comment_rpt.rpt")); //cryRpt.SetParameterValue("project", (string)Session["projectname"]); } else if (_rpt == "msc") { _objdb.DBName = "DB_" + lblprj.Text; if (lblprj.Text == "HMIM") { _clscassheet _objcls = new _clscassheet(); _objcls.build_id = Convert.ToInt32(Session["building_id"].ToString()); _objbll.Gen_MSComment_Rpt(_objcls, _objdb); cryRpt.Load(Server.MapPath("ms_comments_rpt 1.rpt")); cryRpt.SetParameterValue("bldng", "BUILDING : " + (string)Session["building"]); } else { _objbll.Gen_MSComment_Rpt(_objdb); cryRpt.Load(Server.MapPath("ms_comments_rpt.rpt")); } cryRpt.SetParameterValue("project", (string)Session["projectname"]); cryRpt.SetParameterValue("ser", drservices.SelectedItem.Text); cryRpt.SetParameterValue("sys", drpackages.SelectedItem.Text); cryRpt.SetParameterValue("typ", drtype.SelectedItem.Text); MSC_SelectionFormula(cryRpt, drservices.SelectedItem.Text, drpackages.SelectedItem.Text, drtype.SelectedItem.Text); } else if (_rpt == "msr") { mydiv.Visible = false; //if (lblprj.Text == "12761") // cryRpt.Load(Server.MapPath("ms_schedule_summary1.rpt")); //else cryRpt.Load(Server.MapPath("ms_schedule_summary2.rpt")); cryRpt.SetParameterValue("project", (string)Session["projectname"]); cryRpt.SetParameterValue("srv", (string)Session["srv"]); cryRpt.SetParameterValue("sys", (string)Session["sys"]); cryRpt.SetParameterValue("typ", (string)Session["typ"]); cryRpt.SetParameterValue("sts", (string)Session["sts"]); } else if (_rpt == "mss") { //_objdb.DBName = "DB_" + lblprj.Text; //_objbll.Gen_MS_Schedule_Summary(_objdb); mydiv.Visible = false; if (lblprj.Text == "12761") { cryRpt.Load(Server.MapPath("ms_schedule_summary1.rpt")); } else if (lblprj.Text == "HMIM" || lblprj.Text == "ABS") { cryRpt.Load(Server.MapPath("ms_schedule_summary3.rpt")); cryRpt.SetParameterValue("bldng", (string)Session["building"]); } else { cryRpt.Load(Server.MapPath("ms_schedule_summary.rpt")); } cryRpt.SetParameterValue("project", (string)Session["projectname"]); cryRpt.SetParameterValue("srv", (string)Session["srv"]); cryRpt.SetParameterValue("sys", (string)Session["sys"]); cryRpt.SetParameterValue("typ", (string)Session["typ"]); cryRpt.SetParameterValue("sts", (string)Session["sts"]); MSS_SelectionFormula(cryRpt, (string)Session["srv"], (string)Session["sys"], (string)Session["typ"], (string)Session["sts"]); } else if (_rpt == "doc_comm") { mydiv.Visible = false; cryRpt.Load(Server.MapPath("comment_rpt.rpt")); cryRpt.SetParameterValue("project", (string)Session["projectname"]); } else if (_rpt == "cas") { _objdb.DBName = "DBCML"; _objdb.Dataname = "DB_" + lblprj.Text; _objdb.photo_rpt = null; _objdb.project = (string)Session["projectname"]; _objdb.Datapath = lblprj.Text; _objdb.rpt = Convert.ToInt32((string)Session["sch_id"]); _objdb.cas = (string)Session["sch_id"]; _objbll.Generate_CAS_RPT(_objdb); // _objbll.CAS_PKG_SUM_RPT(_objdb); if ((string)Session["sch_id"] == "1" || (string)Session["sch_id"] == "5") { cryRpt.Load(Server.MapPath("cas_lv.rpt")); } else if ((string)Session["sch_id"] == "2") { cryRpt.Load(Server.MapPath("cas_mv.rpt")); } else if ((string)Session["sch_id"] == "3") { cryRpt.Load(Server.MapPath("cas_tx.rpt")); } else if ((string)Session["sch_id"] == "6") { cryRpt.Load(Server.MapPath("cas_e_l.rpt")); } else if ((string)Session["sch_id"] == "8") { cryRpt.Load(Server.MapPath("cas_mec.rpt")); } else if ((string)Session["sch_id"] == "17") { cryRpt.Load(Server.MapPath("cas_ph1.rpt")); } else if ((string)Session["sch_id"] == "18") { cryRpt.Load(Server.MapPath("cas_ph2.rpt")); } else if ((string)Session["sch_id"] == "19") { cryRpt.Load(Server.MapPath("cas_ph3.rpt")); } else if ((string)Session["sch_id"] == "20") { cryRpt.Load(Server.MapPath("cas_bms.rpt")); } cryRpt.SetParameterValue("bz", "All"); cryRpt.SetParameterValue("cat", "All"); cryRpt.SetParameterValue("fl", "All"); cryRpt.SetParameterValue("ff", "All"); } else if (_rpt == "ams") { cryRpt.Load(Server.MapPath("../AMS/tasklist.rpt")); } else if (_rpt == "SODR_PDF") { mydiv.Visible = false; _objdb.DBName = "DB_" + lblprj.Text; if (!String.IsNullOrEmpty(Request.QueryString["dtype"])) { _objdb.rpt = Convert.ToInt16(Request.QueryString["dtype"].ToString()); } _objdb.Logname = lblid.Text; _objbll.Generate_DR_SO_RPT_PDF(_objdb); cryRpt.Load(Server.MapPath("drso_pdf.rpt")); SelectionFormula(cryRpt, (string)Session["fsrv"], (string)Session["frev"], (string)Session["fiss"], (string)Session["fsts"]); cryRpt.SetParameterValue("service", (string)Session["fsrv"]); cryRpt.SetParameterValue("rev", (string)Session["frev"]); cryRpt.SetParameterValue("iss", (string)Session["fiss"]); cryRpt.SetParameterValue("sts", (string)Session["fsts"]); cryRpt.SetParameterValue("project", (string)Session["projectname"]); } if (_rpt != "som1" || lblprj.Text != "HMIM") { crConnectionInfo.ServerName = Constants.CMLTConstants.serverName; crConnectionInfo.DatabaseName = Constants.CMLTConstants.dbName; crConnectionInfo.UserID = Constants.CMLTConstants.dbUserName; crConnectionInfo.Password = Constants.CMLTConstants.dbPassword; CrTables = cryRpt.Database.Tables; foreach (CrystalDecisions.CrystalReports.Engine.Table CrTable in CrTables) { crtableLogoninfo = CrTable.LogOnInfo; crtableLogoninfo.ConnectionInfo = crConnectionInfo; CrTable.ApplyLogOnInfo(crtableLogoninfo); } } //CrystalReportViewer1.ParameterFieldInfo = paramFields; CrystalReportViewer1.ReportSource = cryRpt; CrystalReportViewer1.DataBind(); //CrystalReportViewer1.RefreshReport(); //CrystalReportViewer1.PageZoomFactor = 200; Session["Report"] = cryRpt; _clsuser _cls = new _clsuser(); _cls.uid = (string)Session["uid"]; _cls.project_code = lblprj.Text; _cls.mode = 2; _objdb.DBName = "DBCML"; string _access = _objbll.Get_CMSAccess(_cls, _objdb); if (_access == "Read Only") { CrystalReportViewer1.HasExportButton = false; } }