/// <summary> /// Function to insert values to Route Table /// </summary> /// <param name="routeinfo"></param> public void RouteAdd(RouteInfo routeinfo) { try { if (sqlcon.State == ConnectionState.Closed) { sqlcon.Open(); } SqlCommand sccmd = new SqlCommand("RouteAdd", sqlcon); sccmd.CommandType = CommandType.StoredProcedure; SqlParameter sprmparam = new SqlParameter(); sprmparam = sccmd.Parameters.Add("@routeName", SqlDbType.VarChar); sprmparam.Value = routeinfo.RouteName; sprmparam = sccmd.Parameters.Add("@areaId", SqlDbType.Decimal); sprmparam.Value = routeinfo.AreaId; sprmparam = sccmd.Parameters.Add("@narration", SqlDbType.VarChar); sprmparam.Value = routeinfo.Narration; sprmparam = sccmd.Parameters.Add("@extraDate", SqlDbType.DateTime); sprmparam.Value = routeinfo.ExtraDate; sprmparam = sccmd.Parameters.Add("@extra1", SqlDbType.VarChar); sprmparam.Value = routeinfo.Extra1; sprmparam = sccmd.Parameters.Add("@extra2", SqlDbType.VarChar); sprmparam.Value = routeinfo.Extra2; sccmd.ExecuteNonQuery(); } catch (Exception ex) { MessageBox.Show(ex.ToString()); } finally { sqlcon.Close(); } }
/// <summary> /// Function to insert values to Route Table /// </summary> /// <param name="routeinfo"></param> public void RouteAdd(RouteInfo routeinfo) { try { spRoute.RouteAdd(routeinfo); } catch (Exception ex) { MessageBox.Show("RT2:" + ex.Message, "OpenMiracle", MessageBoxButtons.OK, MessageBoxIcon.Information); } }
/// <summary> /// Function to insert values to Route Table /// </summary> /// <param name="routeinfo"></param> /// <returns></returns> public decimal RouteAddParticularFields(RouteInfo routeinfo) { decimal decAreaId = 0; try { decAreaId = spRoute.RouteAddParticularFields(routeinfo); } catch (Exception ex) { MessageBox.Show("RT10:" + ex.Message, "OpenMiracle", MessageBoxButtons.OK, MessageBoxIcon.Information); } return decAreaId; }
/// <summary> /// Function to get particular values from Route table based on the parameter /// </summary> /// <param name="routeId"></param> /// <returns></returns> public RouteInfo RouteView(decimal routeId) { RouteInfo routeinfo = new RouteInfo(); try { routeinfo = spRoute.RouteView(routeId); } catch (Exception ex) { MessageBox.Show("RT9:" + ex.Message, "OpenMiracle", MessageBoxButtons.OK, MessageBoxIcon.Information); } return routeinfo; }
/// <summary> /// Function to Update values in Route Table /// </summary> /// <param name="routeinfo"></param> /// <returns></returns> public bool RouteEditing(RouteInfo routeinfo) { bool isEdit = false; try { isEdit = spRoute.RouteEditing(routeinfo); } catch (Exception ex) { MessageBox.Show("RT7:" + ex.Message, "OpenMiracle", MessageBoxButtons.OK, MessageBoxIcon.Information); } return isEdit; }
/// <summary> /// Function to get particular values from Route table based on the parameter /// </summary> /// <param name="routeId"></param> /// <returns></returns> public RouteInfo RouteView(decimal routeId) { RouteInfo routeinfo = new RouteInfo(); SqlDataReader sdrreader = null; try { if (sqlcon.State == ConnectionState.Closed) { sqlcon.Open(); } SqlCommand sccmd = new SqlCommand("RouteView", sqlcon); sccmd.CommandType = CommandType.StoredProcedure; SqlParameter sprmparam = new SqlParameter(); sprmparam = sccmd.Parameters.Add("@routeId", SqlDbType.Decimal); sprmparam.Value = routeId; sdrreader = sccmd.ExecuteReader(); while (sdrreader.Read()) { routeinfo.RouteId = decimal.Parse(sdrreader[0].ToString()); routeinfo.RouteName = sdrreader[1].ToString(); routeinfo.AreaId = decimal.Parse(sdrreader[2].ToString()); routeinfo.Narration = sdrreader[3].ToString(); routeinfo.ExtraDate = DateTime.Parse(sdrreader[4].ToString()); routeinfo.Extra1 = sdrreader[5].ToString(); routeinfo.Extra2 = sdrreader[6].ToString(); } } catch (Exception ex) { MessageBox.Show(ex.ToString()); } finally { sdrreader.Close(); sqlcon.Close(); } return routeinfo; }
/// <summary> /// Function to Update values in Route Table /// </summary> /// <param name="routeinfo"></param> /// <returns></returns> public bool RouteEditing(RouteInfo routeinfo) { bool isEdit = false; try { if (sqlcon.State == ConnectionState.Closed) { sqlcon.Open(); } SqlCommand sccmd = new SqlCommand("RouteEditing", sqlcon); sccmd.CommandType = CommandType.StoredProcedure; SqlParameter sprmparam = new SqlParameter(); sprmparam = sccmd.Parameters.Add("@routeId", SqlDbType.Decimal); sprmparam.Value = routeinfo.RouteId; sprmparam = sccmd.Parameters.Add("@routeName", SqlDbType.VarChar); sprmparam.Value = routeinfo.RouteName; sprmparam = sccmd.Parameters.Add("@areaId", SqlDbType.Decimal); sprmparam.Value = routeinfo.AreaId; sprmparam = sccmd.Parameters.Add("@narration", SqlDbType.VarChar); sprmparam.Value = routeinfo.Narration; sprmparam = sccmd.Parameters.Add("@extra1", SqlDbType.VarChar); sprmparam.Value = routeinfo.Extra1; sprmparam = sccmd.Parameters.Add("@extra2", SqlDbType.VarChar); sprmparam.Value = routeinfo.Extra2; int ina = sccmd.ExecuteNonQuery(); if (ina > 0) { isEdit = true; } else { isEdit = false; } } catch (Exception ex) { MessageBox.Show(ex.ToString()); } finally { sqlcon.Close(); } return isEdit; }
/// <summary> /// Function to insert values to Route Table /// </summary> /// <param name="routeinfo"></param> /// <returns></returns> public decimal RouteAddParticularFields(RouteInfo routeinfo) { decimal decAreaId = 0; try { if (sqlcon.State == ConnectionState.Closed) { sqlcon.Open(); } SqlCommand sccmd = new SqlCommand("RouteAddParticularFields", sqlcon); sccmd.CommandType = CommandType.StoredProcedure; SqlParameter sprmparam = new SqlParameter(); sprmparam = sccmd.Parameters.Add("@routeName", SqlDbType.VarChar); sprmparam.Value = routeinfo.RouteName; sprmparam = sccmd.Parameters.Add("@areaId", SqlDbType.Decimal); sprmparam.Value = routeinfo.AreaId; sprmparam = sccmd.Parameters.Add("@narration", SqlDbType.VarChar); sprmparam.Value = routeinfo.Narration; sprmparam = sccmd.Parameters.Add("@extra1", SqlDbType.VarChar); sprmparam.Value = routeinfo.Extra1; sprmparam = sccmd.Parameters.Add("@extra2", SqlDbType.VarChar); sprmparam.Value = routeinfo.Extra2; object objRouteId = sccmd.ExecuteScalar(); if (objRouteId != null) { decAreaId = decimal.Parse(objRouteId.ToString()); } else { decAreaId = 0; } } catch (Exception ex) { MessageBox.Show(ex.ToString()); } finally { sqlcon.Close(); } return decAreaId; }