public static int Insert(driverdetails dt) { string query = "INSERT INTO driverdetails VALUES(@driverid, @drivername,@age, @mobileno, @address,@licanceno,@vehicleno,@residenceno,@familyno,@relation,@bgroup,@bankname,@branchname,@acno,@ifsccode,@isactive)"; List <SqlParameter> parameters = new List <SqlParameter>(); // parameters.Add(new SqlParameter("@Cid", dt.id)); parameters.Add(new SqlParameter("@driverid", dt.driverid)); parameters.Add(new SqlParameter("@drivername", dt.drivername)); parameters.Add(new SqlParameter("@age", dt.age)); parameters.Add(new SqlParameter("@mobileno", dt.mobileno)); parameters.Add(new SqlParameter("@address", dt.address)); parameters.Add(new SqlParameter("@licanceno", dt.licanceno)); parameters.Add(new SqlParameter("@vehicleno", dt.vehicleno)); parameters.Add(new SqlParameter("@residenceno", dt.residenceno)); parameters.Add(new SqlParameter("@familyno", dt.familyno)); parameters.Add(new SqlParameter("@relation", dt.relation)); parameters.Add(new SqlParameter("@bgroup", dt.bgroup)); parameters.Add(new SqlParameter("@bankname", dt.bankname)); parameters.Add(new SqlParameter("@branchname", dt.branchname)); parameters.Add(new SqlParameter("@acno", dt.acno)); parameters.Add(new SqlParameter("@ifsccode", dt.ifsccode)); parameters.Add(new SqlParameter("@isactive", dt.isactive)); return(DBHelper.ModifyData(query, parameters)); }
public static int Update(driverdetails dt) { string query = "UPDATE driverdetails SET drivername = @drivername,age = @age,mobileno = @mobileno,address = @address,licanceno = @licanceno,vehicleno = @vehicleno,residenceno = @residenceno,familyno = @familyno,relation = @relation,bgroup = @bgroup,bankname = @bankname,acno = @acno,ifsccode = @ifsccode,isactive = @isactive WHERE id = @ID"; List <SqlParameter> parameters = new List <SqlParameter>(); // parameters.Add(new SqlParameter("@driverid", dt.driverid)); parameters.Add(new SqlParameter("@id", dt.id)); parameters.Add(new SqlParameter("@drivername", dt.drivername)); parameters.Add(new SqlParameter("@age", dt.age)); parameters.Add(new SqlParameter("@mobileno", dt.mobileno)); parameters.Add(new SqlParameter("@address", dt.address)); parameters.Add(new SqlParameter("@licanceno", dt.licanceno)); parameters.Add(new SqlParameter("@vehicleno", dt.vehicleno)); parameters.Add(new SqlParameter("@residenceno", dt.residenceno)); parameters.Add(new SqlParameter("@familyno", dt.familyno)); parameters.Add(new SqlParameter("@relation", dt.relation)); parameters.Add(new SqlParameter("@bgroup", dt.bgroup)); parameters.Add(new SqlParameter("@bankname", dt.bankname)); parameters.Add(new SqlParameter("@branchname", dt.branchname)); parameters.Add(new SqlParameter("@acno", dt.acno)); parameters.Add(new SqlParameter("@ifsccode", dt.ifsccode)); parameters.Add(new SqlParameter("@isactive", dt.isactive)); return(DBHelper.ModifyData(query, parameters)); }
public ActionResult DriverEditSubmit() { int id = Convert.ToInt32(Request.Params["id"]); driverdetails dd = DriverLogic.SelectByPK(id); //dd.driverid = (Guid) Request.Params["driverid"]; dd.id = Convert.ToInt32(Request.Params["id"]); dd.drivername = Convert.ToString(Request.Params["drivername"]); dd.age = Convert.ToString(Request.Params["age"]); dd.mobileno = Convert.ToString(Request.Params["mobileno"]); dd.address = Convert.ToString(Request.Params["address"]); dd.licanceno = Convert.ToString(Request.Params["licanceno"]); dd.vehicleno = Convert.ToString(Request.Params["vehicleno"]); dd.residenceno = Convert.ToString(Request.Params["residenceno"]); dd.familyno = Convert.ToString(Request.Params["familyno"]); dd.relation = Convert.ToString(Request.Params["relation"]); dd.bgroup = Convert.ToString(Request.Params["bgroup"]); dd.bankname = Convert.ToString(Request.Params["bankname"]); dd.branchname = Convert.ToString(Request.Params["branchname"]); dd.acno = Convert.ToString(Request.Params["acno"]); dd.ifsccode = Convert.ToString(Request.Params["ifsccode"]); dd.isactive = (Request.Params["isactive"] == "1"); DriverLogic.Update(dd); return(RedirectToAction("fetch")); }
public static int Delete(driverdetails c) { string query = "UPDATE Category SET isactive = @isactive WHERE id = @id"; List <SqlParameter> parameters = new List <SqlParameter>(); parameters.Add(new SqlParameter("@isactive", c.isactive)); parameters.Add(new SqlParameter("@id", c.id)); return(DBHelper.ModifyData(query, parameters)); }
public static driverdetails SelectByPK(int ID) { string query = "SELECT * FROM driverdetails WHERE id = @id"; List <SqlParameter> parameters = new List <SqlParameter>(); parameters.Add(new SqlParameter("@id", ID)); DataTable dt = DBHelper.SelectData(query, parameters); driverdetails d = new driverdetails(); if (dt.Rows.Count == 0) { return(d); } else { d.id = ID; d.driverid = (Guid)dt.Rows[0]["driverid"]; d.drivername = dt.Rows[0]["drivername"].ToString(); d.age = dt.Rows[0]["age"].ToString(); d.mobileno = dt.Rows[0]["mobileno"].ToString(); d.address = dt.Rows[0]["address"].ToString(); d.licanceno = dt.Rows[0]["licanceno"].ToString(); d.vehicleno = dt.Rows[0]["vehicleno"].ToString(); d.residenceno = dt.Rows[0]["residenceno"].ToString(); d.familyno = dt.Rows[0]["familyno"].ToString(); d.relation = dt.Rows[0]["relation"].ToString(); d.bgroup = dt.Rows[0]["bgroup"].ToString(); d.bankname = dt.Rows[0]["bankname"].ToString(); d.branchname = dt.Rows[0]["branchname"].ToString(); d.acno = dt.Rows[0]["acno"].ToString(); d.ifsccode = dt.Rows[0]["ifsccode"].ToString(); d.isactive = (bool)dt.Rows[0]["isactive"]; return(d); } }
public DataTable Driver(driverdetails d) { DataTable dt = new DataTable(); LogTraceWriter traceWriter = new LogTraceWriter(); SqlConnection conn = new SqlConnection(); try { traceWriter.Trace(Request, "0", TraceLevel.Info, "{0}", "Driver...."); StringBuilder str = new StringBuilder(); str.Append("@CompanyId" + d.Company + ","); str.Append("@NAme" + d.Name + ","); str.Append("@PAddress" + d.PermanentAddress + ","); str.Append("@PMobNo" + d.Mobilenumber + ","); str.Append("@DriverCode" + d.drivercode + ","); traceWriter.Trace(Request, "0", TraceLevel.Info, "{0}", "Driver Input sent...." + str.ToString()); conn.ConnectionString = ConfigurationManager.ConnectionStrings["btposdb"].ToString(); SqlCommand cmd = new SqlCommand(); cmd.CommandType = CommandType.StoredProcedure; cmd.CommandText = "HVInsUpddriver"; cmd.Connection = conn; SqlParameter ff = new SqlParameter("@flag", SqlDbType.VarChar); ff.Value = d.flag; cmd.Parameters.Add(ff); SqlParameter i = new SqlParameter("@DId", SqlDbType.Int); i.Value = d.DId; cmd.Parameters.Add(i); SqlParameter di = new SqlParameter("@CompanyId", SqlDbType.VarChar, 50); di.Value = d.Company; cmd.Parameters.Add(di); SqlParameter n = new SqlParameter("@NAme", SqlDbType.VarChar, 50); n.Value = d.Name; cmd.Parameters.Add(n); SqlParameter r = new SqlParameter("@Address", SqlDbType.VarChar, 50); r.Value = d.Address; cmd.Parameters.Add(r); SqlParameter f = new SqlParameter("@PAddress", SqlDbType.VarChar, 50); f.Value = d.PermanentAddress; cmd.Parameters.Add(f); SqlParameter s = new SqlParameter("@Pin", SqlDbType.VarChar, 50); s.Value = d.Pin; cmd.Parameters.Add(s); SqlParameter g = new SqlParameter("@PPin", SqlDbType.VarChar, 50); g.Value = d.PermanentPin; cmd.Parameters.Add(g); SqlParameter j = new SqlParameter("@PMobNo", SqlDbType.VarChar, 255); j.Value = d.Mobilenumber; cmd.Parameters.Add(j); SqlParameter fr = new SqlParameter("@FirstName", SqlDbType.VarChar, 50); fr.Value = d.FirstName; cmd.Parameters.Add(fr); SqlParameter lk = new SqlParameter("@LastName", SqlDbType.VarChar, 50); lk.Value = d.LastName; cmd.Parameters.Add(lk); SqlParameter ed = new SqlParameter("@EmailId", SqlDbType.VarChar, 50); ed.Value = d.EmailId; cmd.Parameters.Add(ed); SqlParameter dc = new SqlParameter("@DriverCode", SqlDbType.VarChar); dc.Value = d.drivercode; cmd.Parameters.Add(dc); SqlParameter pr = new SqlParameter("@Photo", SqlDbType.VarChar, -1); pr.Value = d.Photo; cmd.Parameters.Add(pr); SqlParameter cs = new SqlParameter("@CurrentStateId", SqlDbType.Int); cs.Value = d.CurrentStateId; cmd.Parameters.Add(cs); SqlParameter ctry = new SqlParameter("@Country", SqlDbType.VarChar, 50); ctry.Value = d.CountryId; cmd.Parameters.Add(ctry); SqlParameter vg = new SqlParameter("@VehicleGroupId", SqlDbType.VarChar, 50); vg.Value = d.VehicleGroup; cmd.Parameters.Add(vg); SqlDataAdapter da = new SqlDataAdapter(cmd); da.Fill(dt); traceWriter.Trace(Request, "0", TraceLevel.Info, "{0}", "Driver successful...."); } catch (Exception ex) { traceWriter.Trace(Request, "0", TraceLevel.Error, "{0}", "Driver...." + ex.Message.ToString()); //throw new HttpResponseException(Request.CreateErrorResponse(HttpStatusCode.BadRequest, ex.Message)); dt.Columns.Add("Code"); dt.Columns.Add("description"); DataRow dr = dt.NewRow(); dr[0] = "ERR001"; dr[1] = ex.Message; dt.Rows.Add(dr); } finally { conn.Close(); conn.Dispose(); SqlConnection.ClearPool(conn); } return(dt); }
public DataTable Driverlist(driverdetails d) { SqlConnection conn = new SqlConnection(); try { conn.ConnectionString = ConfigurationManager.ConnectionStrings["btposdb"].ToString(); SqlCommand cmd = new SqlCommand(); cmd.CommandType = CommandType.StoredProcedure; cmd.CommandText = "HVInsUpddrivers"; cmd.Connection = conn; SqlParameter ff = new SqlParameter("@flag", SqlDbType.VarChar); ff.Value = d.flag; cmd.Parameters.Add(ff); SqlParameter i = new SqlParameter("@DId", SqlDbType.Int); i.Value = d.DId; cmd.Parameters.Add(i); SqlParameter di = new SqlParameter("@CountryId", SqlDbType.VarChar, 50); di.Value = d.Country; cmd.Parameters.Add(di); SqlParameter n = new SqlParameter("@NAme", SqlDbType.VarChar, 50); n.Value = d.Name; cmd.Parameters.Add(n); SqlParameter r = new SqlParameter("@Address", SqlDbType.VarChar, 50); r.Value = d.Address; cmd.Parameters.Add(r); SqlParameter f = new SqlParameter("@PAddress", SqlDbType.VarChar, 50); f.Value = d.PermanentAddress; cmd.Parameters.Add(f); SqlParameter s = new SqlParameter("@Pin", SqlDbType.VarChar, 50); s.Value = d.Pin; cmd.Parameters.Add(s); SqlParameter g = new SqlParameter("@PPin", SqlDbType.VarChar, 50); g.Value = d.PermanentPin; cmd.Parameters.Add(g); SqlParameter j = new SqlParameter("@PMobNo", SqlDbType.VarChar, 255); j.Value = d.Mobilenumber; cmd.Parameters.Add(j); SqlParameter fr = new SqlParameter("@FirstName", SqlDbType.VarChar, 50); fr.Value = d.FirstName; cmd.Parameters.Add(fr); SqlParameter lk = new SqlParameter("@LastName", SqlDbType.VarChar, 50); lk.Value = d.LastName; cmd.Parameters.Add(lk); SqlParameter ed = new SqlParameter("@EmailId", SqlDbType.VarChar, 50); ed.Value = d.EmailId; cmd.Parameters.Add(ed); SqlParameter dc = new SqlParameter("@DriverCode", SqlDbType.VarChar); dc.Value = d.drivercode; cmd.Parameters.Add(dc); SqlParameter pr = new SqlParameter("@Photo", SqlDbType.VarChar); pr.Value = d.Photo; cmd.Parameters.Add(pr); SqlParameter bg = new SqlParameter("@BloodGroup", SqlDbType.VarChar); bg.Value = d.BloodGroup; cmd.Parameters.Add(bg); SqlParameter df = new SqlParameter("@DOB", SqlDbType.DateTime); df.Value = d.DOB; cmd.Parameters.Add(df); SqlParameter dfs = new SqlParameter("@DOJ", SqlDbType.DateTime); dfs.Value = d.DOJ; cmd.Parameters.Add(dfs); SqlParameter sd = new SqlParameter("@Status", SqlDbType.Int); sd.Value = d.Status; cmd.Parameters.Add(sd); SqlParameter vf = new SqlParameter("@VehicleGroupId", SqlDbType.Int); vf.Value = d.VehicleGroup; cmd.Parameters.Add(vf); SqlParameter gf = new SqlParameter("@IsVerified", SqlDbType.Int); gf.Value = d.IsVerified; cmd.Parameters.Add(gf); SqlParameter hd = new SqlParameter("@IsApproved", SqlDbType.Int); hd.Value = d.IsApproved; cmd.Parameters.Add(hd); SqlParameter cdd = new SqlParameter("@CurrentStateId", SqlDbType.Int); cdd.Value = d.CurrentStateId; cmd.Parameters.Add(cdd); SqlParameter ptt = new SqlParameter("@PaymentTypeId", SqlDbType.Int); ptt.Value = d.PaymentTypeId; cmd.Parameters.Add(ptt); DataTable dt = new DataTable(); SqlDataAdapter da = new SqlDataAdapter(cmd); da.Fill(dt); return dt; } catch (Exception ex) { if (conn != null && conn.State == ConnectionState.Open) { conn.Close(); } throw ex; } }
public ActionResult DriverEdit() { driverdetails dtls = DriverLogic.SelectByPK(Convert.ToInt32(Request.Params["id"])); return(View(dtls)); }