public OutsiderLeasesInfo GetOutsiderLeasesInfo(string COLPhone, string CSEngine)
{
SQLConn sQLConn = new SQLConn();
string query = @"select * from OutsiderLeasesInfo where
SEngineNo = @CSEngineNo and OLPhone = @COLPhone";
SqlCommand sqlCommand = new SqlCommand(query, sQLConn.GetConnToLocalDb());
SqlParameter sqlParameter = new SqlParameter
{
ParameterName = "CSEngineNo",
SqlDbType = System.Data.SqlDbType.NVarChar,
Value = CSEngine
};
sqlCommand.Parameters.Add(sqlParameter);
sqlParameter = new SqlParameter
{
ParameterName = "COLPhone",
SqlDbType = System.Data.SqlDbType.NVarChar,
Value = COLPhone
};
sqlCommand.Parameters.Add(sqlParameter);
SqlDataReader sqlDataReader = sqlCommand.ExecuteReader();
if (sqlDataReader.Read())
{
OutsiderLeasesInfo outsiderLeasesInfo = new OutsiderLeasesInfo
{
OLCnic = sqlDataReader[0].ToString(),
OLName = sqlDataReader[1].ToString(),
OLPhone = sqlDataReader[2].ToString(),
OLAddress = sqlDataReader[3].ToString(),
SEngineNo = sqlDataReader[4].ToString(),
OLAmount = Int32.Parse(sqlDataReader[5].ToString()),
OLDuration = Int32.Parse(sqlDataReader[6].ToString()),
OLAdvance = Int32.Parse(sqlDataReader[7].ToString()),
OLInstallment = Int32.Parse(sqlDataReader[8].ToString()),
OLDate = DateTime.Parse(sqlDataReader[9].ToString()),
};
return(outsiderLeasesInfo);
}
return(null);
}
public void InsertOutsiderLeasesInfo(OutsiderLeasesInfo outsiderLeasesInfo)
{
SQLConn sQLConn = new SQLConn();
string query = @"insert into OutsiderLeasesInfo (OLCnic , OLName , OLPhone , OLAddress,
SEngineNo , OLAmount , OLDuration , OLAdvance , OLInstallment , OLDate)
values(@OLCnic , @OLName , @OLPhone , @OLAddress ,
@SEngineNo , @OLAmount , @OLDuration , @OLAdvance , @OLInstallment , @OLDate)";
SqlCommand sqlCommand = new SqlCommand(query, sQLConn.GetConnToLocalDb());
SqlParameter sqlParameter = new SqlParameter
{
ParameterName = "OLCnic",
SqlDbType = System.Data.SqlDbType.NVarChar,
Value = outsiderLeasesInfo.OLCnic
};
sqlCommand.Parameters.Add(sqlParameter);
sqlParameter = new SqlParameter
{
ParameterName = "OLName",
SqlDbType = System.Data.SqlDbType.NVarChar,
Value = outsiderLeasesInfo.OLName
};
sqlCommand.Parameters.Add(sqlParameter);
sqlParameter = new SqlParameter
{
ParameterName = "OLPhone",
SqlDbType = System.Data.SqlDbType.NVarChar,
Value = outsiderLeasesInfo.OLPhone
};
sqlCommand.Parameters.Add(sqlParameter);
sqlParameter = new SqlParameter
{
ParameterName = "OLAddress",
SqlDbType = System.Data.SqlDbType.NVarChar,
Value = outsiderLeasesInfo.OLAddress
};
sqlCommand.Parameters.Add(sqlParameter);
sqlParameter = new SqlParameter
{
ParameterName = "SEngineNo",
SqlDbType = System.Data.SqlDbType.NVarChar,
Value = outsiderLeasesInfo.SEngineNo
};
sqlCommand.Parameters.Add(sqlParameter);
sqlParameter = new SqlParameter
{
ParameterName = "OLAmount",
SqlDbType = System.Data.SqlDbType.Int,
Value = outsiderLeasesInfo.OLAmount
};
sqlCommand.Parameters.Add(sqlParameter);
sqlParameter = new SqlParameter
{
ParameterName = "OLDuration",
SqlDbType = System.Data.SqlDbType.Int,
Value = outsiderLeasesInfo.OLDuration
};
sqlCommand.Parameters.Add(sqlParameter);
sqlParameter = new SqlParameter
{
ParameterName = "OLAdvance",
SqlDbType = System.Data.SqlDbType.Int,
Value = outsiderLeasesInfo.OLAdvance
};
sqlCommand.Parameters.Add(sqlParameter);
sqlParameter = new SqlParameter
{
ParameterName = "OLInstallment",
SqlDbType = System.Data.SqlDbType.Int,
Value = outsiderLeasesInfo.OLInstallment
};
sqlCommand.Parameters.Add(sqlParameter);
sqlParameter = new SqlParameter
{
ParameterName = "OLDate",
SqlDbType = System.Data.SqlDbType.Date,
Value = outsiderLeasesInfo.OLDate
};
sqlCommand.Parameters.Add(sqlParameter);
sqlCommand.ExecuteNonQuery();
}
public void UpdateOutsiderLeasesInfo(OutsiderLeasesInfo outsiderLeasesInfo, string COLPhone, string CSEngine)
{
SQLConn sQLConn = new SQLConn();
string query = @"Update OutsiderLeasesInfo set
OLCnic = @OLCnic, OLName = @OLName, OLPhone = @OLPhone
, OLAdvance = @OLAdvance, OLAmount = @OLAmount , OLDuration = @OLDuration,
OLInstallment = @OLInstallment , OLDate = @OLDate
where OLPhone = @COLPhone and SEngineNo = @CSEngineNo";
SqlCommand sqlCommand = new SqlCommand(query, sQLConn.GetConnToLocalDb());
SqlParameter sqlParameter = new SqlParameter
{
ParameterName = "OLCnic",
SqlDbType = System.Data.SqlDbType.NVarChar,
Value = outsiderLeasesInfo.OLCnic
};
sqlCommand.Parameters.Add(sqlParameter);
sqlParameter = new SqlParameter
{
ParameterName = "OLName",
SqlDbType = System.Data.SqlDbType.NVarChar,
Value = outsiderLeasesInfo.OLName
};
sqlCommand.Parameters.Add(sqlParameter);
sqlParameter = new SqlParameter
{
ParameterName = "OLInstallment",
SqlDbType = System.Data.SqlDbType.NVarChar,
Value = outsiderLeasesInfo.OLInstallment
};
sqlCommand.Parameters.Add(sqlParameter);
sqlParameter = new SqlParameter
{
ParameterName = "OLPhone",
SqlDbType = System.Data.SqlDbType.NVarChar,
Value = outsiderLeasesInfo.OLPhone
};
sqlCommand.Parameters.Add(sqlParameter);
sqlParameter = new SqlParameter
{
ParameterName = "OLAddress",
SqlDbType = System.Data.SqlDbType.NVarChar,
Value = outsiderLeasesInfo.OLAddress
};
sqlCommand.Parameters.Add(sqlParameter);
sqlParameter = new SqlParameter
{
ParameterName = "OLAmount",
SqlDbType = System.Data.SqlDbType.Int,
Value = outsiderLeasesInfo.OLAmount
};
sqlCommand.Parameters.Add(sqlParameter);
sqlParameter = new SqlParameter
{
ParameterName = "OLDuration",
SqlDbType = System.Data.SqlDbType.Int,
Value = outsiderLeasesInfo.OLDuration
};
sqlCommand.Parameters.Add(sqlParameter);
sqlParameter = new SqlParameter
{
ParameterName = "OLAdvance",
SqlDbType = System.Data.SqlDbType.Int,
Value = outsiderLeasesInfo.OLAdvance
};
sqlCommand.Parameters.Add(sqlParameter);
sqlParameter = new SqlParameter
{
ParameterName = "SEngineNo",
SqlDbType = System.Data.SqlDbType.NVarChar,
Value = outsiderLeasesInfo.SEngineNo
};
sqlCommand.Parameters.Add(sqlParameter);
sqlParameter = new SqlParameter
{
ParameterName = "OLDate",
SqlDbType = System.Data.SqlDbType.Date,
Value = outsiderLeasesInfo.OLDate
};
sqlCommand.Parameters.Add(sqlParameter);
sqlParameter = new SqlParameter
{
ParameterName = "COLPhone",
SqlDbType = System.Data.SqlDbType.NVarChar,
Value = COLPhone
};
sqlCommand.Parameters.Add(sqlParameter);
sqlParameter = new SqlParameter
{
ParameterName = "CSEngineNo",
SqlDbType = System.Data.SqlDbType.Int,
Value = CSEngine
};
sqlCommand.Parameters.Add(sqlParameter);
sqlCommand.ExecuteNonQuery();
}