protected void Addartifact_Click(object sender, EventArgs e) { bool inset = false; Addartifact addArtifact = new Addartifact(); addArtifact.artNum = txtArtNum.Text.ToString(); addArtifact.artName = txtArtName.Text.ToString(); addArtifact.toolid = Convert.ToInt32(lbltoolid.Text); addArtifact.createdby = Convert.ToInt32(lbluserid.Text); addArtifact.desc = txtArtdesc.Text.ToString(); addArtifact.esthour = Convert.ToInt32(txtEsthour.Text); user = DstumDAL.getUserdetails(Context.User.Identity.Name); try { inset = DstumDAL.insertArtifact(addArtifact, user.userid); } catch (Exception ex) { } if (inset == true) { Response.Write(@"<script language='javascript'>window.alert('Artifact Added successfully \n .');window.location='Default.aspx';</script>"); // Response.Write(@"<script language='javascript'>alert('Artifact Added successfully \n .');</script>"); // Response.Redirect("~/Default.aspx"); // UpdatePanel1.Update(); } else { Response.Write(@"<script language='javascript'>alert('some error is occurs \n .');</script>"); } }
protected void GridView1_RowDataBound(object sender, GridViewRowEventArgs e) { if (e.Row.RowType == DataControlRowType.DataRow) { if ((e.Row.RowState & DataControlRowState.Edit) > 0) { DropDownList ddList = (DropDownList)e.Row.FindControl("ddlartname"); //bind dropdown-list // DropDownList ddlrole1 = (DropDownList)e.Row.FindControl("ddlrole1"); Label dr = (Label)e.Row.FindControl("lblaid12"); if (dr.Text.ToString().Equals("")) { String sCommand1_subbu1 = "select 'Meeting/KT/Other' as ArtifactName ,'-1' as aid"; using (SqlDataAdapter adapterSubbu1 = new SqlDataAdapter(sCommand1_subbu1, connString1)) { DataSet ds = new DataSet(); adapterSubbu1.Fill(ds); ddList.DataSource = ds; ddList.DataTextField = "ArtifactName"; ddList.DataValueField = "AID"; ddList.DataBind(); conn.Close(); ddList.SelectedValue = dr.Text.ToString(); } } else { User user2 = DstumDAL.getUserdetails(Context.User.Identity.Name); String sCommand1_subbu1 = "select * from artifact where createdfor=@userid"; // DataTable dataSubbu1 = new DataTable(); using (SqlDataAdapter adapterSubbu1 = new SqlDataAdapter(sCommand1_subbu1, connString1)) { adapterSubbu1.SelectCommand.Parameters.AddWithValue("@userid", user2.userid); DataSet ds = new DataSet(); adapterSubbu1.Fill(ds); ddList.DataSource = ds; ddList.DataTextField = "ArtifactName"; ddList.DataValueField = "AID"; ddList.DataBind(); conn.Close(); ddList.SelectedValue = dr.Text.ToString(); } } } } }
protected void Page_Load(object sender, EventArgs e) { if (!IsPostBack) { user = DstumDAL.getUserdetails(Context.User.Identity.Name); Tools tools = DstumDAL.getToolDetails(user.toolid); lblusername.Text = user.username; lbluserid.Text = user.userid.ToString(); lbltoolid.Text = user.toolid.ToString(); lblToolName.Text = tools.toolname; DataBindGrid(); } }
private void DataBindGrid() { user = DstumDAL.getUserdetails(Context.User.Identity.Name); String sCommand1_subbu1 = " select ar.*,est_hour-lock_hour as remhour,tr.toolname from artifact ar inner join tools tr on ar.toolid=tr.toolID where createdfor= @userid and status='In Progress' or status= 'pending'"; // DataTable dataSubbu1 = new DataTable(); SqlDataAdapter adapterSubbu1 = new SqlDataAdapter(sCommand1_subbu1, connString1); adapterSubbu1.SelectCommand.Parameters.AddWithValue("@userid", user.userid); DataSet ds = new DataSet(); adapterSubbu1.Fill(ds); GridView1.DataSource = ds; GridView1.DataBind(); }
private void DataBindGrid() { user = DstumDAL.getUserdetails(Context.User.Identity.Name); String sCommand1_subbu1 = "select ds.DID, replace(convert(NVARCHAR, ds.todaydate, 106), ' ', '/') todaydate, ds.userid, ds.aid, ds.Todayhour, ds.yesterdayhour, ds.[desc], us.Name, CASE WHEN Cast(ar.[ArtifactName] AS varchar) is null THEN 'Meeting/KT/Other' ELSE Cast(ar.[ArtifactName] AS varchar) END AS ArtifactName, CASE WHEN Cast(ar.est_hour AS varchar) is null THEN 0 ELSE Cast(ar.est_hour AS varchar) END AS est_hour, CASE WHEN Cast(ar.est_hour AS varchar) is null THEN 0 ELSE Cast(ar.est_hour-ar.lock_hour AS varchar) END AS remhour, ar.status from dstum ds left outer join [user] us on ds.userid = us.userid left outer join artifact ar on ar.AID=ds.AID where us.userID=@userid"; // DataTable dataSubbu1 = new DataTable(); using (SqlDataAdapter adapterSubbu1 = new SqlDataAdapter(sCommand1_subbu1, connString1)) { adapterSubbu1.SelectCommand.Parameters.AddWithValue("@userid", user.userid); DataSet ds = new DataSet(); adapterSubbu1.Fill(ds); GridView1.DataSource = ds; GridView1.DataBind(); conn.Close(); } }
protected void Page_Load(object sender, EventArgs e) { bool isuser = DstumDAL.isUserExist(Context.User.Identity.Name); if (!isuser) { Response.Redirect("~/ContactToAdmin.aspx"); } else { user = DstumDAL.getUserdetails(Context.User.Identity.Name); if (user.role.ToString().Equals("User")) { divbutton.Visible = false; } } if (!IsPostBack) { toolDropdownbind(); DataBindGrid(); } }
public void toolDropdownbind() { User user1 = DstumDAL.getUserdetails(Context.User.Identity.Name); String sCommand1_subbu1 = "select ar.AID,ar.ArtifactName from artifact ar where createdfor=@userid "; sCommand1_subbu1 += " union select '-1' as aid, 'Meeting/KT/Other' as ArtifactName "; // DataTable dataSubbu1 = new DataTable(); SqlDataAdapter adapterSubbu1 = new SqlDataAdapter(sCommand1_subbu1, connString1); adapterSubbu1.SelectCommand.Parameters.AddWithValue("@userid", user1.userid); DataSet ds = new DataSet(); adapterSubbu1.Fill(ds); ddlairtifact.DataSource = ds; ddlairtifact.DataTextField = "ArtifactName"; ddlairtifact.DataValueField = "AID"; ddlairtifact.DataBind(); conn.Close(); }
protected void btnLockHour_Click(object sender, EventArgs e) { bool inset = false; DSTUM dstum = new DSTUM(); User user1 = DstumDAL.getUserdetails(Context.User.Identity.Name); dstum.userid = user1.userid; dstum.Todaydate = DateTime.Now.ToString("yyyy/MM/dd");; dstum.aid = Convert.ToInt32(ddlairtifact.SelectedValue.ToString()); dstum.Todayhour = Convert.ToInt32(txttodayhour.Text.ToString()); dstum.yesterdayHour = Convert.ToInt32(txtYesterdayhour.Text.ToString()); dstum.desc = txtdesc.Text.ToString(); try { inset = DstumDAL.lockHour(dstum); } catch (Exception ex) { } if (inset == true) { Response.Write(@"<script language='javascript'>window.alert('Lock Your hour successfully \n ');</script>"); txtdesc.Text = ""; txttodayhour.Text = ""; txtYesterdayhour.Text = ""; DataBindGrid(); } else { Response.Write(@"<script language='javascript'>alert('some error is occurs \n ');</script>"); } }