public async Task <IActionResult> PutEnquiryDetail(int id, EnquiryDetail enquiryDetail)
{
if (id != enquiryDetail.EnquiryId)
{
return(BadRequest());
}
_context.Entry(enquiryDetail).State = EntityState.Modified;
try
{
await _context.SaveChangesAsync();
}
catch (DbUpdateConcurrencyException)
{
if (!EnquiryDetailExists(id))
{
return(NotFound());
}
else
{
throw;
}
}
return(NoContent());
}
public async Task <ActionResult <EnquiryDetail> > PostEnquiryDetail(EnquiryDetail enquiryDetail)
{
_context.EnquiryDetails.Add(enquiryDetail);
await _context.SaveChangesAsync();
return(CreatedAtAction("GetEnquiryDetail", new { id = enquiryDetail.EnquiryId }, enquiryDetail));
}
public bool SaveEnquiry(EnquiryDetailViewModel ob)
{
var _enq = new EnquiryDetail();
_enq.FirstName = ob.FirstName.ToStringValue();
_enq.LastName = ob.LastName.ToStringValue();
_enq.DOB = ob.DOB.ToStringValue();
_enq.Mobile = ob.Mobile.ToStringValue();
_enq.Class = ob.Class.ToStringValue();
_enq.Address = ob.Address.ToStringValue();
_enq.Email = ob.Email.ToStringValue();
_enq.EntryTime = DateTime.Now;
_enq.ResolvedTime = null;
_enq.Dated = DateTime.Now;
_enq.Resolved = false;
_ety.EnquiryDetails.Add(_enq);
_ety.SaveChanges();
ob.ID = _enq.ID;
return(true);
}
public List <EnquiryDetail> GetEnquiryDetailListByEnquiryID(Guid enquiryID)
{
List <EnquiryDetail> enquiryDetailList = new List <EnquiryDetail>();
try
{
using (SqlConnection con = _databaseFactory.GetDBConnection())
{
using (SqlCommand cmd = new SqlCommand())
{
if (con.State == ConnectionState.Closed)
{
con.Open();
}
cmd.Connection = con;
cmd.CommandText = "[PSA].[GetEnquiryDetailListByEnquiryID]";
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.Add("@EnquiryID", SqlDbType.UniqueIdentifier).Value = enquiryID;
using (SqlDataReader sdr = cmd.ExecuteReader())
{
if ((sdr != null) && (sdr.HasRows))
{
while (sdr.Read())
{
EnquiryDetail enquiryDetail = new EnquiryDetail();
{
enquiryDetail.ID = (sdr["ID"].ToString() != "" ? Guid.Parse(sdr["ID"].ToString()) : enquiryDetail.ID);
enquiryDetail.EnquiryID = (sdr["EnquiryID"].ToString() != "" ? Guid.Parse(sdr["EnquiryID"].ToString()) : enquiryDetail.EnquiryID);
enquiryDetail.ProductSpec = (sdr["ProductSpec"].ToString() != "" ? sdr["ProductSpec"].ToString().Replace("$n$", "\n") : enquiryDetail.ProductSpec);
enquiryDetail.SpecTag = (sdr["SpecTag"].ToString() != "" ? Guid.Parse(sdr["SpecTag"].ToString()) : enquiryDetail.SpecTag);
enquiryDetail.Product = new Product()
{
ID = (sdr["ProductID"].ToString() != "" ? Guid.Parse(sdr["ProductID"].ToString()) : Guid.Empty),
Code = (sdr["ProductCode"].ToString() != "" ? sdr["ProductCode"].ToString() : string.Empty),
Name = (sdr["ProductName"].ToString() != "" ? sdr["ProductName"].ToString() : string.Empty),
HSNCode = (sdr["HSNCode"].ToString() != "" ? sdr["HSNCode"].ToString() :String.Empty)
};
enquiryDetail.ProductID = (sdr["ProductID"].ToString() != "" ? Guid.Parse(sdr["ProductID"].ToString()) : Guid.Empty);
enquiryDetail.ProductModelID = (sdr["ProductModelID"].ToString() != "" ? Guid.Parse(sdr["ProductModelID"].ToString()) : Guid.Empty);
enquiryDetail.ProductModel = new ProductModel();
enquiryDetail.ProductModel.ID = (sdr["ProductModelID"].ToString() != "" ? Guid.Parse(sdr["ProductModelID"].ToString()) : Guid.Empty);
enquiryDetail.ProductModel.Name = (sdr["ProductModelName"].ToString() != "" ? (sdr["ProductModelName"].ToString()) : enquiryDetail.ProductModel.Name);
enquiryDetail.ProductModel.CostPrice = (sdr["CostPrice"].ToString() != "" ? decimal.Parse(sdr["CostPrice"].ToString()) : enquiryDetail.ProductModel.CostPrice);
enquiryDetail.Qty = (sdr["Qty"].ToString() != "" ? decimal.Parse(sdr["Qty"].ToString()) : enquiryDetail.Qty);
enquiryDetail.Rate = (sdr["Rate"].ToString() != "" ? decimal.Parse(sdr["Rate"].ToString()) : enquiryDetail.Rate);
enquiryDetail.UnitCode = (sdr["UnitCode"].ToString() != "" ? int.Parse(sdr["UnitCode"].ToString()) : enquiryDetail.UnitCode);
enquiryDetail.Unit = new Unit();
enquiryDetail.Unit.Code = (sdr["UnitCode"].ToString() != "" ? int.Parse(sdr["UnitCode"].ToString()) : enquiryDetail.Unit.Code);
enquiryDetail.Unit.Description = (sdr["UnitDescription"].ToString() != "" ? (sdr["UnitDescription"].ToString()) : enquiryDetail.Unit.Description);
}
enquiryDetailList.Add(enquiryDetail);
}
}
}
}
}
}
catch (Exception ex)
{
throw ex;
}
return(enquiryDetailList);
}
