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