public async Task <IHttpActionResult> PostRackAsync(RackMaster rackMaster)
{
if (!ModelState.IsValid)
{
return(BadRequest(ModelState));
}
try
{
_rackMasterService.Add(rackMaster);
await _rackMasterService.CommitAsync();
var rackMasterDto = _mapper.Map <RackMaster, RackMasterDto>(rackMaster);
return(CreatedAtRoute("ApiRoute", new { controller = "Racks", id = rackMasterDto.Id }, rackMasterDto));
}
catch (DbUpdateException)
{
if (await RackMasterDetailExistsAsync(rackMaster.Id))
{
return(Conflict());
}
else
{
throw;
}
}
}
public int UpdateRackDetailsToDB(RackMaster rack)
{
try
{
cmd = new SqlCommand("spUpdateRackDetails", con.ActiveCon());
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("Rack_Id", rack.rackId);
cmd.Parameters.AddWithValue("Rack_Name", rack.rackName);
cmd.Parameters.AddWithValue("Rack_Status", rack.rackStatus);
int count = cmd.ExecuteNonQuery();
return(count);
}
catch (Exception ex)
{
string errorMessage = ErrorHandling.Class1.CreateErrorMessage(ex);
ErrorHandling.Class1.LogFileWrite(errorMessage);
return(-1);
}
finally
{
con.CloseCon();
}
}
public void UpdateRackDetails()
{
try
{
rack = new RackMaster();
rack.rackId = Convert.ToInt32(txtRackID.Text);
rack.rackName = txtRackName.Text;
rack.rackStatus = cmbRackStatus.Text == "Active" ? 1 : 0;
rackBL = new RackMasterBL();
if (rackBL.UpdateRackMasterDetails(rack) > 0)
{
MessageBox.Show("Rack Details Are Updated..", "Information", MessageBoxButtons.OK);
}
else
{
MessageBox.Show("Rack Details Are Not Updated..", "Information", MessageBoxButtons.OK);
}
}
catch (Exception ex)
{
string errorMessage = ErrorHandling.Class1.CreateErrorMessage(ex);
ErrorHandling.Class1.LogFileWrite(errorMessage);
MessageBox.Show("Rack Details Are Not Updated..", "Information", MessageBoxButtons.OK);
}
}
public ActionResult RackMaster(RackMaster rackMaster)
{
if (ModelState.IsValid)
{
db.RackMaster.Add(rackMaster);
db.SaveChanges();
var data = db.RackMaster.OrderByDescending(p => p.Id).ToList();
return(PartialView("~/Areas/MedicalStore/Views/MedicalStoreMaster/_RackMasterList.cshtml", data));
}
return(Json("Something", JsonRequestBehavior.AllowGet));
}
public ActionResult RackMaster(RackMaster rackMaster)
{
rackMaster.department = "MedicalStore";
if (ModelState.IsValid)
{
db.RackMaster.Add(rackMaster);
db.SaveChanges();
var data = db.RackMaster.Where(p => p.department == "MedicalStore").OrderByDescending(p => p.Id).ToList();
return(PartialView("~/Areas/MedicalStore/Views/MedicalStoreMaster/_RackMasterList.cshtml", data));
}
return(Json("Error Occured", JsonRequestBehavior.AllowGet));
}
public int UpdateRackMasterDetails(RackMaster rack)
{
try
{
rackDA = new RackMasterDA();
return(rackDA.UpdateRackDetailsToDB(rack));
}
catch (Exception ex)
{
string errorMessage = ErrorHandling.Class1.CreateErrorMessage(ex);
ErrorHandling.Class1.LogFileWrite(errorMessage);
return(-1);
}
}
public int SaveRackMasterDetails(RackMaster rack)
{
try
{
//RackMasterBL rackBL = new RackMasterBL();//stackOverFlow Exception
//A StackOverflowException exception is thrown when the execution stack overflows by having too many nested method calls. Associated Tips. Make sure you do not have an infinite loop or infinite recursion.
rackDA = new RackMasterDA();
return(rackDA.SaveRackDetailsToDB(rack));
}
catch (Exception ex)
{
string errorMessage = ErrorHandling.Class1.CreateErrorMessage(ex);
ErrorHandling.Class1.LogFileWrite(errorMessage);
return(-1);
}
}
public RackMaster[] GetRacks()
{
DataTable dt = new DataTable();
RackMaster[] rackMasters;
Query = "exec proc_GetRacks";
dt = caObjects.ExecuteQueryReturnDataTable(Query);
rackMasters = new RackMaster[dt.Rows.Count];
for (int i = 0; i <= dt.Rows.Count - 1; i++)
{
RackMaster rackMaster = new RackMaster();
rackMaster.rak_Rack_Id = Convert.ToInt32(dt.Rows[i]["rak_Rack_Id"]);
rackMaster.rak_Rack_Name = Convert.ToString(dt.Rows[i]["rak_Rack_Name"]);
rackMaster.rak_Rack_Number = Convert.ToString(dt.Rows[i]["rak_Rack_Number"]);
rackMasters[i] = rackMaster;
}
return(rackMasters);
}
public int CreateRack(RackMaster rackMaster)
{
return(this.rackMaster.CreateRack(rackMaster));
}
public int CreateRack(RackMaster rackMaster)
{
Query = "exec proc_Rack_Master '" + rackMaster.rak_Rack_Id + "','" + rackMaster.rak_Rack_Number + "','" + rackMaster.rak_Rack_Name + "','" + rackMaster.rak_User + "'";
return(Convert.ToInt32(caObjects.ExecuteQuery(Query)));
}
public async Task <int> CreateRack(RackMaster roleMaster)
{
Int32 i = await _httpClient.PostJsonAsync <Int32>("api/RackMaster/CreateRack", roleMaster);
return(i);
}
