public static void Main()
{
Boolean isAdmin;
string UserChoice = "";
string returnOutput = "";
IMaterialDatabaseActivity projec = new MaterialDatabaseActivitySQL();
MaterialModel materialInfo = new MaterialModel();
materialsView projView = new materialsView();
List <MaterialModel> lstMaterialsModel;
isAdmin = projView.initialse();
UserChoice = projView.userOptions(isAdmin);
if (UserChoice == "Search")
{
materialInfo = projView.userSearchInstrucitons(materialInfo);
lstMaterialsModel = projec.Search(materialInfo);
projView.displayMaterialList(lstMaterialsModel);
}
else if (UserChoice == "Add")
{
materialInfo = projView.displayAddMaterailInstrucitons(materialInfo);
returnOutput = projec.Add(materialInfo);
if (returnOutput == "")
{
Console.WriteLine("New Material Added Sucessfully");
}
else
{
Console.WriteLine(returnOutput);
}
}
else if (UserChoice == "Update")
{
projView.displayUpdateMaterailInstrucitons(materialInfo);
returnOutput = projec.Update(materialInfo);
if (returnOutput == "")
{
Console.WriteLine("Material updated Sucessfully");
}
else
{
Console.WriteLine(returnOutput);
}
}
else if (UserChoice == "Delete")
{
materialInfo.IdentificationNumber = projView.displayDeleteMaterailInstrucitons();
returnOutput = projec.Delete(materialInfo);
if (returnOutput == "")
{
Console.WriteLine("Material deleted Sucessfully");
}
else
{
Console.WriteLine(returnOutput);
}
}
Console.WriteLine("Press any key to exit");
Console.ReadKey();
}
public List <MaterialModel> Search(MaterialModel MaterialInfo)
{
try
{
using (SqlConnection sqlCon = new SqlConnection(sqlConnectionText))
{
SqlDataAdapter da = new SqlDataAdapter();
MaterialModel materials = null;
string sqlCmdText = "SELECT * FROM dbo.MaterialInfo"
+ " WHERE ProjectTitle = @ProjectTitle OR IdentificationNumber = @IdentificationNumber OR AddedDate = @AddedDate OR MaterialType = @MaterialType";
using (SqlCommand cmd = new SqlCommand(sqlCmdText))
{
cmd.Connection = sqlCon;
sqlCon.Open();
DataSet ds = new DataSet();
if (MaterialInfo.projectTitle != null)
{
cmd.Parameters.AddWithValue("@ProjectTitle", MaterialInfo.projectTitle);
}
else
{
cmd.Parameters.AddWithValue("@ProjectTitle", DBNull.Value);
}
if (MaterialInfo.IdentificationNumber != 0)
{
cmd.Parameters.AddWithValue("@IdentificationNumber", MaterialInfo.IdentificationNumber);
}
else
{
cmd.Parameters.AddWithValue("@IdentificationNumber", DBNull.Value);
}
if (MaterialInfo.addedDate != null)
{
cmd.Parameters.AddWithValue("@AddedDate", MaterialInfo.addedDate);
}
else
{
cmd.Parameters.AddWithValue("@AddedDate", DBNull.Value);
}
if (MaterialInfo.materialType != null)
{
cmd.Parameters.AddWithValue("@MaterialType", MaterialInfo.materialType);
}
else
{
cmd.Parameters.AddWithValue("@MaterialType", DBNull.Value);
}
da = new SqlDataAdapter(cmd);
da.Fill(ds);
foreach (DataRow row in ds.Tables[0].Rows)
{
var values = row.ItemArray;
materials = new MaterialModel()
{
IdentificationNumber = Convert.ToInt32(values[0]),
title = values[1].ToString(),
projectTitle = values[2].ToString(),
materialType = values[3].ToString(),
format = values[4].ToString(),
audioFormat = values[5].ToString(),
runTime = (TimeSpan)(values[6]),
releaseDate = Convert.ToDateTime(values[7]),
launguage = values[8].ToString(),
retailPrice = (float)Convert.ToDouble(values[9]),
subTitles = values[10].ToString(),
frameAspect = values[11].ToString(),
packaging = values[12].ToString(),
addedDate = values[13].ToString(),
addedBy = values[14].ToString()
};
lstMaterialsModel.Add(materials);
}
sqlCon.Close();
}
}
}
catch (SqlException e)
{
Console.WriteLine(e.Message);
}
return(lstMaterialsModel);
}