public Cost_Quote GetCostQuote(Cost_Quote costquote)
{
string fetchCostQuote = $"SELECT * FROM Mobifix_DB.COST_QUOTE WHERE LOWER (COST_QUOTE_ID) = '{ costquote.CostQuoteID.ToString() }'";
var dtResult = MySqlCostQuoteHelper.ExecuteQuery(fetchCostQuote);
var getcostquote = FillCostQuoteModel(dtResult);
return(getcostquote.FirstOrDefault <Cost_Quote>());
}
public IHttpActionResult DeleteCostQuote([FromBody] Cost_Quote costquote)
{
var costquoteRepo = new CostQuoteRepository();
var result = costquoteRepo.DeleteCostQuote(costquote);
if (result <= 0)
{
return(Ok("Error occurred while Deleting the contact type status"));
}
return(Ok("Deleted Contact Type status"));
}
public IHttpActionResult UpdateCostQuote([FromBody] Cost_Quote costquote)
{
var costRepo = new CostQuoteRepository();
var result = costRepo.UpdateCostQuote(costquote);
if (result <= 0)
{
return(Ok("Error occurred while updating cost quote"));
}
return(Ok("Cost Quote updated"));
}
public IHttpActionResult GetCostQuote([FromBody] Cost_Quote costquote)
{
var costquoteRepo = new CostQuoteRepository();
var getcostquote = costquoteRepo.GetCostQuote(costquote);
if (getcostquote == null)
{
return(NotFound());
}
return(Ok(getcostquote));
}
private IList <Cost_Quote> FillCostQuoteModel(DataTable dtCostQuote)
{
var costquoteList = new List <Cost_Quote>();
if (null != dtCostQuote && dtCostQuote.Rows.Count > 0)
{
foreach (DataRow row in dtCostQuote.Rows)
{
var costquote = new Cost_Quote();
costquote.CostQuoteID = Convert.ToInt32(row["COST_QUOTE_ID"]);
costquote.CreatedDate = Convert.ToDateTime(row["CREATED_DATE"]);
costquote.CreatedBy = Convert.ToInt32(row["CREATED_BY"]);
costquote.LastModifiedDate = Convert.ToDateTime(row["LASTMODIFIED_DATE"]);
costquote.CostQuoteIND = Convert.ToChar(row["COST_QUOTE_IND"]);
costquoteList.Add(costquote);
}
}
return(costquoteList);
}
public int DeleteCostQuote(Cost_Quote costquote)
{
string updateCostQuoteInfo = $"DELETE FROM Mobifix_DB.COST_QUOTE WHERE LOWER(COST_QUOTE_ID) = '{costquote.CostQuoteID.ToString()}' ";
return(MySqlCostQuoteHelper.ExecuteNonQuery(updateCostQuoteInfo));
}
public int UpdateCostQuote(Cost_Quote costquote)
{
string updateOrderInfo = $"UPDATE Mobifix_DB.COST_QUOTE SET COST_QUOTE_IND = '{costquote.CostQuoteIND}' WHERE LOWER(COST_QUOTE_ID) = '{costquote.CostQuoteID.ToString()}' ";
return(MySqlCostQuoteHelper.ExecuteNonQuery(updateOrderInfo));
}
