/// <summary>
/// To Get Line Type
/// </summary>
/// <returns></returns>
public TypeOfLineLists GetLineType()
{
OracleConnection conn = new OracleConnection(connStr);
OracleCommand cmd;
string proc = " USP_MST_GET_LINETYPE";
cmd = new OracleCommand(proc, conn);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.Add("Sp_recordset", OracleDbType.RefCursor).Direction = ParameterDirection.Output;
cmd.Connection.Open();
OracleDataReader dr = cmd.ExecuteReader(CommandBehavior.CloseConnection);
TypeOfLineLists TypeOfLines = new TypeOfLineLists();
TypeOfLineBO TypeOfLineBOobj = null;
while (dr.Read())
{
TypeOfLineBOobj = new TypeOfLineBO();
TypeOfLineBOobj.LineTypeId = Convert.ToInt32(dr.GetValue(dr.GetOrdinal("LINETYPEID")));
TypeOfLineBOobj.TypeOfLine = dr.GetString(dr.GetOrdinal("TYPEOFLINE"));
TypeOfLineBOobj.Rightofwaymeasurement = dr.GetString(dr.GetOrdinal("RIGHTOFWAYMEASUREMENT"));
TypeOfLineBOobj.Wayleavemeasurement = dr.GetString(dr.GetOrdinal("WAYLEAVEMEASUREMENT"));
TypeOfLineBOobj.IsDeleted = dr.GetString(dr.GetOrdinal("ISDELETED"));
TypeOfLines.Add(TypeOfLineBOobj);
}
dr.Close();
return(TypeOfLines);
}
//protected void BindBankBranchess(int bankID)
//{
// ListItem firstListItem = new ListItem(ddlBranch.Items[0].Text, ddlBranch.Items[0].Value);
// ddlBranch.Items.Clear();
// if (bankID > 0)
// {
// BranchBLL objBranchBLL = new BranchBLL();
// ddlBranch.DataSource = objBranchBLL.GetActiveBranches(bankID);
// ddlBranch.DataTextField = "BRANCHNAME";
// ddlBranch.DataValueField = "BankBranchId";
// ddlBranch.DataBind();
// }
// ddlBranch.Items.Insert(0, firstListItem);
// ddlBranch.SelectedIndex = 0;
//}
#endregion
#region Events
/// <summary>
/// To change values in dropdownlist based on index
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
protected void ddlTypeLine_SelectedIndexChanged(object sender, EventArgs e)
{
//Call the By Line ID
TypeOfLineBO oTypeOfLine = new TypeOfLineBO();
TypeOfLineBLL oTypeOfLineBLL = new TypeOfLineBLL();
oTypeOfLine = oTypeOfLineBLL.GetLineTypebyID(Convert.ToInt32(ddlTypeLine.SelectedValue.ToString()));
lblRightofWayMeasurement.Text = oTypeOfLine.Rightofwaymeasurement;
lblWayLeaveMeasurement.Text = oTypeOfLine.Wayleavemeasurement;
}
/// <summary>
/// Save and Update Data into Database
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
protected void btnSave_Click(object sender, EventArgs e)
{
string message = "";
if (Convert.ToInt32(ViewState["LineTypeId"]) > 0)
{
string uID = Session["USER_ID"].ToString();
int LineTypeID = Convert.ToInt32(ViewState["LineTypeId"]);
TypeOfLineBOObj = new TypeOfLineBO();
TypeOfLineBOObj.TypeOfLine = txtLineType.Text.ToString();
TypeOfLineBOObj.Wayleavemeasurement = txtWayleave.Text.ToString();
TypeOfLineBOObj.Rightofwaymeasurement = txtRightOfWay.Text.ToString();
TypeOfLineBOObj.Createdby = Convert.ToInt32(uID);
TypeOfLineBLLObj = new TypeOfLineBLL();
message = TypeOfLineBLLObj.Update(TypeOfLineBOObj, LineTypeID);
if (string.IsNullOrEmpty(message) || message == "" || message == "null")
{
message = "Data updated successfully";
}
SetUpdateMode(false);
}
else
{
string uID = Session["USER_ID"].ToString();
TypeOfLineBOObj = new TypeOfLineBO();
TypeOfLineBOObj.Createdby = Convert.ToInt32(uID);
TypeOfLineBOObj.Rightofwaymeasurement = txtRightOfWay.Text.ToString();
TypeOfLineBOObj.TypeOfLine = txtLineType.Text.ToString();
TypeOfLineBOObj.Wayleavemeasurement = txtWayleave.Text.ToString();
TypeOfLineBLLObj = new TypeOfLineBLL();
message = TypeOfLineBLLObj.insert(TypeOfLineBOObj);
if (string.IsNullOrEmpty(message) || message == "" || message == "null")
{
message = "Data saved successfully";
}
}
if (message != "")
{
ScriptManager.RegisterClientScriptBlock(this, this.GetType(), "Added", "alert('" + message + "');", true);
}
BindGrid(-1);
clearfields();
}
public static TypeOfLineBO GetTypeOfLineDetails(int segmentID)
{
ProjectBLL objProjectBLL = new ProjectBLL();
SegmentBO objSegment = objProjectBLL.GetProjectSegmentByID(segmentID);
TypeOfLineBO objTypeOfLine = null;
if (objSegment != null)
{
TypeOfLineBLL objTypeOfLineBLL = new TypeOfLineBLL();
objTypeOfLine = objTypeOfLineBLL.GetLineTypebyID(objSegment.LineTypeID);
}
return(objTypeOfLine);
}
/// <summary>
/// To Insert into Database
/// </summary>
/// <param name="TypeOfLineBOObj"></param>
/// <returns></returns>
public string insert(TypeOfLineBO TypeOfLineBOObj)
{
try
{
TypeOfLineDAL TypeOfLineDALObj = new TypeOfLineDAL();
return(TypeOfLineDALObj.Insert(TypeOfLineBOObj));
}
catch (Exception ex)
{
throw ex;
}
finally
{
}
}
/// <summary>
/// to get the Type of Line in Deatails
/// </summary>
/// <param name="segmentID"></param>
private void LoadTypeOfLineDetails(int segmentID)
{
TypeOfLineBO objTypeOfLineBO = GetTypeOfLineDetails(segmentID);
if (objTypeOfLineBO != null)
{
lblTypeOfLine.Text = objTypeOfLineBO.TypeOfLine + " kV";
lblRightOfWay.Text = objTypeOfLineBO.Rightofwaymeasurement + " Metres";
lblWayleave.Text = objTypeOfLineBO.Wayleavemeasurement + " Metres";
}
else
{
lblTypeOfLine.Text = "";
lblRightOfWay.Text = "";
lblWayleave.Text = "";
}
}
/// <summary>
/// To Update
/// </summary>
/// <param name="TypeOfLineBOObj"></param>
/// <param name="LineTypeID"></param>
/// <returns></returns>
public string Update(TypeOfLineBO TypeOfLineBOObj, int LineTypeID)
{
TypeOfLineDAL TypeOfLineDALObj = new TypeOfLineDAL();
try
{
return(TypeOfLineDALObj.Update(TypeOfLineBOObj, LineTypeID));
}
catch (Exception ex)
{
throw ex;
}
finally
{
TypeOfLineDALObj = null;
}
}
/// <summary>
/// Get the line type details.
/// </summary>
private void GetLineTypeDetails()
{
TypeOfLineBLLObj = new TypeOfLineBLL();
int LineTypeID = 0;
if (ViewState["LineTypeId"] != null)
{
LineTypeID = Convert.ToInt32(ViewState["LineTypeId"]);
}
TypeOfLineBOObj = new TypeOfLineBO();
TypeOfLineBOObj = TypeOfLineBLLObj.GetLineTypebyID(LineTypeID);
txtLineType.Text = TypeOfLineBOObj.TypeOfLine;
txtRightOfWay.Text = TypeOfLineBOObj.Rightofwaymeasurement;
txtWayleave.Text = TypeOfLineBOObj.Wayleavemeasurement;
ConcernIDTextBox.Text = TypeOfLineBOObj.LineTypeId.ToString();
}
/// <summary>
/// To Insert into Database
/// </summary>
/// <param name="TypeOfLineBOobj"></param>
/// <returns></returns>
public string Insert(TypeOfLineBO TypeOfLineBOobj)
{
string returnResult = "";
OracleConnection con = new OracleConnection(connStr);
con.Open();
OracleCommand dcmd = new OracleCommand("USP_MST_INST_LINETYPE", con);
dcmd.CommandType = CommandType.StoredProcedure;
int count = Convert.ToInt32(dcmd.CommandType);
try
{
dcmd.Parameters.Add("p_TYPEOFLINE", TypeOfLineBOobj.TypeOfLine);
dcmd.Parameters.Add("p_WAYLEAVEMEASUREMENT", TypeOfLineBOobj.Wayleavemeasurement);
dcmd.Parameters.Add("p_RIGHTOFWAYMEASUREMENT", TypeOfLineBOobj.Rightofwaymeasurement);
dcmd.Parameters.Add("p_CREATEDBY", TypeOfLineBOobj.Createdby);
dcmd.Parameters.Add("errorMessage_", OracleDbType.Varchar2, 500).Direction = ParameterDirection.Output;
dcmd.ExecuteNonQuery();
if (dcmd.Parameters["errorMessage_"].Value != null)
{
returnResult = dcmd.Parameters["errorMessage_"].Value.ToString();
}
return(returnResult);
}
catch (Exception ex)
{
throw ex;;
}
finally
{
dcmd.Dispose();
con.Close();
con.Dispose();
}
}
/// <summary>
/// To Update
/// </summary>
/// <param name="TypeOfLineBOobj"></param>
/// <param name="LineTypeID"></param>
/// <returns></returns>
public string Update(TypeOfLineBO TypeOfLineBOobj, int LineTypeID)
{
OracleConnection conn = new OracleConnection(connStr);
conn.Open();
OracleCommand dCmd = new OracleCommand("USP_MST_UPD_LINE_TYPE", conn);
dCmd.CommandType = CommandType.StoredProcedure;
string result = "";
try
{
dCmd.Parameters.Add("p_LINETYPEID", LineTypeID);
dCmd.Parameters.Add("p_TYPEOFLINE", TypeOfLineBOobj.TypeOfLine);
dCmd.Parameters.Add("p_WAYLEAVEMEASUREMENT", TypeOfLineBOobj.Wayleavemeasurement);
dCmd.Parameters.Add("p_RIGHTOFWAYMEASUREMENT", TypeOfLineBOobj.Rightofwaymeasurement);
dCmd.Parameters.Add("p_UPDATEDBY", TypeOfLineBOobj.Createdby);
dCmd.Parameters.Add("errorMessage_", OracleDbType.Varchar2, 500).Direction = ParameterDirection.Output;
dCmd.ExecuteNonQuery();
if (dCmd.Parameters["errorMessage_"].Value != null)
{
result = dCmd.Parameters["errorMessage_"].Value.ToString();
}
}
catch (Exception ex)
{
throw ex;
}
finally
{
dCmd.Dispose();
conn.Close();
conn.Dispose();
}
return(result);
}
