public DataTable DocumentVerification(DriverDocuments d)
{
//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 = "PSinsupddriverdocsverifying";
cmd.Connection = conn;
SqlParameter AssetId = new SqlParameter("@DriverId", SqlDbType.Int);
AssetId.Value = d.DriverId;
cmd.Parameters.Add(AssetId);
SqlParameter rootassetid = new SqlParameter("@DocType", SqlDbType.VarChar);
rootassetid.Value = d.docType;
cmd.Parameters.Add(rootassetid);
SqlParameter flag = new SqlParameter("@change", SqlDbType.VarChar);
flag.Value = d.insupddelflag;
cmd.Parameters.Add(flag);
SqlParameter ver = new SqlParameter("@IsVerified", SqlDbType.Int);
ver.Value = d.isVerified;
cmd.Parameters.Add(ver);
SqlParameter IA = new SqlParameter("@IsApproved", SqlDbType.Int);
IA.Value = d.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 SaveDriverDoc(DriverDocuments dd)
{
DataTable dt = new DataTable();
LogTraceWriter traceWriter = new LogTraceWriter();
SqlConnection conn = new SqlConnection();
StringBuilder str = new StringBuilder();
int status = 1;
try
{
traceWriter.Trace(Request, "0", TraceLevel.Info, "{0}", "SaveDriverDocuments....");
//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 = "PSInsUpdDelDriverDocs";
cmd.Connection = conn;
SqlParameter did = new SqlParameter("@Id", SqlDbType.Int);
did.Value = dd.Id;
cmd.Parameters.Add(did);
SqlParameter drId = new SqlParameter("@DriverId", SqlDbType.Int);
drId.Value = dd.DriverId;
cmd.Parameters.Add(drId);
SqlParameter Gid = new SqlParameter("@FileName", SqlDbType.VarChar, 100);
Gid.Value = dd.FileName;
cmd.Parameters.Add(Gid);
SqlParameter type = new SqlParameter("@DocTypeId", SqlDbType.Int);
type.Value = dd.DocTypeId;
cmd.Parameters.Add(type);
SqlParameter exp = new SqlParameter("@ExpiryDate", SqlDbType.Date);
exp.Value = dd.ExpiryDate;
cmd.Parameters.Add(exp);
//SqlParameter create= new SqlParameter("@CreatedById", SqlDbType.Int);
//create.Value = dd.CreatedById;
//cmd.Parameters.Add(create);
SqlParameter update = new SqlParameter("@UpdatedById", SqlDbType.Int);
update.Value = dd.UpdatedById;
cmd.Parameters.Add(update);
SqlParameter due = new SqlParameter("@DueDate", SqlDbType.Date);
due.Value = dd.DueDate;
cmd.Parameters.Add(due);
SqlParameter cont = new SqlParameter("@FileContent", SqlDbType.VarChar);
cont.Value = dd.FileContent;
cmd.Parameters.Add(cont);
SqlParameter flag = new SqlParameter("@change", SqlDbType.VarChar);
flag.Value = dd.change;
cmd.Parameters.Add(flag);
SqlParameter luid = new SqlParameter("@loggedinUserId", SqlDbType.Int);
luid.Value = dd.loggedinUserId;
cmd.Parameters.Add(luid);
SqlParameter doc = new SqlParameter("@DocumentNo", SqlDbType.VarChar, 50);
doc.Value = dd.DocumentNo;
cmd.Parameters.Add(doc);
SqlParameter doc2 = new SqlParameter("@DocumentNo2", SqlDbType.VarChar, 50);
doc2.Value = dd.DocumentNo2;
cmd.Parameters.Add(doc2);
SqlParameter ver = new SqlParameter("@IsVerified", SqlDbType.Int);
ver.Value = dd.isVerified;
cmd.Parameters.Add(ver);
str.Append("DocTypeId:" + dd.DocTypeId + ",");
str.Append("Id:" + dd.Id + ",");
str.Append("DriverId:" + dd.DriverId + ",");
str.Append("change:" + dd.change);
str.Append("filename:" + dd.FileName);
str.Append(Environment.NewLine);
traceWriter.Trace(Request, "0", TraceLevel.Info, "{0}", "SaveDriverDocuments Input sent...." + str.ToString());
SqlDataAdapter da = new SqlDataAdapter(cmd);
da.Fill(dt);
traceWriter.Trace(Request, "0", TraceLevel.Info, "{0}", "SaveDriverDocuments successful....");
}
catch (Exception ex)
{
traceWriter.Trace(Request, "0", TraceLevel.Error, "{0}", "SaveDriverDocuments...." + 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(status);
}
public DataTable SaveDriverDoc(DriverDocuments 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 = "HVInsUpdDelDriverDocs";
cmd.Connection = conn;
SqlParameter id = new SqlParameter("@Id", SqlDbType.Int);
id.Value = a.Id;
cmd.Parameters.Add(id);
SqlParameter AssetId = new SqlParameter("@DriverId", SqlDbType.Int);
AssetId.Value = a.DriverId;
cmd.Parameters.Add(AssetId);
SqlParameter Gid = new SqlParameter("@FileName", SqlDbType.VarChar, 100);
Gid.Value = a.docName;
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.docContent;
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();
}
throw ex;
}
}