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 Load_CXIR_Details()
{
BLL_Dml _objbll = new BLL_Dml();
_database _objdb = new _database();
_clscassheet _objcls = new _clscassheet();
_objdb.DBName = "DB_" + lblprj.Text;
_objcls.c_s_id = Convert.ToInt32(lblid.Text);
DataTable _dt = _objbll.Load_CXIR_Schedule_Details(_objcls, _objdb);
foreach (DataRow _drow in _dt.Rows)
{
txt_ref.Text = _drow["ir_ref"].ToString();
txt_rev.Text = _drow["ir_rev"].ToString();
txt_dtrecv.Text = _drow["dt_recv"].ToString();
txt_dtprop.Text = _drow["dt_prop"].ToString();
drampm.ClearSelection();
drampm.Items.FindByText(_drow["am_pm"].ToString()).Selected = true;
txt_type.Text = _drow["test_type"].ToString();
drservice.ClearSelection();
drservice.Items.FindByText(_drow["discipline"].ToString()).Selected = true;
txt_sys.Text = _drow["system"].ToString();
txt_details.Text = _drow["details"].ToString();
txt_bldg.Text = _drow["building"].ToString();
txt_lvl.Text = _drow["flevel"].ToString();
drloc.ClearSelection();
drloc.Items.FindByText(_drow["location"].ToString()).Selected = true;
txt_irchk.Text = _drow["ir_checked"].ToString();
txt_adv.Text = _drow["advise"].ToString();
txt_dtpstart.Text = _drow["prop_start"].ToString();
txt_dtastart.Text = _drow["actual_start"].ToString();
txt_delay.Text = _drow["dtdelay"].ToString();
txt_dtcomp.Text = _drow["dt_compl"].ToString();
txt_vist.Text = _drow["visit"].ToString();
txt_witness.Text = _drow["witness"].ToString();
txt_status.Text = _drow["ir_status"].ToString();
txt_docstatus.Text = _drow["doc_status"].ToString();
txt_svrno.Text = _drow["svr_no"].ToString();
txt_notes.Text = _drow["notes"].ToString();
}
}
private void uploadFiles()
{
HttpFileCollection hfc = Request.Files;
BLL_Dml _objbll = new BLL_Dml();
_database _objdb = new _database();
_objdb.DBName = "DBCML";
_clsproject _objcls = new _clsproject();
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("images") + "\\" + drproject.SelectedItem.Value + "logo.jpg");
if (_Ffile.Exists == true)
{
_Ffile.Delete();
}
if (hpf.ContentLength > 0)
{
hpf.SaveAs(Server.MapPath("images") + "\\" + System.IO.Path.GetFileName(hpf.FileName));
FileInfo _info1 = new FileInfo(Server.MapPath("images") + "\\" + System.IO.Path.GetFileName(hpf.FileName));
if (_info1.Exists == true)
{
_info1.MoveTo(Server.MapPath("images") + "\\" + drproject.SelectedItem.Value + "logo.jpg");
}
//ScriptManager.RegisterStartupScript(this, typeof(string), "close", "alert('Documents Uploaded!');", true);
}
}
string _path = "images/" + drproject.SelectedItem.Value + "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();
_objcls.prjcode = drproject.SelectedItem.Value;
_objcls.logo = _image;
_objbll.Update_PrjLogo(_objcls, _objdb);
ScriptManager.RegisterStartupScript(this, typeof(string), "close", "alert('Completed!');", true);
}
void User_Log()
{
BLL_Dml _objbll = new BLL_Dml();
_database _objdb = new _database();
_objdb.DBName = "dbCML";
_clslog _objcls = new _clslog();
_objcls.uid = (string)Session["uid"];
string _login = Request.Form["_login"].ToString();
_objcls.ipaddr = Request.Form["_ip"].ToString();
List <string> _result = LoadIPLocation(_objcls.ipaddr);
_objcls.Country = _result[0];
_objcls.Region = _result[1];
_objcls.location = _result[2];
_objcls.module = "CMS";
_objcls.login = _login;
_objbll.UpdateUserLog(_objcls, _objdb);
}
protected void Load_doc(string Project)
{
BLL_Dml _objbll = new BLL_Dml();
_database _objdb = new _database();
_objdb.DBName = "DB_" + Project;
_clscmsdocument _objcls = new _clscmsdocument();
_objcls.reff_no = (string)Session["reff_no"];
_objcls.project_code = Project;
_objcls.status = true;
//mygrid.DataSource = _objbll.Load_CMS_Document(_objcls, _objdb);
//mygrid.DataBind();
rpt_latest.DataSource = _objbll.Load_CMS_Document(_objcls, _objdb);
rpt_latest.DataBind();
_objcls.status = false;
//myhistory.DataSource = _objbll.Load_CMS_Document(_objcls, _objdb);
//myhistory.DataBind();
rpt_history.DataSource = _objbll.Load_CMS_Document(_objcls, _objdb);
rpt_history.DataBind();
}
protected void cmdadd_Click(object sender, EventArgs e)
{
if (IsnullValidation() == true)
{
return;
}
BLL_Dml _objbll = new BLL_Dml();
_database _objdb = new _database();
_objdb.DBName = "dbCML";
_clscomment _objcls = new _clscomment();
_objcls.comm_id = Convert.ToInt32((string)Session["comid"]);
_objcls.resp = txtrespond.Text;
_objbll.add_resp(_objcls, _objdb);
ScriptManager.RegisterStartupScript(this, typeof(string), "close", "alert('CML Response added!');", true);
Send_Notification();
txtrespond.Text = "";
txtcomment.Text = "";
Panel1.Visible = false;
}
protected void load_cas_sys()
{
BLL_Dml _objbll = new BLL_Dml();
_database _objdb = new _database();
_objdb.DBName = "dbCML";
_clscassheet _objcls = new _clscassheet();
_objcls.sch = Convert.ToInt32((string)Session["sch"]);
//ScriptManager.RegisterStartupScript(this, typeof(string), "FileNotFoundWarning", "alert('" + (string)Session["sch"] + "');", true);
//.DataSource = _objbll.Load_cas_sys(_objcls);
//drsys.DataTextField = "sys_name";
//drsys.DataValueField = "sys_id";
//drsys.DataBind();
DropDownList _drlist = (DropDownList)my_in_view.InsertItem.FindControl("drsrv");
_drlist.DataSource = _objbll.Load_cas_sys(_objcls, _objdb);
//_drlist.DataTextField = "sys_name";
//_drlist.DataValueField = "sys_id";
_drlist.DataBind();
}
protected void Load_Project()
{
BLL_Dml _objbal = new BLL_Dml();
_database _objdb = new _database();
_objdb.DBName = "dbCML";
DataTable _dtable = _objbal.load_project(_objdb);
var _result = from o in _dtable.AsEnumerable()
where o.Field <string>(5) == "YES"
select o;
foreach (var row in _result)
{
ListItem _lst = new ListItem();
_lst.Text = row[1].ToString();
_lst.Value = row[0].ToString();
drproject.Items.Add(_lst);
}
drproject.DataBind();
drproject.Items.Insert(0, "--Select Project--");
}
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 LOAD_CASSHEET()
{
chkcassheet.Items.Clear();
BLL_Dml _objbll = new BLL_Dml();
_database _objdb = new _database();
_objdb.DBName = "dbCML";
DataTable _dtable = _objbll.LOAD_SYS_CMS_CASSHEET(_objdb);
//string _masterid = drcasservice.SelectedItem.Value.Substring(drcasservice.SelectedItem.Value.IndexOf("M_") + 2);
var _id = from o in _dtable.AsEnumerable()
where o.Field <int>(2) == Convert.ToInt32(drcasservice.SelectedItem.Value)
select o;
foreach (var row in _id)
{
ListItem _lst = new ListItem();
_lst.Text = row[1].ToString();
_lst.Value = row[0].ToString();
chkcassheet.Items.Add(_lst);
}
}
private void Get_CasInfo()
{
string _query = Request.QueryString[0].ToString();
BLL_Dml _objbll = new BLL_Dml();
_clscassheet _objcls = new _clscassheet();
_database _objdb = new _database();
_objdb.DBName = "DB_" + (string)Session["project"];
_objcls.cas_id = Convert.ToInt32(_query);
DataTable _dt = _objbll.Get_casinfo(_objcls, _objdb);
var result = from o in _dt.AsEnumerable()
select o;
foreach (var row in result)
{
lblprj.Text = (string)Session["projectname"];
lblsys.Text = row[6].ToString();
lblreff.Text = row[0].ToString();
lblcode.Text = row[1].ToString() + row[2].ToString() + row[3].ToString() + row[4].ToString();
}
}
private void Load_Master()
{
BLL_Dml _objbll = new BLL_Dml();
_database _objdb = new _database();
_objdb.DBName = "DB_" + lblprj.Text;
_clscassheet _objcas = new _clscassheet();
_objcas.sch = 19;
_objcas.prj_code = lblprj.Text;
if (lblprj.Text == "14211")
{
_objcas.sys = Convert.ToInt32(lbldiv.Text);
}
_dtMaster = _objbll.Load_casMain_Edit(_objcas, _objdb);
_dtresult = _dtMaster;
_summary = _dtresult;
}
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();
}
private void Update_Package()
{
BLL_Dml _objbll = new BLL_Dml();
_database _objdb = new _database();
_objdb.DBName = "DB_" + lblprj.Text;
_clspackage _objcls = new _clspackage();
_objcls.package = "";
_objcls.category = txtcode1.Text;
_objcls.sch_id = 0;
_objcls.project = lblprj.Text;
//_objcls.record_sheet = Convert.ToInt32(drrdsheet.SelectedItem.Value);
_objcls.record_sheet = 0;
_objcls.sys_id = Convert.ToInt32(drpkg.SelectedItem.Value);
_objcls.mode = 0;
_objbll.create_package(_objcls, _objdb);
ScriptManager.RegisterStartupScript(this, typeof(string), "close", "alert('Package Updated');", true);
txtpackage.Text = "";
txtcode.Text = "";
}
void Send_Mail()
{
BLL_Dml _objbll = new BLL_Dml();
_database _objdb = new _database();
_objdb.DBName = "DBCML";
_clsuser _objcls1 = new _clsuser();
_objcls1.project_code = lblprjcode.Text;
string _prj = _objbll.Get_ProjectName(_objcls1, _objdb);
publicCls.publicCls _objcls = new publicCls.publicCls();
string Body = "";
Body = "Ref. " + _prj + "/" + lbpkg.Text + "/" + lbldrno.Text + "\n\n" + "This is an automatically generated email to inform you that " + lbissued.Text + " responded the above document" + "\n\n" + "Thank you in anticipation of your co-operation with the review process." + "\n\n" + "CML" + "\n" + "Techniques" + "\n\n\n" + "https://cmltechniques.com";
string _sub = "Document Review Response - Ref. " + _prj + "/" + lbpkg.Text + "/" + lbldrno.Text;
_objcls.Send_Email(lbluid.Text, _sub, Body);
//_objcls.Send_Email("*****@*****.**", _sub, Body);
}
private void Load_Master()
{
BLL_Dml _objbll = new BLL_Dml();
_database _objdb = new _database();
_objdb.DBName = "DB_" + lblprj.Text;
_clscassheet _objcas = new _clscassheet();
if ((lblprj.Text == "11784" || lblprj.Text == "MOE") && (Request.QueryString["sch"] != null))
{
_objcas.sch = Convert.ToInt32(Request.QueryString["sch"].ToString());
}
else
{
_objcas.sch = 24;
}
_objcas.prj_code = lblprj.Text;
_dtMaster = _objbll.Load_casMain_Edit(_objcas, _objdb);
_dtresult = _dtMaster;
_summary = _dtMaster;
}
protected void btndms_Click(object sender, EventArgs e)
{
BLL_Dml _objbll = new BLL_Dml();
_database _objdb = new _database();
_objdb.DBName = "dbCML";
_clsuser _objcls = new _clsuser();
_objcls.uid = (string)Session["uid"];
Session["module"] = "DMS";
_objcls.mode = 1;
if (_objbll.Module_Access(_objcls, _objdb) == true)
{
//ScriptManager.RegisterStartupScript(this, typeof(string), "close", "parent.call(1,'" + (string)Session["project"] + "');", true);
btnDummy_ModalPopupExtender2.Show();
}
else
{
ScriptManager.RegisterStartupScript(this, typeof(string), "", "alert('Access Denied');", true);
}
}
private void Set_Modules()
{
BLL_Dml _objbll = new BLL_Dml();
_database _objdb = new _database();
_objdb.DBName = "dbCML";
_clsuser _objcls = new _clsuser();
_objcls.uid = (string)Session["uid"];
_objcls.mode = 2;
if (_objbll.Module_Access(_objcls, _objdb) == false)
{
cms_li.Visible = false;
}
_objcls.mode = 1;
if (_objbll.Module_Access(_objcls, _objdb) == false)
{
dms_li.Visible = false;
}
ams_li.Visible = false;
}
protected void add_initial_data()
{
//if (IsNullvalidation() == true) return;
string _sys = drpackage.SelectedItem.Value.Substring(0, drpackage.SelectedItem.Value.IndexOf("_C"));
BLL_Dml _objbll = new BLL_Dml();
_database _objdb = new _database();
_objdb.DBName = "DB_" + (string)Session["project"];
_clscassheet _objcas = new _clscassheet();
_objcas.c_s_id = Convert.ToInt32((string)Session["sch"]);
_objcas.prj_code = (string)Session["project"];
_objcas.uid = (string)Session["uid"];
_objcas.sys = Convert.ToInt32(_sys);
_objcas.reff = txtengref.Text;
_objcas.b_zone = txtzone.Text;
_objcas.cate = txtcate.Text;
_objcas.f_level = txtlevel.Text;
_objcas.seq_no = Convert.ToInt32(txtseq.Text);
_objcas.desc = txtdesc.Text;
_objcas.loca = txtloca.Text;
_objcas.p_power_to = txtpprovideto.Text;
_objcas.fed_from = txtfedfr.Text;
_objcas.sub_st = txtdesc.Text;
_objcas.s_c_m = txtdesc.Text;
_objcas.dev1 = txtnoof.Text;
if ((string)Session["sch"] == "10" || (string)Session["sch"] == "16" || (string)Session["sch"] == "20")
{
_objcas.dev2 = txtdesc.Text;
}
else
{
_objcas.dev2 = "0";
}
_objcas.dev3 = "0";
_objcas.mode = 1;
_objcas.cas_id = 0;
_objbll.Cassheet_Master(_objcas, _objdb);
}
protected void load_services(string Project)
{
BLL_Dml _objbll = new BLL_Dml();
_database _objdb = new _database();
_objdb.DBName = "DB_" + Project;
DataTable _soservice = _objbll.Load_Cas_service(_objdb);
if (tblAdd.Visible)
{
foreach (DataRow dataRow in _soservice.Rows)
{
RadComboBoxItem item = new RadComboBoxItem();
item.Text = (string)dataRow["PRJ_SER_NAME"];
item.Value = dataRow["SYS_SER_ID"].ToString();
rcbPackage.Items.Add(item);
}
if (lblprj.Text == "HPOB")
{
RadComboBoxItem mepItem = new RadComboBoxItem();
mepItem.Text = "MEP";
mepItem.Value = "MEP";
rcbPackage.Items.Add(mepItem);
}
rcbPackage.DataBind();
}
foreach (DataRow dataRow in _soservice.Rows)
{
RadComboBoxItem item = new RadComboBoxItem();
item.Text = (string)dataRow["PRJ_SER_NAME"];
item.Value = dataRow["SYS_SER_ID"].ToString();
rcbService_Edit.Items.Add(item);
}
rcbService_Edit.DataBind();
}
protected void load_users(string Project)
{
BLL_Dml _objbll = new BLL_Dml();
_database _objdb = new _database();
_objdb.DBName = "DBCML";
_clsuser _objcls = new _clsuser();
_objcls.project_code = lblprj.Text;
_objcls.mode = 6;
DataTable dtIssuedTo = _objbll.Load_CMS_Users(_objcls, _objdb);
foreach (DataRow dataRow in dtIssuedTo.Rows)
{
RadComboBoxItem item = new RadComboBoxItem();
item.Text = (string)dataRow["uid"];
item.Value = dataRow["uid"].ToString();
rcbIssued.Items.Add(item);
item.DataBind();
}
}
protected void Load_MSDeatils()
{
DataTable dtms;
BLL_Dml _objbll = new BLL_Dml();
_database _objdb = new _database();
_objdb.DBName = "DB_" + (string)Session["project"];
_clscassheet _objcls = new _clscassheet();
_objcls.sch = Convert.ToInt32((string)Session["folder_id"]);
dtms = _objbll.Load_MSSYSTEM(_objcls, _objdb);
if (dtms.Rows.Count > 0)
{
chkharam.Checked = Convert.ToBoolean(dtms.Rows[0]["HARAM_PIAZZA"].ToString());
chkservice.Checked = Convert.ToBoolean(dtms.Rows[0]["SERVICE_BLDNG"].ToString());
chkcuc.Checked = Convert.ToBoolean(dtms.Rows[0]["CUC_T4"].ToString());
Session["mspos"] = dtms.Rows[0]["POSSITION"].ToString();
}
}
public void DeleteLog(string ids, string pdfs, string prj)
{
BLL_Dml _objbll = new BLL_Dml();
_database _objdb = new _database();
_objdb.DBName = "DB_" + prj;
_clsdocument _objcls = new _clsdocument();
_objcls.doc_name = ids;
_objbll.DeleteDocuments("DeleteCableLog", _objcls, _objdb);
string[] docs = pdfs.Split(',');
string dirFullPath = HttpContext.Current.Server.MapPath("..//CMS_DOCS//") + prj + "\\CableLog\\";
foreach (string pdf in docs)
{
if (File.Exists(dirFullPath + pdf.Trim()))
{
File.Delete(dirFullPath + pdf);
}
}
}
private void Load_Comments(string _id, string _module, string _type)
{
BLL_Dml _objbll = new BLL_Dml();
_database _objdb = new _database();
_objdb.DBName = "DB_" + (string)Session["project"];
_clsdocument _objcls = new _clsdocument();
_objcls.doc_name = _module;
_objcls.doc_id = Convert.ToInt32(_id);
_objcls.folder_id = Convert.ToInt32(_type);
mygrid.DataSource = _objbll.Load_CMS_CommentsAll(_objcls, _objdb);
mygrid.DataBind();
if (mygrid.Rows.Count == 0)
{
lblinfo.Text = "No Comments Found";
}
else
{
lblinfo.Visible = false;
}
}
//protected void Config_Ms_Schedule(int ser_id,bool enabled)
//{
// BLL_Dml _objbll = new BLL_Dml();
// _database _objdb = new _database();
// _clsMaster _objcls = new _clsMaster();
// _objdb.DBName = "dbCML";
// _objcls.ser_id = ser_id;
// _objcls.sys_id = 0;
// _objcls.enabled = enabled;
//}
protected void add_ms_type(string _type)
{
BLL_Dml _objbll = new BLL_Dml();
_database _objdb = new _database();
_clsMaster _objcls = new _clsMaster();
_objdb.DBName = "DB_" + (string)Session["project"];
_objcls.ser_id = Convert.ToInt32(drmsservice.SelectedItem.Value);
for (int i = 0; i <= chkmssystem.Items.Count - 1; i++)
{
if (chkmssystem.Items[i].Selected == true)
{
_objcls.enabled = true;
}
else
{
_objcls.enabled = false;
}
_objcls.sys_id = Convert.ToInt32(chkmssystem.Items[i].Value);
_objbll.Config_Ms_Schedule(_objcls, _objdb);
}
}
protected void Load_MS_Systems()
{
chkmssystem.Items.Clear();
BLL_Dml _objbll = new BLL_Dml();
_database _objdb = new _database();
_clsMaster _objcls = new _clsMaster();
_objdb.DBName = "dbCML";
_objcls.ser_id = Convert.ToInt32(drmsservice.SelectedItem.Value);
chkmssystem.DataSource = _objbll.Load_Ms_Systems(_objcls, _objdb);
DataTable _dtable = _objbll.Load_Ms_Systems(_objcls, _objdb);
var _result = from o in _dtable.AsEnumerable()
select o;
foreach (var row in _result)
{
ListItem _lst = new ListItem();
_lst.Text = row[2].ToString();
_lst.Value = row[0].ToString() + "_R" + row[1].ToString();
chkmssystem.Items.Add(_lst);
}
}
private void load_doc_review_log(string Project)
{
////DataTable _dtmaster = new DataTable();
////_dtmaster.Columns.Add(
BLL_Dml _objbll = new BLL_Dml();
_database _objdb = new _database();
_objdb.DBName = "DB_" + Project;
_clsuser _objcls = new _clsuser();
_objcls.project_code = Project;
//if (rcbPackage.SelectedItem == null)
_objcls.service = string.Empty;
//else
// _objcls.service = rcbPackage.SelectedItem.Text;
_dtMaster = _objbll.Load_Doc_review_log(_objcls, _objdb);
//if(!_dtMaster.Columns.Contains("Closeout_Date"))
// _dtMaster.Columns.Add("Closeout_Date");
_dtresult = _dtMaster;
}
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);
}
void SetDocDuration()
{
if (time.Text == "0")
{
return; //Revised OM Manual
}
BLL_Dml _objbll = new BLL_Dml();
_database _objdb = new _database();
_objdb.DBName = "dbCML";
_clsdocduration _objcls = new _clsdocduration();
//string _Doc_type = drpmanufacture.SelectedItem.Value.Substring(0, drpmanufacture.SelectedItem.Value.IndexOf("_T"));
string _Doc_type = (string)Session["folder"];
_objcls.Folder_id = Convert.ToInt32(_Doc_type);
_objcls.Duration = Convert.ToInt32(time.Text);
_objcls.First = Convert.ToInt32(remind1.Text);
_objcls.Second = Convert.ToInt32(remind2.Text);
_objcls.Third = Convert.ToInt32(remind3.Text);
_objcls.prj_code = (string)Session["project"];
_objbll.SetDocDuration(_objcls, _objdb);
}
protected void cmdadd_Click(object sender, EventArgs e)
{
if (txtnewmanufacturer.Text == "")
{
return;
}
BLL_Dml _objbal = new BLL_Dml();
_database _objdb = new _database();
_objdb.DBName = "dbCML";
_clsmanufacture _objcls = new _clsmanufacture();
_objcls.project_code = (string)Session["project"];
_objcls.man_name = txtnewmanufacturer.Text;
string _type = (string)Session["type"];
//ScriptManager.RegisterStartupScript(this, typeof(string), "close", "alert('"+ _type +"');", true);
if (_type == "2")
{
_objbal.Create_Manufacture(_objcls, _objdb);
load_manufacturer();
ScriptManager.RegisterStartupScript(this, typeof(string), "close", "alert('Created New Manufacturer!');", true);
}
else if (_type == "1")
{
_objbal.Create_Contractor(_objcls, _objdb);
load_contractor();
ScriptManager.RegisterStartupScript(this, typeof(string), "close", "alert('Created New Contractor!');", true);
}
else
{
_objbal.Create_Manufacture(_objcls, _objdb);
load_manufacturer();
ScriptManager.RegisterStartupScript(this, typeof(string), "close", "alert('Created New Manufacturer!');", true);
}
Panel1.Visible = false;
txtnewmanufacturer.Text = "";
cmdnew.Enabled = true;
}
