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