// GET: /ArchitectAssociate/Delete/<id>
public ActionResult Delete(
Int32?ArchitectAssociateID
)
{
if (
ArchitectAssociateID == null
)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
dtArchitect = ArchitectAssociate_ArchitectData.SelectAll();
ArchitectAssociate ArchitectAssociate = new ArchitectAssociate();
ArchitectAssociate.ArchitectAssociateID = System.Convert.ToInt32(ArchitectAssociateID);
ArchitectAssociate = ArchitectAssociateData.Select_Record(ArchitectAssociate);
ArchitectAssociate.Architect = new Architect()
{
ArchitectID = (Int32)ArchitectAssociate.ArchitectID
,
ArchitectName = (from DataRow rowArchitect in dtArchitect.Rows
where ArchitectAssociate.ArchitectID == (int)rowArchitect["ArchitectID"]
select(String) rowArchitect["ArchitectName"]).FirstOrDefault()
};
if (ArchitectAssociate == null)
{
return(HttpNotFound());
}
return(View(ArchitectAssociate));
}
public ActionResult Edit(ArchitectAssociate ArchitectAssociate)
{
ArchitectAssociate oArchitectAssociate = new ArchitectAssociate();
oArchitectAssociate.ArchitectAssociateID = System.Convert.ToInt32(ArchitectAssociate.ArchitectAssociateID);
oArchitectAssociate = ArchitectAssociateData.Select_Record(ArchitectAssociate);
if (ModelState.IsValid)
{
bool bSucess = false;
bSucess = ArchitectAssociateData.Update(oArchitectAssociate, ArchitectAssociate);
if (bSucess == true)
{
return(RedirectToAction("Index"));
}
else
{
ModelState.AddModelError("", "Can Not Update");
}
}
// ComboBox
ViewData["ArchitectID"] = new SelectList(ArchitectAssociate_ArchitectData.List(), "ArchitectID", "ArchitectName", ArchitectAssociate.ArchitectID);
return(View(ArchitectAssociate));
}
// GET: /ArchitectAssociate/Edit/<id>
public ActionResult Edit(
Int32?ArchitectAssociateID
)
{
if (
ArchitectAssociateID == null
)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
ArchitectAssociate ArchitectAssociate = new ArchitectAssociate();
ArchitectAssociate.ArchitectAssociateID = System.Convert.ToInt32(ArchitectAssociateID);
ArchitectAssociate = ArchitectAssociateData.Select_Record(ArchitectAssociate);
if (ArchitectAssociate == null)
{
return(HttpNotFound());
}
// ComboBox
ViewData["ArchitectID"] = new SelectList(ArchitectAssociate_ArchitectData.List(), "ArchitectID", "ArchitectName", ArchitectAssociate.ArchitectID);
return(View(ArchitectAssociate));
}
public ActionResult Create([Bind(Include =
"ArchitectID"
+ "," + "AssociateName"
+ "," + "ContactNo"
+ "," + "EMail"
)] ArchitectAssociate ArchitectAssociate)
{
if (ModelState.IsValid)
{
bool bSucess = false;
bSucess = ArchitectAssociateData.Add(ArchitectAssociate);
if (bSucess == true)
{
return(RedirectToAction("Index"));
}
else
{
ModelState.AddModelError("", "Can Not Insert");
}
}
// ComboBox
ViewData["ArchitectID"] = new SelectList(ArchitectAssociate_ArchitectData.List(), "ArchitectID", "ArchitectName", ArchitectAssociate.ArchitectID);
return(View(ArchitectAssociate));
}
public static bool Delete(ArchitectAssociate ArchitectAssociate)
{
SqlConnection connection = PMMSData.GetConnection();
string deleteProcedure = "[ArchitectAssociateDelete]";
SqlCommand deleteCommand = new SqlCommand(deleteProcedure, connection);
deleteCommand.CommandType = CommandType.StoredProcedure;
deleteCommand.Parameters.AddWithValue("@OldArchitectAssociateID", ArchitectAssociate.ArchitectAssociateID);
deleteCommand.Parameters.AddWithValue("@OldArchitectID", ArchitectAssociate.ArchitectID);
deleteCommand.Parameters.AddWithValue("@OldAssociateName", ArchitectAssociate.AssociateName);
if (ArchitectAssociate.ContactNo != null)
{
deleteCommand.Parameters.AddWithValue("@OldContactNo", ArchitectAssociate.ContactNo);
}
else
{
deleteCommand.Parameters.AddWithValue("@OldContactNo", DBNull.Value);
}
if (ArchitectAssociate.EMail != null)
{
deleteCommand.Parameters.AddWithValue("@OldEMail", ArchitectAssociate.EMail);
}
else
{
deleteCommand.Parameters.AddWithValue("@OldEMail", DBNull.Value);
}
deleteCommand.Parameters.Add("@ReturnValue", System.Data.SqlDbType.Int);
deleteCommand.Parameters["@ReturnValue"].Direction = ParameterDirection.Output;
try
{
connection.Open();
deleteCommand.ExecuteNonQuery();
int count = System.Convert.ToInt32(deleteCommand.Parameters["@ReturnValue"].Value);
if (count > 0)
{
return(true);
}
else
{
return(false);
}
}
catch (SqlException)
{
return(false);
}
finally
{
connection.Close();
}
}
public ActionResult DeleteConfirmed(
Int32?ArchitectAssociateID
)
{
ArchitectAssociate ArchitectAssociate = new ArchitectAssociate();
ArchitectAssociate.ArchitectAssociateID = System.Convert.ToInt32(ArchitectAssociateID);
ArchitectAssociate = ArchitectAssociateData.Select_Record(ArchitectAssociate);
bool bSucess = false;
bSucess = ArchitectAssociateData.Delete(ArchitectAssociate);
if (bSucess == true)
{
return(RedirectToAction("Index"));
}
else
{
ModelState.AddModelError("", "Can Not Delete");
}
return(null);
}
public static ArchitectAssociate Select_Record(ArchitectAssociate ArchitectAssociatePara)
{
ArchitectAssociate ArchitectAssociate = new ArchitectAssociate();
SqlConnection connection = PMMSData.GetConnection();
string selectProcedure = "[ArchitectAssociateSelect]";
SqlCommand selectCommand = new SqlCommand(selectProcedure, connection);
selectCommand.CommandType = CommandType.StoredProcedure;
selectCommand.Parameters.AddWithValue("@ArchitectAssociateID", ArchitectAssociatePara.ArchitectAssociateID);
try
{
connection.Open();
SqlDataReader reader
= selectCommand.ExecuteReader(CommandBehavior.SingleRow);
if (reader.Read())
{
ArchitectAssociate.ArchitectAssociateID = System.Convert.ToInt32(reader["ArchitectAssociateID"]);
ArchitectAssociate.ArchitectID = System.Convert.ToInt32(reader["ArchitectID"]);
ArchitectAssociate.AssociateName = System.Convert.ToString(reader["AssociateName"]);
ArchitectAssociate.ContactNo = reader["ContactNo"] is DBNull ? null : reader["ContactNo"].ToString();
ArchitectAssociate.EMail = reader["EMail"] is DBNull ? null : reader["EMail"].ToString();
}
else
{
ArchitectAssociate = null;
}
reader.Close();
}
catch (SqlException)
{
return(ArchitectAssociate);
}
finally
{
connection.Close();
}
return(ArchitectAssociate);
}
