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