public ActionResult SaveProdQuality(ProdQualityEntity entity)
{
var user = (User)Session["CurrentUser"];
entity.UserName = user.EMPID;
entity.EDate = DateTime.Now;
var res = _repository.SaveProdQuality(entity);
return(Json(res, JsonRequestBehavior.AllowGet));
}
public string SaveProdQuality(ProdQualityEntity prodQuality)
{
string rv = "";
try
{
Insert_Update_ProdQuality("sp_insert_ProdQuality", "save_ProdQuality_data", prodQuality);
rv = Operation.Success.ToString();
}
catch (Exception ex)
{
rv = ex.Message;
}
return(rv);
}
public DataTable Insert_Update_ProdQuality(string procedure, string callname, ProdQualityEntity prodQuality)
{
_dbConn = new SqlConnection(_connectionString);
_dbConn.Open();
_cmd = new SqlCommand(procedure, _dbConn)
{
CommandType = CommandType.StoredProcedure
};
_cmd.Parameters.Add(new SqlParameter("@call_name", callname));
_cmd.Parameters.Add(new SqlParameter("@p_QID", prodQuality.QID));
_cmd.Parameters.Add(new SqlParameter("@p_QCode", prodQuality.QCode));
_cmd.Parameters.Add(new SqlParameter("@p_QName", prodQuality.QName));
_cmd.Parameters.Add(new SqlParameter("@p_UserName", prodQuality.UserName));
_cmd.Parameters.Add(new SqlParameter("@p_EDate", prodQuality.EDate));
_cmd.Parameters.Add(new SqlParameter("@p_Remarks", prodQuality.Remarks));
_cmd.Parameters.Add(new SqlParameter("@p_Rate", prodQuality.Rate));
_da = new SqlDataAdapter(_cmd);
_dt = new DataTable();
_da.Fill(_dt);
_dbConn.Close();
return(_dt);
}
public string SaveProdQuality(ProdQualityEntity prodQuality)
{
return(_dataService.SaveProdQuality(prodQuality));
}
