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