protected void ClearAll() { try { LblMsg.Text = ""; HidFldId.Value = ""; DDLClientName.Items.Clear(); DDLClientName.DataSource = BLayer.FillClient(); DDLClientName.DataTextField = "ClientName"; DDLClientName.DataValueField = "ClientId"; DDLClientName.DataBind(); DDLClientName.Items.Insert(0, new ListItem("---Select Client---", "0")); TxtPrjName.Text = ""; TxtStartDate.Text = ""; TxtEndDate.Text = ""; ddlPrjStatus.SelectedIndex = 0; TxtRemark.Text = ""; GridModule.DataSource = null; GridModule.DataBind(); } catch (Exception ex) { Response.Write(ex.ToString()); } }
protected void BtnNew_Click(object sender, EventArgs e) { try { ClearAll(); DDLClientName.Focus(); } catch (Exception ex) { Response.Write(ex.ToString()); } }
protected void DispRecord(string pStrNavigation) { int IntId = 0; StrSql = new StringBuilder(); StrSql.Length = 0; if (pStrNavigation == "EXAC") { IntId = int.Parse(HidFldId.Value); } else if (pStrNavigation.Trim().ToUpper() == "FIRST") { StrSql.AppendLine("Select Top 1 Id From Project_Mast Order By Id"); } else if (pStrNavigation.Trim().ToUpper() == "NEXT") { if (HidFldId.Value == "") { LblMsg.Text = "Data not found"; return; } StrSql.AppendLine("Select Top 1 Id From Project_Mast Where Id > " + int.Parse(HidFldId.Value)); } else if (pStrNavigation.Trim().ToUpper() == "PREV") { if (HidFldId.Value == "") { LblMsg.Text = "Data not found"; return; } StrSql.AppendLine("Select Top 1 Id From Project_Mast Where Id < " + int.Parse(HidFldId.Value) + " Order By Id Desc"); } else if (pStrNavigation.Trim().ToUpper() == "LAST") { StrSql.AppendLine("Select Top 1 Id From Project_Mast Order By Id Desc"); } if (pStrNavigation != "EXAC") { dtTemp = new DataTable(); dtTemp = SqlFunc.ExecuteDataTable(StrSql.ToString()); if (dtTemp.Rows.Count != 0) { IntId = int.Parse(dtTemp.Rows[0]["Id"].ToString()); } } StrSql = new StringBuilder(); StrSql.Length = 0; StrSql.AppendLine("Select P.Id,P.ClientId,P.ProjectName"); StrSql.AppendLine(",Convert(Varchar(10),P.StartDate,103) As StartDate"); StrSql.AppendLine(",Convert(Varchar(10),P.EndDate,103) As EndDate"); StrSql.AppendLine(",P.ProjctStatus"); StrSql.AppendLine(",P.Remark"); StrSql.AppendLine("From Project_Mast P"); StrSql.AppendLine("Where P.Id=" + IntId); dtTemp = new DataTable(); dtTemp = SqlFunc.ExecuteDataTable(StrSql.ToString()); if (dtTemp.Rows.Count == 0) { ClearAll(); LblMsg.Text = "Data not found"; return; } LblMsg.Text = ""; HidFldId.Value = IntId.ToString(); DDLClientName.Items.Clear(); DDLClientName.DataSource = BLayer.FillClient(); DDLClientName.DataTextField = "ClientName"; DDLClientName.DataValueField = "ClientId"; DDLClientName.DataBind(); DDLClientName.Items.Insert(0, new ListItem("--Select Client--", "0")); if (dtTemp.Rows[0]["ClientId"].ToString() != "") { DDLClientName.SelectedValue = dtTemp.Rows[0]["ClientId"].ToString(); } TxtPrjName.Text = dtTemp.Rows[0]["ProjectName"].ToString(); TxtStartDate.Text = dtTemp.Rows[0]["StartDate"].ToString(); TxtEndDate.Text = dtTemp.Rows[0]["EndDate"].ToString(); if (dtTemp.Rows[0]["ProjctStatus"].ToString() != "") { ddlPrjStatus.SelectedValue = dtTemp.Rows[0]["ProjctStatus"].ToString(); } else { ddlPrjStatus.SelectedIndex = 0; } TxtRemark.Text = dtTemp.Rows[0]["Remark"].ToString(); FillModuleData(); }
protected void btnPrjSelect_Click(object sender, ImageClickEventArgs e) { try { ImageButton btndetails = sender as ImageButton; GridViewRow gvrow = (GridViewRow)btndetails.NamingContainer; Session["Id"] = GridPrj.DataKeys[gvrow.RowIndex].Value.ToString(); HidFldId.Value = Session["Id"].ToString(); StrSql = new StringBuilder(); StrSql.Length = 0; StrSql.AppendLine("Select P.Id,P.ClientId,P.ProjectName"); StrSql.AppendLine(",Convert(Varchar(10),P.StartDate,103) As StartDate"); StrSql.AppendLine(",Convert(Varchar(10),P.EndDate,103) As EndDate"); StrSql.AppendLine(",P.ProjctStatus"); StrSql.AppendLine(",P.Remark"); StrSql.AppendLine("From Project_Mast P"); StrSql.AppendLine("Where P.Id=" + int.Parse(HidFldId.Value)); dtTemp = new DataTable(); dtTemp = SqlFunc.ExecuteDataTable(StrSql.ToString()); if (dtTemp.Rows.Count == 0) { LblMsg.Text = "Data not found"; return; } DDLClientName.Items.Clear(); DDLClientName.DataSource = BLayer.FillClient(); DDLClientName.DataTextField = "ClientName"; DDLClientName.DataValueField = "ClientId"; DDLClientName.DataBind(); DDLClientName.Items.Insert(0, new ListItem("--Select Client--", "0")); if (dtTemp.Rows[0]["ClientId"].ToString() != "") { DDLClientName.SelectedValue = dtTemp.Rows[0]["ClientId"].ToString(); } TxtPrjName.Text = dtTemp.Rows[0]["ProjectName"].ToString(); TxtStartDate.Text = dtTemp.Rows[0]["StartDate"].ToString(); TxtEndDate.Text = dtTemp.Rows[0]["EndDate"].ToString(); if (dtTemp.Rows[0]["ProjctStatus"].ToString() != "") { ddlPrjStatus.SelectedValue = dtTemp.Rows[0]["ProjctStatus"].ToString(); } else { ddlPrjStatus.SelectedIndex = 0; } TxtRemark.Text = dtTemp.Rows[0]["Remark"].ToString(); FillModuleData(); //Move to Edit Tab MyMenu.Items[0].ImageUrl = "~/Images/ViewDisable.jpg"; MyMenu.Items[1].ImageUrl = "~/Images/NewOrEditEnable.jpg"; MyMenu.Items[1].Selected = true; MyMultiView.ActiveViewIndex = 1; } catch (Exception ex) { Response.Write(ex.ToString()); } }
protected void BtnSave_Click(object sender, EventArgs e) { try { if (DDLClientName.SelectedValue == "0") { //LblMsg.Text = "Select Client..."; DDLClientName.Focus(); return; } if (TxtPrjName.Text.Length == 0) { //LblMsg.Text = "Enter Project Name..."; TxtPrjName.Focus(); return; } StrSql = new StringBuilder(); StrSql.Length = 0; if (HidFldId.Value.Length == 0) { StrSql.AppendLine("Insert Into Project_Mast"); StrSql.AppendLine("(ClientId,ProjectName"); StrSql.AppendLine(",StartDate,EndDate"); StrSql.AppendLine(",ProjctStatus,Remark"); StrSql.AppendLine(",Entry_Date,Entry_Time"); StrSql.AppendLine(",Entry_UID,UPDFLAG)"); StrSql.AppendLine("Values"); StrSql.AppendLine("(@ClientId,@ProjectName"); StrSql.AppendLine(",@StartDate,@EndDate"); StrSql.AppendLine(",@ProjctStatus,@Remark"); StrSql.AppendLine(",GetDate(),CONVERT(Varchar,GETDATE(),108)"); StrSql.AppendLine(",@Entry_UID,0)"); } else { StrSql.AppendLine("Update Project_Mast"); StrSql.AppendLine("Set ClientId=@ClientId"); StrSql.AppendLine(",ProjectName=@ProjectName"); StrSql.AppendLine(",StartDate=@StartDate"); StrSql.AppendLine(",EndDate=@EndDate"); StrSql.AppendLine(",ProjctStatus=@ProjctStatus"); StrSql.AppendLine(",Remark=@Remark"); StrSql.AppendLine(",UPDFLAG=ISNULL(UPDFLAG,0)+1"); StrSql.AppendLine(",MEntry_Date=GETDATE()"); StrSql.AppendLine(",MEntry_Time=CONVERT(Varchar,GETDATE(),108)"); StrSql.AppendLine(",MEntry_UID=@Entry_UId"); StrSql.AppendLine("Where Id=@Id"); } Cmd = new SqlCommand(StrSql.ToString(), SqlFunc.gConn); if (DDLClientName.SelectedValue != "0") { Cmd.Parameters.AddWithValue("@ClientId", DDLClientName.SelectedValue); } else { Cmd.Parameters.AddWithValue("@ClientId", DBNull.Value); } Cmd.Parameters.AddWithValue("@ProjectName", TxtPrjName.Text); if (TxtStartDate.Text.Length != 0) { Cmd.Parameters.AddWithValue("@StartDate", ValueConvert.ConvertDate(TxtStartDate.Text)); } else { Cmd.Parameters.AddWithValue("@StartDate", DBNull.Value); } if (TxtEndDate.Text.Length != 0) { Cmd.Parameters.AddWithValue("@EndDate", ValueConvert.ConvertDate(TxtEndDate.Text)); } else { Cmd.Parameters.AddWithValue("@EndDate", DBNull.Value); } if (ddlPrjStatus.SelectedValue != "0") { Cmd.Parameters.AddWithValue("@ProjctStatus", ddlPrjStatus.SelectedValue); } else { Cmd.Parameters.AddWithValue("@ProjctStatus", DBNull.Value); } Cmd.Parameters.AddWithValue("@Remark", TxtRemark.Text); Cmd.Parameters.AddWithValue("@Entry_UID", HidFldUID.Value.ToString()); if (HidFldId.Value.Length == 0) { SqlFunc.ExecuteNonQuery(Cmd); LblMsg.Text = "Entry insert successfully..."; } else { Cmd.Parameters.AddWithValue("@Id", int.Parse(HidFldId.Value)); SqlFunc.ExecuteNonQuery(Cmd); LblMsg.Text = "Entry update successfully..."; } FillGrid(); ClearAll(); MyMenu.Items[0].Selected = true; MyMenu.Items[0].ImageUrl = "~/Images/ViewEnable.jpg"; MyMenu.Items[1].ImageUrl = "~/Images/NewOrEditDisable.jpg"; MyMultiView.ActiveViewIndex = 0; } catch (Exception ex) { Response.Write(ex.ToString()); } }