public ActionResult Edit(CustMaster CustMaster)
{
CustMaster oCustMaster = new CustMaster();
Int64 pCustId = System.Convert.ToInt64(CustMaster.CustId);
oCustMaster = CustMasterData.Select_Record(pCustId);
if (ModelState.IsValid)
{
bool bSucess = false;
bSucess = CustMasterData.Update(oCustMaster, CustMaster);
if (bSucess == true)
{
ViewData["resultUpdate"] = "1";
return(RedirectToAction("Index"));
}
else
{
ViewData["resultUpdate"] = "0";
ModelState.AddModelError("", "Can Not Update");
}
}
return(View(CustMaster));
}
public static CustMaster Select_Record(Int64 pCustId)
{
CustMaster CustMaster = new CustMaster();
SqlConnection connection = plansoni_webstoreData.GetConnection();
string selectProcedure = "[CustMasterSelect]";
SqlCommand selectCommand = new SqlCommand(selectProcedure, connection);
selectCommand.CommandType = CommandType.StoredProcedure;
selectCommand.Parameters.AddWithValue("@CustId", pCustId);
try
{
connection.Open();
SqlDataReader reader
= selectCommand.ExecuteReader(CommandBehavior.SingleRow);
if (reader.Read())
{
CustMaster.CustId = System.Convert.ToInt64(reader["CustId"]);
CustMaster.CustName = reader["CustName"] is DBNull ? null : reader["CustName"].ToString();
CustMaster.Acronym = reader["Acronym"] is DBNull ? null : reader["Acronym"].ToString();
CustMaster.NoofBranches = reader["NoofBranches"] is DBNull ? null : (Int32?)reader["NoofBranches"];
CustMaster.LevelofAuthority = reader["LevelofAuthority"] is DBNull ? null : (Int32?)reader["LevelofAuthority"];
CustMaster.Code = reader["Code"] is DBNull ? null : reader["Code"].ToString();
CustMaster.Ticker = reader["Ticker"] is DBNull ? null : reader["Ticker"].ToString();
CustMaster.InDemo = (Boolean)reader["InDemo"];
CustMaster.TieredPricing = (Boolean)reader["TieredPricing"];
CustMaster.isActive = (Boolean)reader["isActive"];
}
else
{
CustMaster = null;
}
reader.Close();
}
catch (SqlException)
{
return(CustMaster);
}
finally
{
connection.Close();
}
return(CustMaster);
}
public ActionResult Create(CustMaster CustMaster)
{
if (ModelState.IsValid)
{
bool bSucess = false;
CustMaster.CustId = 0;
bSucess = CustMasterData.Add(CustMaster);
if (bSucess == true)
{
return(RedirectToAction("Index"));
}
else
{
ModelState.AddModelError("", "Can Not Insert");
}
}
return(View(CustMaster));
}
// GET: /CustMaster/Details/<id>
public ActionResult Details(Int64?CustId)
{
if (
CustId == null
)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
CustMaster CustMaster = new CustMaster();
Int64 pCustId = System.Convert.ToInt64(CustId);
CustMaster = CustMasterData.Select_Record(pCustId);
if (CustMaster == null)
{
return(HttpNotFound());
}
return(View(CustMaster));
}
public ActionResult DeleteConfirmed(
Int64?CustId
)
{
CustMaster CustMaster = new CustMaster();
Int64 pCustId = System.Convert.ToInt64(CustId);
CustMaster = CustMasterData.Select_Record(pCustId);
bool bSucess = false;
bSucess = CustMasterData.Delete(CustMaster);
if (bSucess == true)
{
return(RedirectToAction("Index"));
}
else
{
ModelState.AddModelError("", "Can Not Delete");
}
return(null);
}
public static bool Delete(CustMaster CustMaster)
{
SqlConnection connection = plansoni_webstoreData.GetConnection();
string deleteProcedure = "[CustMasterDelete]";
SqlCommand deleteCommand = new SqlCommand(deleteProcedure, connection);
deleteCommand.CommandType = CommandType.StoredProcedure;
deleteCommand.Parameters.AddWithValue("@OldCustId", CustMaster.CustId);
if (CustMaster.CustName != null)
{
deleteCommand.Parameters.AddWithValue("@OldCustName", CustMaster.CustName);
}
else
{
deleteCommand.Parameters.AddWithValue("@OldCustName", DBNull.Value);
}
if (CustMaster.Acronym != null)
{
deleteCommand.Parameters.AddWithValue("@OldAcronym", CustMaster.Acronym);
}
else
{
deleteCommand.Parameters.AddWithValue("@OldAcronym", DBNull.Value);
}
if (CustMaster.NoofBranches.HasValue == true)
{
deleteCommand.Parameters.AddWithValue("@OldNoofBranches", CustMaster.NoofBranches);
}
else
{
deleteCommand.Parameters.AddWithValue("@OldNoofBranches", DBNull.Value);
}
if (CustMaster.LevelofAuthority.HasValue == true)
{
deleteCommand.Parameters.AddWithValue("@OldLevelofAuthority", CustMaster.LevelofAuthority);
}
else
{
deleteCommand.Parameters.AddWithValue("@OldLevelofAuthority", DBNull.Value);
}
if (CustMaster.Code != null)
{
deleteCommand.Parameters.AddWithValue("@OldCode", CustMaster.Code);
}
else
{
deleteCommand.Parameters.AddWithValue("@OldCode", DBNull.Value);
}
if (CustMaster.Ticker != null)
{
deleteCommand.Parameters.AddWithValue("@OldTicker", CustMaster.Ticker);
}
else
{
deleteCommand.Parameters.AddWithValue("@OldTicker", DBNull.Value);
}
if (CustMaster.InDemo == true)
{
deleteCommand.Parameters.AddWithValue("@OldInDemo", CustMaster.InDemo);
}
else
{
deleteCommand.Parameters.AddWithValue("@OldInDemo", DBNull.Value);
}
if (CustMaster.TieredPricing == true)
{
deleteCommand.Parameters.AddWithValue("@OldTieredPricing", CustMaster.TieredPricing);
}
else
{
deleteCommand.Parameters.AddWithValue("@OldTieredPricing", DBNull.Value);
}
if (CustMaster.isActive == true)
{
deleteCommand.Parameters.AddWithValue("@OldisActive", CustMaster.isActive);
}
else
{
deleteCommand.Parameters.AddWithValue("@OldisActive", 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();
}
}
