public DataTable DocumentVerification(VehicleDocuments v) { //connect to database SqlConnection conn = new SqlConnection(); DataTable dt = new DataTable(); try { //connetionString="Data Source=ServerName;Initial Catalog=DatabaseName;User ID=UserName;Password=Password" conn.ConnectionString = System.Configuration.ConfigurationManager.ConnectionStrings["btposdb"].ToString(); SqlCommand cmd = new SqlCommand(); cmd.CommandType = CommandType.StoredProcedure; cmd.CommandText = "PSinsupdvehicledocsverifying"; cmd.Connection = conn; SqlParameter AssetId = new SqlParameter("@VehicleId", SqlDbType.Int); AssetId.Value = v.VehicleId; cmd.Parameters.Add(AssetId); SqlParameter rootassetid = new SqlParameter("@DocType", SqlDbType.VarChar); rootassetid.Value = v.docType; cmd.Parameters.Add(rootassetid); SqlParameter flag = new SqlParameter("@change", SqlDbType.VarChar); flag.Value = v.insupddelflag; cmd.Parameters.Add(flag); SqlParameter ver = new SqlParameter("@IsVerified", SqlDbType.Int); ver.Value = v.isVerified; cmd.Parameters.Add(ver); SqlParameter IA = new SqlParameter("@IsApproved", SqlDbType.Int); IA.Value = v.IsApproved; cmd.Parameters.Add(IA); SqlDataAdapter da = new SqlDataAdapter(cmd); da.Fill(dt); return(dt); } catch (Exception ex) { if (conn != null && conn.State == ConnectionState.Open) { conn.Close(); } string str = ex.Message; return(dt); } }
public int SaveVehicleDoc(VehicleDocuments vd) { //connect to database LogTraceWriter traceWriter = new LogTraceWriter(); SqlConnection conn = new SqlConnection(); DataTable dt = new DataTable(); StringBuilder str = new StringBuilder(); int status = 1; try { //connetionString="Data Source=ServerName;Initial Catalog=DatabaseName;User ID=UserName;Password=Password" conn.ConnectionString = System.Configuration.ConfigurationManager.ConnectionStrings["btposdb"].ToString(); SqlCommand cmd = new SqlCommand(); cmd.CommandType = CommandType.StoredProcedure; cmd.CommandText = "PSInsUpdDelVehicleDocs"; cmd.Connection = conn; SqlParameter did = new SqlParameter("@Id", SqlDbType.Int); did.Value = vd.Id; cmd.Parameters.Add(did); SqlParameter vId = new SqlParameter("@VehicleId", SqlDbType.Int); vId.Value = vd.VehicleId; cmd.Parameters.Add(vId); SqlParameter Gid = new SqlParameter("@FileName", SqlDbType.VarChar, 100); Gid.Value = vd.FileName; cmd.Parameters.Add(Gid); SqlParameter type = new SqlParameter("@DocTypeId", SqlDbType.Int); type.Value = vd.DocTypeId; cmd.Parameters.Add(type); SqlParameter exp = new SqlParameter("@ExpiryDate", SqlDbType.Date); exp.Value = vd.ExpiryDate; cmd.Parameters.Add(exp); SqlParameter update = new SqlParameter("@UpdatedById", SqlDbType.Int); update.Value = vd.UpdatedById; cmd.Parameters.Add(update); SqlParameter due = new SqlParameter("@DueDate", SqlDbType.Date); due.Value = vd.DueDate; cmd.Parameters.Add(due); SqlParameter cont = new SqlParameter("@FileContent", SqlDbType.VarChar); cont.Value = vd.FileContent; cmd.Parameters.Add(cont); SqlParameter flag = new SqlParameter("@change", SqlDbType.VarChar); flag.Value = vd.change; cmd.Parameters.Add(flag); SqlParameter luid = new SqlParameter("@loggedinUserId", SqlDbType.Int); luid.Value = vd.loggedinUserId; cmd.Parameters.Add(luid); SqlParameter doc = new SqlParameter("@DocumentNo", SqlDbType.VarChar, 50); doc.Value = vd.DocumentNo; cmd.Parameters.Add(doc); SqlParameter doc2 = new SqlParameter("@DocumentNo2", SqlDbType.VarChar, 50); doc2.Value = vd.DocumentNo2; cmd.Parameters.Add(doc2); SqlParameter ver = new SqlParameter("@IsVerified", SqlDbType.Int); ver.Value = vd.isVerified; cmd.Parameters.Add(ver); str.Append("DocTypeId:" + vd.DocTypeId + ","); str.Append("Id:" + vd.Id + ","); str.Append("VehicleId:" + vd.VehicleId + ","); str.Append("change:" + vd.change); str.Append("filename:" + vd.FileName); str.Append(Environment.NewLine); traceWriter.Trace(Request, "0", TraceLevel.Info, "{0}", "SaveVehicleDoc Input sent...." + str.ToString()); SqlDataAdapter da = new SqlDataAdapter(cmd); da.Fill(dt); traceWriter.Trace(Request, "0", TraceLevel.Info, "{0}", "SaveVehicleDoc successful...."); } catch (Exception ex) { traceWriter.Trace(Request, "0", TraceLevel.Error, "{0}", "SaveVehicleDoc....failed" + ex.Message.ToString()); //throw ex; //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); } return(status); }
public DataTable SaveVehicleDoc(VehicleDocuments a) { //connect to database SqlConnection conn = new SqlConnection(); DataTable dt = new DataTable(); try { //connetionString="Data Source=ServerName;Initial Catalog=DatabaseName;User ID=UserName;Password=Password" conn.ConnectionString = System.Configuration.ConfigurationManager.ConnectionStrings["btposdb"].ToString(); SqlCommand cmd = new SqlCommand(); cmd.CommandType = CommandType.StoredProcedure; cmd.CommandText = "HVInsUpdDelVehicleDocs"; cmd.Connection = conn; SqlParameter id = new SqlParameter("@Id", SqlDbType.Int); id.Value = a.Id; cmd.Parameters.Add(id); SqlParameter AssetId = new SqlParameter("@VehicleId", SqlDbType.Int); AssetId.Value = a.VehicleId; cmd.Parameters.Add(AssetId); SqlParameter Gid = new SqlParameter("@FileName", SqlDbType.VarChar, 100); Gid.Value = a.FileName; cmd.Parameters.Add(Gid); SqlParameter rootassetid = new SqlParameter("@DocTypeId", SqlDbType.Int); rootassetid.Value = a.docTypeId; cmd.Parameters.Add(rootassetid); SqlParameter AsstMDLHierarID = new SqlParameter("@UpdatedById", SqlDbType.Int); AsstMDLHierarID.Value = a.UpdatedById; cmd.Parameters.Add(AsstMDLHierarID); SqlParameter assetModelId = new SqlParameter("@ExpiryDate", SqlDbType.Date); assetModelId.Value = a.expiryDate; cmd.Parameters.Add(assetModelId); SqlParameter LocationId = new SqlParameter("@DueDate", SqlDbType.Date); LocationId.Value = a.dueDate; cmd.Parameters.Add(LocationId); SqlParameter parentid = new SqlParameter("@FileContent", SqlDbType.VarChar); parentid.Value = a.FileContent; cmd.Parameters.Add(parentid); SqlParameter flag = new SqlParameter("@change", SqlDbType.VarChar); flag.Value = a.insupddelflag; cmd.Parameters.Add(flag); SqlParameter loggedinUserId1 = new SqlParameter("@loggedinUserId", SqlDbType.Int); loggedinUserId1.Value = a.UpdatedById; cmd.Parameters.Add(loggedinUserId1); SqlParameter doc = new SqlParameter("@DocumentNo", SqlDbType.VarChar, 50); doc.Value = a.DocumentNo; cmd.Parameters.Add(doc); SqlParameter doc2 = new SqlParameter("@DocumentNo2", SqlDbType.VarChar, 50); doc2.Value = a.DocumentNo2; cmd.Parameters.Add(doc2); SqlParameter ver = new SqlParameter("@IsVerified", SqlDbType.Int); ver.Value = a.isVerified; cmd.Parameters.Add(ver); SqlDataAdapter da = new SqlDataAdapter(cmd); da.Fill(dt); return(dt); } catch (Exception ex) { if (conn != null && conn.State == ConnectionState.Open) { conn.Close(); } string str = ex.Message; return(dt); } }